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;