which situation can you use Flashback Database?

In which situation can you use Flashback Database?

In which situation can you use Flashback Database?

A.
when undoing a shrink data file operation

B.
when retrieving a dropped tablespace

C.
when returning to a point in time before the restoration or re-creation of a control file

D.
when returning to a point in time before the most recent open resetlogs operation

Show Hint

Leave a Reply 2

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

Mohamed

Mohamed

My Answer is: D
Reference is: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm

“TO BEFORE RESETLOGS” Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS.

Note: FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database 10g Release 2 or later.

Reply