RMAN Example: Restoring Oracle Individual Tablespaces to a Point-in-Time

Restore a corrupted Oracle tablespace to a point-in-time.

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. Clear the Oracle Flashback area so that RMAN uses the Commvault objects when performing the restore.

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

Procedure

1. On the RMAN command line, set the SBT CHANNEL parameter:

    
   RMAN> CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' PARMS="SBT_LIBRARY= software_installation_path/Base/libobk.so, BLKSIZE=1048576";

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

   You can also run this command from the CommCell Console using the customized script option.

    
   RMAN> RUN {
    recover tablespace tablespace_name until time time_stamp auxiliary destination 'path_for_auxiliary_instance'; }

Example

RMAN> RUN {
 recover tablespace test1 until time = "TO_DATE('02/12/2013 16:58:43','HH24:MI:SS')" auxiliary destination '/u01/tspit/'; }