RMAN Example: Restoring Oracle Backups in a Clustered Environment

Restore Oracle backups in a clustered environment.

Before You Begin

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

2. Perform Backups for Oracle in a Clustered Environment.

3. Put the database in MOUNT mode.

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

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

Procedure

• On the RMAN command line, run the following sample script, substituting any required or optional Oracle SBT parameters. Use CvClientName to specify the virtual client name in the CommCell Console.

  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,
  ENV=(CvClientName=virtual_client_name)”;
  allocate channel ch2 type 'sbt_tape'
  PARMS="SBT_LIBRARY=software_installation_path/Base/libobk.so,BLKSIZE=1048576,
  ENV=(CvClientName=virtual_client_name)”; 
  restore database ;
  recover database;
  sql "alter database open"; }