configuration of flashback database on oracle database.

By enabling flashback database we can bring our database to an earlier point-in-time without restoring from backups. This feature of oracle database enables us to undo changes that have been resulted in a logical data corruptions.

The steps for configuration of flashback database are as follows:

-----configure the fast recovery area
SQL> conn sys/orcl@to_primary as sysdba
Connected.
 SQL> alter system set Log_archive_dest_1='Location=USE_DB_RECOVERY_FILE_DEST' scope=both;
 System altered.
SQL>

  -----set the retention target
SQL> alter system set db_flashback_retention_target=2200 scope=both;
 System altered
  
-----enable flash back database
 SQL> Alter database flashback on;
 Database altered.

  ---Check whether flashback is enabled or not by running  the following SQL code
 SQL> select flashback_on from v$database;
 FLASHBACK_ON
------------------
YES

----Check whether recyclebin parameter is enabled or not by running the following SQL code
SQL> show parameter recyclebin;
 NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
recyclebin                           string      on