Oracle Flashback Database, allows to quickly recover the entire database from logical data corruptions or user errors. It is very similar to PITR (Point In Time Recovery) which puts back the database to a state at a particular time in recent past.

1. Place your database in mount stage.

2. Set DB_FLASHBACK_RETENTION_TARGET to the requried minutes to have the flashback window. By default, the value would be 1440 minutes (1 day)

3. Enable Flashback on the database

4. Finally open the database

5. You can check if the database is enabled with Flashback or not

Leave a Reply