RMAN Example: Restoring from an Oracle Secondary Copy

If the primary copy of the database is not available, in this example, you can restore from a secondary copy.

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. 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.

Procedure

1. Create an RMAN script similar to the one below, which includes the CV_restCopyPrec environmental variable.

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

   The restore.txt example script.

    
   run
    { allocate channel ch1 type 'sbt_tape'
    PARMS="SBT_LIBRARY=software_installation_path/Base/libobk.so,ENV=(CV_restCopyPrec=2)”;
    allocate channel ch2 type 'sbt_tape'
    PARMS="SBT_LIBRARY=software_installation_path/Base/libobk.so,ENV=(CV_restCopyPrec=2)”; 
    allocate channel ch3 type 'sbt_tape'
    PARMS="SBT_LIBRARY=software_installation_path/Base/libobk.so,ENV=(CV_restCopyPrec=2)”;
    restore database ;
    recover database ;
    sql "alter database open"; }

2. On the RMAN command line, run the following command to connect to the target database.

   rman target sys/sys@dbtnsname

3. On the RMAN command line, run the RMAN script.

   @restore.txt