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 opened in read-only mode to check if the database has been
flashed back to the correct SCN.
C.
The database must be opened with the RESETLOGS option after the flashback is
complete.
D.
The database must be MOUNTED for the flashback to succeed.
E.
The database must use block change tracking for the flashback to succeed.
F.
The database must be opened in restricted mode for the flashback to succeed.
I have learn several excellent stuff here. Certainly price bookmarking for revisiting. I wonder how a lot effort you put to make any such fantastic informative website.
http://www.bastcilkdoptb.com/
CD
https://docs.oracle.com/database/121/RCMRF/rcmsynta023.htm#RCMRF194
“RMAN must be connected as TARGET to a database, which must be Oracle Database 10g or later. The target database must be mounted with a current control file, that is, the control file cannot be a backup or re-created. The database must run in ARCHIVELOG mode.”
“State of the Database After Flashback Database
If you are satisfied with the results of the flashback, then you can OPEN RESETLOGS to abandon all changes after the target time. Alternatively, you can use Data Pump to export lost data, use RECOVER DATABASE to return the database to its state before the flashback operation, and then use Data Pump to reimport the lost data.”
C and D are correct