This is an old revision of the document!
Table of Contents
Flashback
Enable Flashback while database is open (11g+)
0@@
Enable flashback
exec dbms_flashback.enable;
Disable flashback
exec dbms_flashback.disable;
Put a session back in time
Note: undo_management must be auto<br> Note: Take a look at undo_retention to get an idea of how far back you might be able to go. exec dbms_flashback.enable_at_time(to_date('24-AUG-2012 12:00:00', 'DD-MON-YYYY HH24:MI:SS'));
Set the database recovery directory and size
alter system set db_recovery_file_dest='<path>' scope=both; alter system set db_recovery_file_dest_size=<size> scope=both;
Use flashback to recover data deleted from a table
1@@
Enable flashback on Standby database
select flashback_on from v$database; alter system set db_recovery_file_dest_size=50G scope=both; alter system set db_recovery_file_dest=’/<directory>/’ shutdown immediate; startup mount; alter database flashback on; show parameter db_flashback_retention_target; alter system set db_flashback_retention_target=2880 scope=both; alter database recover managed standby database cancel;
How far back can we flashback the database?
2@@