First page Back Continue Last page Graphics

...Restore Points

Notes:

In this example we see the FLASHBACK DATABASE statement being used to flashback to the restore point “FRIDAY140” (created in the previous example). The OPEN RESETLOGS is required to open the database for read / write activity.
Restore points are a persistent object. Therefore, you can flashback database to a restore point, retry the upgrade or application and, if another failure occurs, flashback again to the restore point.
Because restore points persist in the database, they should (must in the case of guaranteed restore points) be dropped; otherwise, the flash recovery area can fill with unnecessary flashback logs.