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

e xeRCiSe 5.1 (continued)
channel ORA_DISK_1: reading from backup piece
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_03
\O1_MF_NNNDF_TAG20131003T001928_4GCGCQQ4_.BKP
channel ORA_DISK_1: piece
handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_03
\O1_MF_NNNDF_TAG20131003T001928_4GCGCQQ4_.BKP tag=TAG20131003T001928
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:05
Finished restore at 10/03/2013 00:43:02
RMAN>
14. Recover the database with the RECOVER DATABASE command:
RMAN> recover database;
Starting recover at 10/03/2013 01:43:59
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:04
Finished recover at 10/03/2013 01:44:05
RMAN>
15. Open the database with the ALTER DATABASE OPEN command:
RMAN> alter database open;
database opened
The database is open.
We move back and forth between SQL*Plus and RMAN a lot in our exam-
ples. In Oracle Database 12 c , you can choose to execute almost all of these
queries from the RMAN prompt if you prefer.
Data File or Tablespace Recovery in ARCHIVELOG Mode
If you have lost one or a few database data files, or perhaps all the data files lost are part
of a tablespace, you can perform recovery actions specific to those few lost data files rather
than to the database as a whole. Data file recoveries and tablespace recoveries can be far
faster than recovering the entire database with a complete recovery.