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

Using Restore Wizard

Step 1. Specify Restore Point

Select a state to which you want to restore your database:

Using Restore Wizard 

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 current Oracle server restore point):

Using Restore Wizard 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 the corresponding log backup were not found, or if a database backup does not exist in server backup, then End will refer to the current restore point.
  • If the next restore point (server backup) was not found, but the log backup exists for the preceding period, then End will refer to the latest log backup time.

Related Topics

Step 2. Fine-tune the Restore Point

On this step, you will get a list of database operations logged during the time period you have specified. Select the undesired operation (for example, you can select the row deletion or insertion).

Using Restore Wizard 

The database will be restored to the most recent state preceding the selected operation. For more information, refer to Scenario 3: Restoring a Database to Specific Transaction

Step 3. Specify Target Server

Here you should specify connection settings for the target server where the database should be restored. When restoring database from the Windows-based Oracle server, specify the following:

Using Restore Wizard 

  1. Enter the name of target Oracle server where the database should be restored.
  2. Specify the account to be used for connection with the target Oracle server. You can use the current account (under which you are running Veeam Explorer for Oracle), or specify another account and enter its password. Windows authentication will be used. Remember that the account used to access target Oracle server must have the sysdba rights on that server.

Using Restore Wizard Note:

To be able to copy archived logs from backup to the target server for further replay, the account you specify for server connection (that is, credentials to connect to Windows server) should be granted sufficient permissions to access the administrative share on that machine (e.g., \\myserver\C$): Read and Write are minimal required, Full Control recommended. See the Permissions section for information.

If you are restoring a database from a Linux-based Oracle server, specify the following:

Using Restore Wizard 

  1. Target server name and SSH port – default is 22.
  2. Account to connect to the target Linux server – this should be a root account or account added to sudoers - then you need to elevate it to root (for that, click Advanced and select the necessary options). You can use authentication by username and password or by private key.

Using Restore Wizard 

After you click Next, Veeam Explorer will validate the specified account settings; you will be able to proceed after successful validation; otherwise, enter another account.

See also the Permissions section of this document.

Step 4. Specify Oracle settings

You can select one of the following options:

Using Restore Wizard 

Using Restore Wizard Note:

If database with the specified name exists on the target Oracle home, the restore process by design will delete it and replace with the database from backup. Thus, when you click Next, a message will be displayed, asking you to confirm the operation.

Step 5. Specify Database Files Location

Finally, specify the location to which database and log files will be restored. You can select a listed item and edit it appropriately.

Using Restore Wizard 

Click Restore and wait for the process to complete. Veeam Explorer for Oracle will notify you of the operation results.

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