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 corruption?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
E.
Option E
I think B is correct.
From RESTORE and RECOVE commands docs: UNTIL TIME ‘date_string’ specifies a time as an uppen, noninclusive limit. NONINCLUSIVE! To restore database and minimize data lost B is suitable then C.
Logical corruption was introducedat 6:30 pm => 6:pm = 18h30 so B is incorrect
I think that the exhibit was changed at some point. That is why the gentlemen above suggest a different answer.
C is the correct answer. You are required to perform incomplete recovery(i.e. point-in-time recovery) of the database to the point in time before the logical corruption that was introduced at 6:30pm. The time format will be 18:29:55 (which is 6:29pm), this time came before the lgical corruption that was introduced at 6:30pm.
Answer is C
@bs is correct.
I suggest reading …
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsubcl019.htm#RCMRF160
Look for the entry on …
UNTIL TIME
Specifies a time as an upper, noninclusive limit.
This example, which assumes a mounted database, recovers the database up to (but not including) the specified SCN:
STARTUP FORCE MOUNT
RUN
{
SET UNTIL SCN 1418901; # set to 1418901 to recover database through SCN 1418900
RESTORE DATABASE;
RECOVER DATABASE;
}
ALTER DATABASE OPEN RESETLOGS;
Answer B could also work but C is just better.