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. So, to implement this scenario, ensure the following:
- ARCHIVELOG mode is turned on for the Oracle database.
- Log handling in the Oracle Server VM backup job settings had been configured properly to keep log backups available at the moment.
- You have an Oracle Server image-level backup created successfully.
- You have properly configured staging Oracle server settings (this can be a target server, an original server, or a dedicated server).
In Veeam Explorer for Oracle main window, select the required database in the navigation tree on the left, then launch the Restore wizard:
- To restore a 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.
- To restore a database to another server, click Restore Database > Restore to another server on the toolbar, or use the database's shortcut menu command.
Then follow the steps of Restore wizard:
- On the Specify restore point step, select Restore to a point in time and use the slider to specify point in time closely to the undesired transaction. Then select the Perform restore to the specific transaction check box.
|
Remember that these two options will be available only if you have archived log backups available at the moment (see the Required Oracle Server Backup Job Settings section for details). |
- Next, on the Fine-tune the restore point step, you get a list of database operations from the log backup, starting with those closer to the specified point in time. Select the undesired operation (for example, row deletion or insertion). The database will be restored to the most recent state preceding the selected operation.
- Complete the steps of the wizard, as described in Using Restore Wizard.
Veeam Explorer for Oracle will notify you of the restore operation results.
Related Topics
