Restoring Oracle Tables in Container Databases using the RMAN Command Line

You can restore Oracle tables in container databases by using the RMAN command line.

Before You Begin

On Windows, the Oracle OS "oracle" user or the user that owns the oracle service must have write permissions to Windows event logs and to the auxiliary path specified in the RMAN script. For Unix, the "oracle" OS user must be able to write to the staging path.

Procedure

Use automatic channel allocation using the CONFIGURE CHANNEL command and do not allocate channels within the run block. You can use multiple channels for parallelism to improve performance.

Sample RMAN Script for Unix

Connect to RMAN and run commands similar to the following, outside the run block. Substitute any required or optional Oracle SBT parameters.

configure channel device type 'sbt_tape' PARMS="SBT_LIBRARY=$[/opt/commvault/Base/libobk.so],ENV=(CvInstanceName=$[Instance001])";
configure device type ‘sbt_tape’ parallelism $[4];

The following is the run block syntax:

 
run {
RECOVER $[schema_name].$[table_name] OF PLUGGABLE DATABASE $[pluggable_db_name]
UNTIL SCN $[scn]
AUXILIARY DESTINATION '$[staging_path]’;
}

The following is an example run block:

run {
RECOVER TABLE $[USERX.USERX_TABLE1] OF PLUGGABLE $[DATABASE srcpdb1]
UNTIL SCN $[10392707]
AUXILIARY DESTINATION '$[/home/oracle/staging_path]';
}

Sample RMAN Script for Windows

Connect to RMAN and run this command outside the run block:

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM $[4]

The following is an example run block:

run {
RECOVER TABLE $[PDBORA2_USER1.TAB1] OF PLUGGABLE $[DATABASE pdbora2]
UNTIL SCN $[1516408]
AUXILIARY DESTINATION '$[E:\staging]';
}