Create Normal and Guaranteed Restore Point in Oracle Database for Recovery

Whenever DBA are doing any major activity which can potentially a critical activity and can corrupt your oracle database then we should create a restore point in order to recover from any unfortunate situation.


For guaranteed restore point you should have following:

a. Compatible init parameter should be above 10.2 
b. Database must be running in archivelog status.
c. Flash recovery area should be configured


Create Normal and Guaranteed Restore Point  

a.  Normal Restore Point.

     sql> create restore point <resotore_point_name> ;

b. Guaranteed Restore Point
     
     sql> create restore point <resotore_point_name> guarantee flashback 
            database;


Confirm the Restore Point Creation:

col SCN for 999,999,999,999,999
col time for a50
col name for a20
select SCN, NAME, TIME,GUARANTEE_FLASHBACK_DATABASE from v$restore_point;


Once the activity completes and DBA feels that we can drop the restore point then you should drop the restore point.

DROP RESTORE POINT <resotore_point_name>;