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 4

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

Mia

Mia

I think its D.
Because in Oracle Document says:
Use the FLASHBACK DATABASE command to rewind the database to a target time, SCN, or log sequence number.

This command works by undoing changes made by Oracle Database to the data files that exist when you run the command. Flashback can fix logical failures, but not physical failures.
Not B: Thus, you cannot use the command to recover from disk failures or the accidental deletion of data files.
Not C: You cannot use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file.
https://docs.oracle.com/html/E10643_07/rcmsynta023.htm

Reply