OCP 1Z0 053 191

191.While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of 
corrupted data into the database. Pablo has discovered this problem and he needs you to recover the 
database to the point in time prior to the introduction of the corruption. The logical corruption was 
introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to 
use to restore the database to a point in time before the orruption? 
A. restore database until time '06-SEP-2008 06:30:00'); recover database until time '06-SEP-2008 
06:30:00'); alter database open; 
B. restore database until time '06-SEP-2008 06:30:00'); recover database until time '06-SEP-2008 
06:30:00'); alter database open resetlogs; 
C. restore database until time '06-SEP-2008 18:29:55'); recover database until time '06-SEP-2008 
18:29:55'); alter database open resetlogs; 
D. restore database until time '06-SEP-2008 18:29:55'); alter database open resetlogs; 
E. restore database until time '06-SEP-2008 18:29:55'); recover database; alter database open resetlogs; 
Answer: C 


对题中 18:29:55的说法存疑

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmflash.htm#BRADV349

Restore and recover the database, performing the following actions in the RUN command:

• Set the end time for recovery to the time just before the loss of the data.

• Allocate any channels required that are not already configured.

• Restore the control file from the October 2 backup and mount it.

• Restore the data files and recover the database. Use the RECOVER DATABASE ... UNTIL command to perform DBPITR, bringing the database to the target time of 7:55 a.m. on October 8, just before the data was lost.

The following example shows all of the steps required in this case:

RUN{  SET UNTIL TIME 'Oct 8 2007 07:55:00';   RESTORE CONTROLFILE;  # without recovery catalog, use RESTORE CONTROLFILE FROM AUTOBACKUP  ALTER DATABASE MOUNT;   RESTORE DATABASE;  RECOVER DATABASE;}ALTER DATABASE OPEN RESETLOGS;