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

Restoring Database to the Specific Transaction

This scenario offers the greatest granularity of the database recovery: you can select the undesired operation from the list of database operations (available for the time period you have specified) – for example, user deletion. The database will be restored to the state prior to the transaction containing the specified operation, using log replay. To display the list of transactions, you will need a staging server.

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 available at the moment.
  1. You have an Oracle Server image-level backup created successfully.
  2. You have properly configured staging Oracle server settings (this can be a target server, an original server, or a dedicated server).

Select the required database in the navigation tree and do any of the following:

  • To restore database to the original server, click Restore Database > Restore point-in-time to <server_name> on the toolbar, or use the database's shortcut menu command. Proceed to the Step 1. Specify Restore Point step of the wizard.
  • To restore database to another server, click Restore Database > Restore to another server on the toolbar, or use the database's shortcut menu command. Proceed to the Step 1. Specify Restore Point step of the wizard.

Restoring Database to the Specific Transaction Note:

Remember that both the Restore to a point in time option and the Perform restore to the specific transaction option will only be available if you have archived log backups available at the moment (see the Required Oracle Server Backup Job Settings section for details).

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

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide

Veeam Backup for Microsoft Office 365

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation