Which two statements are true about this?

You plan to execute the following command to perform a Flashback Database operation in your database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);
exhibit 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:
Section: Flashback Operations & Configuration

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 1

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


Justyna

Justyna

“Note: The database must be mounted in exclusive mdoe to issue the FLASHBACK DATABASE command and opened read-only to review chnages. The database must be opened read/write with the RESETLOGS option when finished.”

Oracle Database 11g: Administration Workshop II