Which situation can you use Flashback Database?

In which situation can you use Flashback Database?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. http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194

Question:

Which situation can you use Flashback Database?

Options:

when undoing a shrink data file operation

when retrieving a dropped tablespace

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

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

Correct Answer

The Correct Answer for this Question is

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

Leave a Comment