Flashback usage

Oracle Tips and Tricks
Post Reply
thockman
Site Admin
Posts: 104
Joined: Thu Dec 15, 2005 5:51 pm
Location: Kansas City
Contact:

Flashback usage

Post by thockman » 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;

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest