- issue command to set restore point:
CREATE RESTORE POINT before_patch GUARANTEE FLASHBACK DATABASE;
- apply application patch
- test system after patch
- if ok, release restore point:
DROP RESTORE POINT before_patch;
- if something go wrong, flashback to restore point:
SHUTDOWN DATABASE; STARTUP MOUNT; FLASHBACK DATABASE TO RESTORE POINT before_patch;
Moreover you can use Restore Point while upgrading database 10g R1 to 10g R2. It can be very time saving in case of failure during upgrade process.
Restore Points can be also usefull in application testing process. You can define restore point, run test procedures, save results, restore to to saveponit and test again ...
To check if that you have set restore point you can run query:
select * from v$restore_point;Hope you will find it useful,