FLASHBACK DATABASE

Posted on Posted in Uncategorized

Please keep in mind till the Transactions are in Undo until then the DB can be restored ..

To take Restore Point ..

SQL> select flashback_on from v$database;

FLASHBACK_ON
——————
NO

SQL> Alter database flashback on;

CREATE RESTORE POINT Jan07_2107;

conn / as sysdba

shutdown immediate;

startup mount;

flashback database to restore point Jan07_2107;

alter database open resetlogs;

 

Guaranteed Restorepoint can be taken using below command :

CREATE RESTORE POINT Jan07_2107 GUARANTEE FLASHBACK DATABASE;

Leave a Reply

Your email address will not be published. Required fields are marked *

65 ÷ 13 =