Performing Incomplete Recovery - RMAN Recipes for Oracle Database 12c - page 386

• Tablespace cannot contain undo or rollback segments

• Tablespace cannot contain objects owned by SYS such as PL/SQL packages, Java classes,

and so on

Ti ■ a wide variety of features are available with TSpiTr. This recipe covers only the automated rman tablespace
point-in-time recovery. for complete details on all features of TSpiTr, see the oracle Backup and recovery User's guide.

Recovering a Subset of Data Files
Problem
You want to perform incomplete recovery on a subset of data files in your database.

Solution
The basic procedure is to determine which datafiles you don't want to restore and recover and then use alter
database datafile ... offline for drop for the data files to be excluded.

■ Caution The data files you offline drop using this procedure will not be available for subsequent restore and recovery

operations.

Here are the RMAN commands to perform an incomplete recovery on a subset of data files in your database:

$ rman target /
RMAN> startup mount;

Use the RMAN report schema command to identify which data files you do not want to restore and recover. You
can also query V$DATAFILE for the data file details. In this example, the data file 5 is taken offline before the restore
and recovery:

RMAN> alter database datafile 5 offline for drop;

If you're using Oracle Database 11 g or lower, you must use the sql command to run the prior command:

RMAN> sql 'alter database datafile 5 offline for drop';

Next restore and recover the database:

RMAN> restore database until sequence 5;
RMAN> recover database until sequence 5;
RMAN> alter database open resetlogs;