Staging server is required to fine-tune the restore point in case a user needs to restore database to the state before specific transaction. If necessary, the staging server will be also involved in presenting database hierarchy to user (see below for details).
You can specify a local (for Windows VMs only) or remote (for both Windows and Linux VMs) staging server, as described below.
Important! |
If you plan to use a server other than original or target Oracle server as a staging system, make sure it has the same version as the source (original) and target Oracle server. |
To configure a staging server, do the following:
- Make sure the server you plan to use meets system requirements; also, check considerations and limitations.
- In Veeam Explorer for Oracle, open the main menu and click Options.
- For Windows-based server, do the following:
- Specify staging Server name.
- Specify user account to connect to Oracle server. You can either use current account (under which Veeam Explorer is running) or specify another one. Make sure is has sufficient permissions, as described here.
- Specify path to Oracle Home folder to be used. You can click Browse, and Veeam Oracle Home Browser will find the corresponding folder for you. If you plan to use Oracle 12c as a staging system, you may also need to enter a password to access Oracle Home on that machine.
- For Linux-based VM, only a remote server (not the one where Veeam Explorer is running) can be used as staging system. Do the following:
- Specify staging Server name and SSH port – default is 22.
- Specify account to connect to staging server. You can use authentication by username and password or by private key. Make sure the account has sufficient permissions, as described here.
- To elevate specified account to root and to add it to sudoers, click Advanced. Select the options you need; if necessary, enter root password and click OK to save the settings and close the dialog.
- Specify path to Oracle Home folder to be used. You can click Browse, and Veeam Oracle Home Browser will find the corresponding folder for you.
- Return to Options and click OK to save configuration settings.
Obtaining Database Information from VM Backup
To present Oracle database hierarchy to user, Veeam Explorer uses different ways of retrieving application-specific information from image-level backup:
- If application-aware image processing is enabled in the Guest Processing settings of a backup job, then Veeam Explorer can obtain application-specific Oracle database information from Oracle VM backup metadata. For that, Veeam Explorer communicates with Veeam backup server that keeps this information in the configuration database.
- If application-aware image processing is disabled in the Guest Processing settings of a backup job, then Veeam Explorer will need a staging Oracle server to mount selected image-level Oracle VM backup (with the databases and redo logs) to that staging server and collect the necessary information through guest scan and Oracle infrastructure analysis.
Using application information retrieved from backup, Veeam Explorer displays Oracle database hierarchy in its navigation pane where you can select the database to be restored and start 1-Click Restore or use the Restore wizard.