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

exeRCiSe 5.2 (continued)
3. Start RMAN. We will assume you are not using a recovery catalog during this exercise.
C:\oracle>rman target=/
Recovery Manager: Release 12.1.0.1.0 - Production on Fri Dec 27 10:23:32 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
4. Start up the database with the STARTUP FORCE MOUNT command from RMAN:
RMAN> startup force mount
Oracle instance started
database mounted
Total System Global Area 364081152 bytes
Fixed Size 1333228 bytes
Variable Size 264243220 bytes
Database Buffers 92274688 bytes
Redo Buffers 6230016 bytes
5. Determine the current backups that are available for restore with the LIST BACKUP OF
DATABASE SUMMARY command (to be discussed in Chapter 6):
RMAN> list backup of database summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
6 B F A DISK 09/29/2013 14:07:23 1 1 NO
SILVER_COPY
11 B F A DISK 10/02/2013 00:46:25 1 1 YES
GOLD_COPY
17 B F A DISK 10/03/2013 00:25:19 1 1 YES
TAG20131003T001928
6. From the output generated in step 5, choose the date and time of the most current
backup (in our case, it's 10/03/2013 at 00:25:19). We will restore the database to 10
minutes after this date and time (in our case, 10/03/2013 at 00:35:19).
7. Issue the RESTORE DATABASE UNTIL TIME command to restore the database to the
date and time selected. In our case, the command will be RESTORE DATABASE UNTIL
TIME '10/03/2013:00:35:19' ; your command will have a different date and time
(unless you have reset the clock so precisely that you got the same date!).
RMAN> restore database until time '10/03/2013:00:35:19';
Starting restore at 10/03/2013 01:57:31