Flashback Database - Limitations

Limitations of Flashback Database Feature

1. Database must be running in archivelog mode.

2. There should not be any media failure.

3. If a control file has been restored or recreated during the time span you want to flashback over, then you can’t use the flashback feature.

4. You can’t flash back a database to before a reset logs operation.

5. You can’t flash back a data file that was shrunk or dropped during the time span covered by the flashback table operation.

Thanks