Enable and disable Oracle Flashback

1. Open flashback:

Close Database

SQL> shutdown immediate;

Mount Mode

SQL> startup mount;

If the archive is not enabled, open archive [because flashback depends on Media recovery, archive must be enabled before flashback is enabled]

SQL> alter database archivelog;

Enable Flashback

SQL> alter database flashback on;

 

2. Disable flashback:

Close the database:

SQL> shutdown immediate

Mount Mode

SQL> startup mount;

Disable Flashback

SQL> alter database flashback off;

 

To enable and disable the Oracle flash back, pay attention to the following points:

1. The premise of flashing is that the database archive must be opened.

2. Flash back open/close is the same as Archive open/close, all in mount Mode

3. If you want to close the archive on the database with the flash back enabled, you must first disable the flash back function dependent on the archive.

Check whether flashback is Enabled: select name, flashback_on from v $ database; check whether the flash recovery zone and size are set: show parameter db_recovery; first set the size of the flash recovery zone: alter system set db_recovery_file_dest_size = '2g '; then, set the path of the flash recovery zone: alter system set db_recovery_file_dest = 'e: \ oracle \ product \ 10.2.0 \ db_recovery_file_dest, the default value is 1440 minutes per day: alter system set db_flashback_retention_target = 1440;