Configure, Monitor and Use Oracle Database 11g Flashback
Configuring Flashback Database Step # 1 Confirm that Flashback is enabled or not. SQL> Select flashback_on from v$database; FLASHBACH_ON ------------------------ NO Step # 2 Ensure that the database is in archivelog mode . Archivelog mode is a prerequisite for enabling Flashback Database. Confirm this by querying the V$DATABASE view SQL> Select Log_mode from v$database; LOG_MODE ---------------------- NOARCHIVELOG If the database is not in Archivelog mode then above result is displayed. Step # 3 Now switch Database to Archivelog mode SQL> Shutdown Immediate; SQL> Startup mount; SQL> Alter Database Archivelog; SQL> Select Log_mode from v$database; LOG_MODE ---------------------- ARCHIVELOG Step # 4 Set up a flash recovery area. The flash recovery area is the location for the flashback logs. You have no control over them other than setting the flash recovery area directory and limiting its size. It is controlled with t...