Restoring Databases to Latest or Point-in-Time State

With Veeam Explorer for Oracle, you can restore the latest or point-in-time state of multiple Oracle databases. In this scenario, all selected databases on the original Oracle server will be replaced with databases from the latest or earlier backup files.

Consider the following:

  • Data Guard will be restored starting from the primary node. Once the primary node is restored, Veeam Explorer for Oracle will use it to restore standby nodes.
  • Database files will be copied to the original location and then mounted to the original Oracle home.
  • Databases from the backed-up ASM group will be restored back to the original ASM group.

Consider that restoring a latest or point-in-time state to the original Oracle server from storage snapshots is not supported. Use the Restore to another server command, as described in Restoring Databases to Another Server.

For instructions, see the following sections:

Restoring Databases to Latest State

To restore multiple databases to the latest state to the original server, do the following:

  1. In the navigation pane, select the Oracle server or Oracle home.
  2. On the Server or Oracle Home tab, select Restore Database > Restore latest state to <original_location>.

Alternatively, you can right-click the Oracle server or Oracle home and select Restore databases > Restore latest state to <original_location>.

Note

The name of the restore option depends on the restore point you select during the application item restore process in the Veeam Backup & Replication console.

  • If you select the most recent available restore point, the option name is displayed as Restore latest state to <original_location>.
  • If you select any other restore point, the option name is displayed as Restore state of <point_in_time> to <original_location>.

Restoring Databases to Latest State

Restoring Databases to Point-in-Time State

To restore multiple databases to a point-in-time state to original server, do the following:

  1. In the navigation pane, select the Oracle server or Oracle home.
  1. On the Server or Oracle Home tab, select Restore Database > Restore state of <point_in_time> or right-click a database and select Restore databases > Restore point-in-time state.

Restoring Databases to Point-in-Time State

  1. At this step of the Restore wizard, select a state as of which you want to restore the databases:
  • Select the Restore to the point in time of the selected image-level backup option to load database files as of the moment when the current restore point was created.
  • Select the Restore to a specific point in time option to load database files as of the selected point in time. Note that this option is available only if archived log backups exist. For more information, see Required Backup Job Settings.

Use the slider to choose a necessary point in time.

Specifying Restore Point