RMAN Example: Performing Multiple Stream Oracle Restores

You can use multiple channels for RMAN restores that use multiple streams.

Before You Begin

1. If you run the RMAN script on a UNIX environment, relink the SBT library or use PARMS in the Allocate Channel Command.

2. Use a unique backup piece format to avoid conflicting backup piece names.

3. Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

4. Optional: When the backup pieces are unknown to the RMAN repository, catalog the backup pieces. For more information, see Cataloging RMAN Backup Pieces.

Procedure

1. On the RMAN command line, run the following sample script, substituting any required or optional Oracle SBT parameters.

   For information on required and optional SBT parameters, see SBT Parameters.

    
   run 
   { allocate channel ch1 type 'sbt_tape' 
    PARMS="SBT_LIBRARY=software_installation_path/Base/libobk.so,BLKSIZE=1048576";
    allocate channel ch2 type 'sbt_tape' PARMS="SBT_LIBRARY=software_installation_path/Base/libobk.so,BLKSIZE=1048576";
    allocate channel ch3 type 'sbt_tape' PARMS="SBT_LIBRARY=software_installation_path/Base/libobk.so,BLKSIZE=1048576";
    restore database ;
   recover database ; 
    sql "alter database open"; }

2. Optional: To have a single job ID application command line backups and restores when an Oracle instance is discovered or created from the command line and there is not a CommCell backup, use the following the allocate channel command syntax:

    
   allocate channel ch1 type 'sbt_tape'
   PARMS="SBT_LIBRARY=software_installation_path/Base/libobk.so,BLKSIZE=1048576,
   ENV=(CvOraSID=OracleSID)”;

3. If you use the Oracle Enterprise Manager application, include the RMAN SBT settings.

   UNIX

    
   SBT_LIBRARY=software_installation_path/Base/libobk.so, BLKSIZE=1048576

   No additional configuration is required for Windows.