Redirecting a restore of Oracle data

In Backup Exec, you can redirect an Oracle instance or its files by redirecting the following:

An Oracle instance to another Oracle server.

Note:

If you redirect the instance to a different Oracle server, ensure that an instance with the same name and database ID (DBID) is set up on that server. The database status should be Nomount. Refer to your Oracle documentation for details on creating an instance with the same name and database ID.

An Oracle instance to another Oracle server and specifying alternate paths for the Oracle files.
Tablespaces, datafiles, and archive logs to an alternate location on the original server.

Symantec recommends that you select only one instance for each redirected restore operation.

To redirect a restore of Oracle data

Create a restore job for Oracle data.

See Restoring Oracle data.
After you select options on the Restore Job Properties dialog box for Oracle, on the Properties pane, under Destination, click Oracle Redirection.

Select the appropriate options as follows:

Restore Oracle instance to server	Check Restore Oracle instance to server to redirect the restore of the Oracle instance to a server other than the source server.
Server	Type the name of the server to which you want to redirect the restore job.
Server logon account	Type a logon account that has rights to restore data to the server to which you want to redirect the restore job.
Instance logon account:	Type a logon account for the Oracle instance that you want to restore.
Restore datafiles to the following path	Check Restore datafiles to the following path, and then specify the path to which you want to restore the datafiles. If you checked Restore Oracle instance to server, use this option to specify a path other than the default on that server. If you do not want to redirect the instance, check this option to specify an alternate local path for the file on the Oracle server.
Restore archived log files to the following path	Check Restore archived log files to the following path, and then specify the path to which you want to restore the archived log files. If you checked Restore Oracle instance to server, check this option to specify a path other than the default on that server. If you do not want to redirect the instance, check this option to specify an alternate local path for the file on the Oracle server

Start the redirected restore job or select other restore options from the Properties pane.

After the restore job is complete, Symantec recommends that you run a full backup of the restored data.