Restore points
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
ARCHIVELOGmode, and the compatibility mode should be 10.2 or greater.
We can easily see all restore points created in our database and create a new one if necessary by navigating in the database console menu to Availability] | Backup & Recovery | Restore Points...
