Flashback usage
Posted: Tue Dec 22, 2015 11:53 am
alter system set db_recovery_file_dest_size =50g scope=both sid='*';
alter system set db_recovery_file_dest = '+FLASH_DG' scope=both sid='*';
alter system set db_flashback_retention_target = 1440 scope=both sid='*';
alter database flashback on;
create restore point guar_restore guarantee flashback database;
Do some work stuff.
select name, scn, time, database_incarnation#, guarantee_flashback_database,storage_size from v$restore_point;
drop restore point guar_restore;
alter database flashback off;
alter system set db_recovery_file_dest = '+FLASH_DG' scope=both sid='*';
alter system set db_flashback_retention_target = 1440 scope=both sid='*';
alter database flashback on;
create restore point guar_restore guarantee flashback database;
Do some work stuff.
select name, scn, time, database_incarnation#, guarantee_flashback_database,storage_size from v$restore_point;
drop restore point guar_restore;
alter database flashback off;