By using flashback technology we can restore the database to a particular point in past. It’s like time machine.

Here we will see , how to enable and disable flashback in oracle.

 

ENABLE FLASHBACK:

 

Make sure the database is in archive log mode :

Refer : How to enable and disable archive log 
To enable flashback we need to set two parameters: DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE

Turn on flashback:

 

DISABLE FLASHBACK:

NOTE: If you are in 10g, then we need to enable/disable the flashback mode in mount stage,

shutdown immediate
startup mount
alter database flashback off;
alter database open;

 

 

SEE ALSO – COMPLETE COLLECTION OF DATABASE SCRIPTS