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

If you added a data file or a tablespace to the database after your last RMAN
backup, RMAN will add that tablespace or data file for you automatically
during a restore. Additionally, RMAN will recreate any tempfiles needed
during a restore process automatically.
In Exercise 5.1, you'll restore your ARCHIVELOG-mode database with RMAN.
e xeRCiSe 5.1
Restoring Your ARChivelOG-Mode Database with RMAN
This activity builds on the backup done in Exercise 3.2 from Chapter 3. You should have
completed Exercise 3.2 prior to executing this activity. Please note that the output you
experience from this exercise will probably differ from the output shown in this exercise.
1. Complete Exercise 3.2.
2. Log into the database as SYS using SQL*Plus:
C:\oracle>set oracle_sid=orcl
C:\oracle>sqlplus sys as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Fri Dec 27 10:20:57 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
SQL>
3. Determine the location of the database data files by issuing the SELECT FILE_NAME
FROM DBA_DATA_FILES; query:
SQL> select file_name from dba_data_files;
FILE_NAME
---------------------------------------------------------------------
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\DATAFILE\O1_MF_USERS_4G2Q1YTC_.DBF
C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
4. Shut down the database:
SQL> shutdown abort
ORACLE instance shut down.