Help Center
Choose product document...
Veeam Backup & Replication 9.5 [Archived]
Veeam Backup Explorers User Guide

Restoring Database to the Specific Point in Time

This scenario allows you to recover your database to a specific point in time (which may differ from current restore point). Database will be recovered to the closest VM restore point before the moment you specify, and then log replay will be performed on the target server to bring the database to the necessary state. To implement this scenario, ensure the following:

  1. ARCHIVELOG mode is turned on for the Oracle database.
  2. Log handling in the Oracle Server VM backup job settings had been configured properly to keep log backups at hand, as described in the Required Oracle Backup Job Settings section.
  1. You have an Oracle Server image-level backup created successfully.

Restore to Original Server

To restore a database to the certain point in time onto the original server, do the following:

  1. In Veeam Explorer for Oracle main window, select the required database in the navigation tree on the left.
  2. Select Restore Database > Restore <point_in_time> or latest state to <server_name>... on the toolbar, or use the same database's shortcut menu command.
  1. Select Restore to a specific point in time.

Use the slider to specify the point in time to which you want the database to be restored. Database will be recovered to the closest VM restore point before the moment you specify on the timeline, and then log replay will bring the database to the necessary state.

The timeline includes the following timestamps (relatively to the current Oracle Server restore point):

  • Beginning – refers to the previous restore point of Oracle Server VM which contains selected database backup
  • End – refers to the next restore point which contains selected database backup.
  1. Click Restore.  Veeam Explorer for Oracle will display the confirmation dialog. To start the restore process, click Proceed.

Restoring Database to the Specific Point in Time 

Restoring Database to the Specific Point in Time Note:

Consider the following:

  • If the previous restore point (server backup) was not found, or database backup does not exist in it, then Beginning will refer to current restore point.
  • If the next restore point (server backup) and corresponding log backup were not found, or if database backup does not exist in server backup, then End will refer to current restore point.
  • If the next restore point (server backup) was not found, but log backup exists for the preceding period, then End will refer to the latest log backup time.

Restore to Another Server

To restore database to the specified point in time to another Oracle Server, do the following:

  1. Select the required database in the navigation tree.
  1. Select Restore Database > Restore to another server... on the toolbar, or use the same database's shortcut menu command.

Restoring Database to the Specific Point in Time 

  1. Select Restore to a specific point in time option and use the slider to specify the necessary point, as described above. Leave the Perform restore to specific transaction check box unchecked.

Restoring Database to the Specific Point in Time 

  1. You will be taken to the Step 3. Specify Target Server step of the wizard. Go through the remaining steps and wait for restore operation to complete.
Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Agent Management Guide

Veeam Backup Explorers User Guide

Backup and Restore of SQL Server Databases

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide