How to enable Flashback features

Flash back features:-

The init.ora  or pfile  parameter required for this features.

Db_recovery_dest_size=4GB

Db_recovery_dest=’/u01/recovery_dest’;

How to enable the flash recovery area?

In mount stage set the retention period for the flashback feature.

SQL>shutdown immediate

SQL>startup mount

SQL> alter system set db_flashback_retention_target=[value] the value is in terms of minutes. Example:-4320 is for 3 days.

SQL> alter database flashback on;

The flashback feature will be enabled for all permanent tablespace. If you are interested in making some tablespace’s flashback feature disable. This can be done by below command.

SQL>alter tablespace [x] flashback off;