Restore Points

Normal Restore Points

To create a normal restore point

SQL> Create Restore Point test;

To drop a normal restore point

SQL> Drop Restore Point test;

Guaranteed Restore Points

To create a Guaranteed restore point

SQL> Create Restore Point test_guarantee Guarantee Flashback Database;

To Drop a Guaranteed Restore Point,

SQL> Drop Restore Point test_guarantee Guarantee Flashback Database;

To recover using restore point,

RMAN> Flashback Database to Restore Point test_guarantee;

To view the Restore Points,

SQL> Select name, scn, storage_size, time, guarantee_flashback_database
From v$restore_point;

Thanks