4 Replies Latest reply: Aug 25, 2010 8:01 AM by Aman.... RSS

    ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt

    user13364377
      what are the scenarios that we have to use the below statement.

      RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
        • 1. Re: ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt
          Girish Sharma
          For :

          1.Deleting a Backup Set
          2.Crosschecking Archived Logs
          3.Crosschecking on Multiple Nodes of an Oracle Real Application Clusters Configuration
          4.Deleting on Disk and sbt Channels with One Command

          All from http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta005.htm

          HTH
          Girish Sharma
          • 2. Re: ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt
            Aman....
            user13364377 wrote:
            what are the scenarios that we have to use the below statement.

            RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
            http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta005.htm
            To manually allocate a channel in preparation for issuing a CHANGE, DELETE, or CROSSCHECK command.
            HTH
            Aman....
            • 3. Re: ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt
              dbaforu
              first you have to understand why we allocate channel for rman..it crates a session to target database,To manually allocate a channel, which is a connection between RMAN and a database instance. Each connection initiates an Oracle server session on the target or auxiliary instance: this server session performs the work of backing up, restoring, or recovering backup sets and copies.

              Restrictions and Usage of this command
              ----------------------------------------------------



              Execute this command only at the RMAN prompt. This command cannot be used within a RUN block.
              *

              The target instance must be started.
              *

              Do not specify a channel ID.
              *

              You cannot allocate a maintenance channel to a shared session.
              *

              You cannot prefix ORA_ to a channel name. RMAN reserves channel names beginning with the ORA_ prefix for its own use.
              *

              Manually allocated channels (maintenance or normal channels) and automatic channels based on configured settings are never mixed. To perform maintenance on both disk and SBT simultaneously using manually allocated maintenance channels, you must allocate both SBT and DISK channels explicitly.
              *

              If you use ALLOCATE CHANNEL FOR MAINTENANCE, then RMAN uses the following convention for channel naming: ORA_MAINT_devicetype_n, where devicetype refers to DISK or sbt and n refers to the channel number. For example, RMAN uses these names for two manually allocated disk channels:

              ORA_MAINT_DISK_1
              ORA_MAINT_DISK_2


              *

              You can allocate multiple maintenance channels for a single job, but you should only use this feature in these situations:
              o

              To allow crosschecking or deletion of all backup pieces or proxy copies, both on disk and tape, with a single command
              o

              To make crosschecking and deleting work correctly in an Oracle Real Application Clusters configuration in which each backup piece or proxy copy exists only on one node



              here is some example of this command you should check this..



              Deleting a Backup Set: Example This example deletes backup sets from tape created more than a week ago:

              ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
              DELETE NOPROMPT BACKUP OF DATABASE COMPLETED BEFORE 'SYSDATE-7';

              Crosschecking Archived Logs: Example This example crosschecks all archived logs on disk and tape. For disk, the preconfigured disk channel is used; for tape, an SBT channel is allocated manually. If the logs are not found, then RMAN marks them as EXPIRED in the repository:

              ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
              CROSSCHECK ARCHIVELOG ALL;

              Crosschecking on Multiple Nodes of an Oracle Real Application Clusters Configuration: Example In this example, you perform a crosscheck of backups on two nodes of an Oracle Real Application Clusters configuration, where each node has access to a subset of backups. It is assumed here that all backups are accessible by at least one of the two nodes used in the crosscheck. Any backups not accessible from at least one of the nodes are marked EXPIRED after the crosscheck.

              ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK CONNECT 'SYS/change_on_install@inst1';
              ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK CONNECT 'SYS/change_on_install@inst2';
              CROSSCHECK BACKUP;
              • 4. Re: ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt
                Aman....
                What was the need to copy the entire content of the link which is already posted twice here?

                Aman....