Showing posts with label Flashback. Show all posts
Showing posts with label Flashback. Show all posts

09 June 2010

How to Enable Flashback Database

To enable flashback database the following operations is needed.


1)Configure the Database in archivelog mode.

To change archiving read, Change Archival Mode

2)Configure Flash Recovery Area.
To configure flash recovery area,
Set up Flash Recovery Area

Set Up a Flash Recovery Area for RMAN

Flash recovery area simplifies the ongoing administration of your database by automatically naming recovery-related files, retaining them as long as they are needed for restore and recovery activities, and deleting them when they are no longer needed to restore your database and space is needed for some other backup and recovery-related purpose.


To see up flash recovery follow below steps.