RMAN Example: Restoring Oracle Individual Tablespaces to a SCN

Restore a corrupted Oracle tablespace to a specific System Change Number (SCN).

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. 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 SCN scn_number auxiliary destination 'path_for_auxiliary_instance'; }

Example

RMAN> RUN {
recover tablespace test1 until SCN 3513561 auxiliary destination '/u01/tspit/';}