Which two statements are true about this? (Choose two)

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)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *