Requirements for Using Guaranteed Restore Points

1)The COMPATIBLE initialization parameter must be set to 10.2 or greater. You can issue

SQL>SHOW PARAMETER COMPATIBLE;

to see the current compatible settings.

2)The database must be running in ARCHIVELOG mode. Issue SQL>ARCHIVE LOG LIST; to see the mode.

3)A flash recovery area must be configured. To configure it look at Configure Flash Recovery Area

4)If flashback database is not enabled, then the database must be mounted, not open,when creating the first guaranteed restore point (or if all previously created guaranteed restore points have been dropped).