How to enable flashback database in Oracle

-- Set flashback database parameters


alter system set db_recovery_file_dest_size=10G;

alter system set db_recovery_file_dest='/dir/fra';

-- value in minutes

alter system set db_flashback_retention_target=2160;

-- Turn flashback on for the database

startup mount;

alter database flashback on;

alter database open;

-- Check if flashback is enabled

select flashback_on from v$database;

select * from v$flashback_database_log;
--
--
-- To create a guaranteed restore point

create restore point RESTORE_POINT guarantee flashback database;

select NAME, SCN, TIME from V$RESTORE_POINT;

-- To flashback the database to specific time

flashback database to timestamp to_timestamp('dd/mm/ccyy HH24:MI:SS', 'DD/MM/YYYY

HH24:MI:SS');

-- To drop a restore point

select NAME, SCN, TIME from V$RESTORE_POINT;

drop restore point RESTORE_POINT;