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:
- 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).
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.
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).