Step 2. Specify Restore Point

At this step of the Instant Recovery wizard, select a state as of which you want to restore your database:

  • Select the Restore to the point in time of the selected image-level backup option to load database files as per date when the current restore point was created.
  • Select the Restore to a specific point in time option to load database files as per selected point in time. This option is available only if archived log backups exist. For more information, see Required Backup Job Settings.
  1. Use the slider to choose a required point in time.
  2. If you want to load database files exactly as of the moment before undesired transactions, select the Perform restore to the specific transaction check box. Note that this option requires a staging Oracle server. For more information, see Configuring Staging Oracle Server.

Specifying Restore Point