O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ARCHIVELOG mode, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required