RMAN Example: Performing Oracle Multi Stream Backups

Oracle application command line operations running on multiple streams, share the same Job ID in the Job Manager. If all the streams return the status as failure, then the job is marked as failed. If one of the streams fails, it is submitted to the other stream for completion.

By default, each stream in an Oracle operation with multiple streams, uses a different drive.

When there are different storage policies for archive log, and command line backups:

• Data and log command line backups use the log storage policy for the log portion of the backup, and the command line storage policy for the datafiles

• Control file backups use the command line storage policy

Before You Begin

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

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

Procedure

1. If you use the OEM application with multiple channels, include the RMAN settings in the Oracle Enterprise Manager.

   UNIX

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

   There is no additional configuration required for Windows.

2. Create and save an RMAN script file to run the backup operation with a single job ID.

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

   Optional: When the Oracle instance is discovered or created from the command line, and you do not perform a CommCell backup, or the Oracle instance and database name are different, use the following allocate channel syntax to have a single job id for backups and restores.

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

   Example

   Create an RMAN script called backup1.txt.

    
   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";
   setlimit channel ch1 maxopenfiles 1;
   setlimit channel ch2 maxopenfiles 1;
   backup
   incremental level = 0
   filesperset =4 format '%d_%U_%t'
   database include current controlfile;
   sql "alter system archive log current";
   backup filesperset =4
   (archivelog all delete input); }

3. On the RMAN command line, connect to the target database.

    
   rman target sys/sys@dbtnsname

4. On the RMAN command line, go to the RMAN script location and type the following:

    
   @file_path_backup1.txt