Veeam Explorer for Oracle supports several database recovery scenarios and offers flexible options for them. To choose a scenario, consider your organization’s policies and requirements and decide the following:
- Do you need to recover your database to the moment when the certain Oracle server VM restore point (backup or replica) was created, or to any point in time, maybe within the interval between the two restore points? In the latter case, database will be restored to the closest VM restore point before the moment you specify, and then log replay will bring the database to the necessary state. So you will need to make sure that:
- ARCHIVELOG mode is enabled for the Oracle database
- Logs are not truncated due to VM backup job settings
- Should you recover to the point in time, or is it necessary to support more granular recovery and be able to roll back to a state before undesired transaction?
For the most granular restore, you will need to keep backups of the Oracle database redo logs and ensure the staging Oracle server availability and proper configuration.
- Do you plan to restore your database to the original Oracle server, or to a different server? In both cases check for the following:
- The accounts you plan to use for restore have sufficient permissions on the target server (and, if necessary, on the staging server)
- Source, target and staging Oracle server (if required) have the same Oracle database version.
To implement the necessary scenario, you should, in particular, do the following:
- Configure Oracle database settings and Oracle server VM backup job settings.
- Make sure you have the necessary VM restore point created (or imported) successfully.
- Provide sufficient access rights for the user accounts that will be involved in the restore process.
In This Section