A restore point is a user-defined name for a point-in-time that allows you to rewind your data back in time to solve any problem caused by user errors or data corruption to a specific point-in-time (in this case, a restore point previously created). Oracle has two types of restore points:
- Normal Restore Point: Allows the creation of a restore point to a specific SCN, current time, or any point-in-time (that already passed). This type of restore point ages out the control file after it is beyond the point of recoverability.
- Guaranteed Restored Point: This type of restore point ensures that flashback can be used to rewind the database to the time of the restore point. It requires the database to have an FRA, be in
ARCHIVELOG mode, and ...