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

exeRCiSe 5.2 (continued)
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=155 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to
C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00002 to
C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
channel ORA_DISK_1: restoring datafile 00003 to
C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00004 to
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\DATAFILE\O1_MF_USERS_4G2Q1YTC_.DBF
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:07:15
Finished restore at 10/03/2013 02:04:47
8. Recover the database with the RECOVER DATABASE UNTIL TIME command. Our com-
mand would be RECOVER DATABASE UNTIL TIME '10/03/2013:00:35:19' ; your com-
mand will have a different date and time.
RMAN> recover database until time '10/03/2013:00:35:19';
Starting recover at 10/03/2013 02:06:01
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 10/03/2013 02:06:05
9. Open the database with the ALTER DATABASE OPEN RESETLOGS command:
RMAN> alter database open resetlogs;
Statement processed
The database is open. You would want to perform a complete backup after this recovery.