You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE – 5/24);
Which two statements are true about this flashback scenario?
A.
The database must have multiplexed redo logs for the flashback to succeed.
B.
The database must be MOUNTED for the flashback to succeed.
C.
The database must use block change tracking for the flashback to succeed.
D.
The database must be opened in restricted mode for the flashback to succeed.
E.
The database must be opened with the RESETLOGS option after the flashback is complete.
F.
The database must be opened in read-only mode to check if the database has been flashed
back to the correct SCN.
Explanation:
B: The target database must be mounted with a current control file, that is, the
control file cannot be a backup or have been re-created.
D: You must OPEN RESETLOGS after running FLASHBACK DATABASE. If datafiles are not
flashed back because they are offline, then the RESETLOGS may fail with an error.
Note:
* RMAN uses flashback logs to undo changes to a point before the target time or SCN, and then
uses archived redo logs to recover the database forward to make it consistent. RMAN
automatically restores from backup any archived logs that are needed.
* SCN: System Change Number
* FLASHBACK DATABASE to One Hour Ago: Example
The following command flashes the database by 1/24 of a day, or one hour:
RMAN> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE-1/24);
The database needs to be mounted to do the flashback
The database must be opened with the RESETLOGS option after the flashback is complete.
So answer is B and E
B is also wrong. It needs to be mount exclusive .
F is correct since we will open the database to check whether it is flashback to required state.
so E and F
B is correct. I use it a lot in my work
B is correct, there is no need to be exclusive as per oracle document
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmflash.htm#BRADV80055
Here is example for version 12c.
Performing Flashback Database with SQL*Plus
http://docs.oracle.com/cd/E16655_01/backup.121/e17630/osrecvry.htm#CHDBIFHI
BE
B and E
BF, You can open in read only mode database. And this is the best practice. But also if I sure about SCN – I can not do it. The question why “must be opened” presents here :).
BF, You can open in read only mode database. And this is the best practice. But also if I sure about SCN – I can not do it. The question why “must be opened” is presented here :).
BE are correct We know exactly that we are flashing back the db before 5 hours. If we were to flashback with scn then BF would be correct.
BE is final answer
BE
If they ask for 3 choices, then B,E,F are correct.
If they ask for 2 choices, then it would be B, E
Thats correct BEF.
F – is used to verify before you perform E
B,E
The database is flashed back by time and not by SCN, so why we should check for the SCN???
BE
BE – agree with JJ
BE
F says “must” but it is an optional step, so BE