You plan to execute the following command to perform a Flashback Database operation in your
database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);
Which two statements are true about this? (Choose two)
A.
The database must have multiplexed redo log files
B.
The database must be in the MOUNT state to execute the command
C.
The database must be in the NOMOUNT state to execute the command
D.
The database must be opened in RESTRICTED mode before this operation
E.
The database must be opened with the RESETLOGS option after the flashback operation
Explanation:
http://www.di.unipi.it/~ghelli/didattica/bdldoc/B19306_01/server.102/b14200/statements_9011.htm
Use the FLASHBACK DATABASE statement to return the database to a past time or system
change number (SCN). This statement provides a fast alternative to performing incomplete database recovery.
Following a FLASHBACK DATABASE operation, in order to have write access to the flashed back
database, you
must reopen it with an ALTER DATABASE OPEN RESETLOGS statement.
http://www.idevelopment.info/data/Oracle/DBA_tips/SQL/SQL_4.shtml
