Enabling / Disabling Flashback Database in 11gR2

Flashback database was introduced in Oracle 10g and offer's a simple way for performing a point in time recovery. To enable this, your database must be running in archivelog mode and flash recovery must be enabled. In 10g We would have had to issue the following commands: But with 11gR2, We can now turn flashback on / off, when the database is OPEN We can check the current status of flashback. Lets set the flashback retention target Now with the database open, we will set the flashback on. Now with the database open, we will set the flashback off. Lets enable the flashback. Check the flashback retention After a while if you run the following you can see how far we can flashback the database.