Restore points

Oracle Flashback database and restore points enable us to rewind the database back in time to correct any problems caused by logical data corruption or user errors, and it doesn't require any restoration of backup. There are two types of restoration points, which are as follows:

  1. Normal Restore Point: Assigns a restore point name to an SCN or specific point in time. The control file stores the name of the restore point and the SCN.
  2. Guaranteed Restore Point: Is a normal restore point, but additionally serves as an alias for an SCN in recovery operation. The only difference is that the guaranteed restore points never age out of the control file and must be explicitly dropped.

    To create a restore point or view existing restore points, ...

Get Oracle SQL Developer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial