Recovering Databases with RMAN - OCP: Oracle Database 12c Administrator Certified Professional - page 203

handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_09_28
\O1_MF_NNNDF_TAG20130928T172015_4G049OQX_.BKP tag=TAG20130928T172015
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:35
Finished restore at 28-SEP-13
RMAN> recover tablespace system;
Starting recover at 28-SEP-13
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 28-SEP-13
RMAN> alter database open;
database opened
Restoring Data Files to Different locations
If during a recovery you need to restore data files to a different location, you will need
to use the RMAN SET NEWNAME command to reset the location of each data file that is
to be relocated. For example, if you wanted to relocate the USERS01.DBF data file from
c:\oracle\oradata\orcl to d:\oracle\oradata\orcl during an RMAN recovery, you
would issue this command:
set newname for 'c:\oracle\oradata\orcl\users01.dbf' to
'd:\oracle\oradata\orcl\users01.dbf';
Note that if you use the SET NEWNAME command, you will have to include it and all restore-
and-recovery-related commands within a RUN block, as shown here:
run { set newname for datafile 'c:\oracle\oradata\orcl\users01.dbf' to
'c:\oracle\oradata\orcltwo\users01.dbf';
restore database;
recover database; }
This section maps to objectives that include restoring index tablespaces.