Introducing Arcserve Backup Agents and Options › Using Options › Enterprise Option for SAP R/3 for Oracle › Using the Option with Agent for Oracle › Database Restore with the Option › Best Practices for Restoring Data › Restore to an Alternate Server

Restore to an Alternate Server

You can restore to an alternate server using the following procedure.

To restore to a server other than the server from which the backup was created

1. Select the server and the file directory you want to restore.

   Note: This server must be running one of the Windows operating systems required by the option. For a list of operating systems, see the Readme.

2. Click the Schedule tab and select the scheduling options you want to apply to this job.
3. Click Submit. The Session User Name and Password dialog opens.

   

4. To enter or change the user name and password (and the session password) for the computer on which the source Oracle application server is running, select the session and click Edit.
5. Click the DBAgent tab.

   The DBAgent tab opens.

   

6. Enter the user name and password.

   Note: For Oracle 9i and 10g, enter the user name SYSTEM.

7. For any version, the user name can also be any account with SYSDBA equivalent privileges.
8. Click OK.

   The job is submitted to the queue and can be monitored from the Job Queue Manager.

When the job is completed, the database objects are restored to the selected server. It may be necessary to manually move the Oracle files into the proper locations after the restore is complete.

If the Oracle database has multiple archived log directories and archived log files that have been restored, to synchronize them, you must copy the restored files to the archived log directories.

See the following sections for information about recovering the Oracle database. For more information about submitting a restore job, see the Administration Guide.