How to perform a redirected restore of an Oracle Server to another Oracle Server using Backup Exec for Windows Servers
- For Backup Exec 11d and Backup Exec 12.0 the folder structure for Oracle should be the same on the target server as on the original server. For Backup Exec 12.5 and later this is no longer a requirement. (For details please refer to: http://www.veritas.com/docs/000033256 ).
To recover the complete Oracle Instance or database after it has been lost, deleted, or destroyed, a new or alternate Oracle Server must be used for the recovery per the following:
1. Recreate the Oracle Database using the same name used for the original database
that is no longer available.
2. Locate and rename the pwd<SID>.ora file. Make note of the path to this file for use in Step 3b.
3. Create a new pwd<SID>.ora file. To create a new pwd<SID>.ora file:
a. Open a command prompt.
b. Type the following command:
orapwd file="path from Step 2"\pwd<sid>.ora password=<password>
Example: C:\> orapwd file=c:\oracle\product\10.2.0\db_1\database\pwdORCL1.ora password=NEWpassword
Note: Backup Exec Remote Agent must be installed and configured for Oracle database access (https://www.veritas.com/support/en_US/article.000108639)
4. At a command prompt, type the following command: SQLplus / as SYSDBA
5. Type SHUTDOWN IMMEDIATE;
6. Type STARTUP NOMOUNT;
7. Exit Sqlplus and launch RMAN from the command prompt.8. Type SET DBID=dbid ID;
Note: This dbid MUST be identical to the dbid from the original Oracle instance. Type EXIT when complete.
9. Move to the Backup Exec Media Server.
10. On the navigation bar, click the arrow next to Restore, then click New Restore Job.
11. On the Properties pane, under Source, click Selections.
12. Select the appropriate Control File to restore.
13. On the Restore job properties pane, under Destination, click Oracle Redirection.
14. Enable the check box for the option, Restore Oracle instance to server. Enter account credentials to access the new or alternate Oracle Server.
If the Oracle datafiles and archive logs are stored on a different location on the target server, enable "Redirect Oracle files to path" option and specify the valid paths for the datafiles and archive logs. Click Run Now to run the restore job.
Note: The restore job will fail because the recovery portion encounters inconsistent archive logs. This is a normal occurrence during a disaster recovery.
15. Move to the Oracle server and launch SQLplus / as SYSDBA from command prompt.
16. Type alter database open resetlogs;
If an error is encountered while Oracle tries to open the database document the online redo log path and then update the path
using the steps below.
To update the online redo log file path:
a. At the Oracle server, open a command prompt.
b. Type the following command:
c. Type connect<sys/password@SID>;
d. Type the following SQLPlus command:
SQLPLUS ALTER DATABASE RENAME FILE <old path from backup to any redolog file name> to <path to expected restored redolog file name>;
ALTER DATABASE RENAME FILE 'D:\ORACLE\ORADATA\JACOB\REDO01.LOG' to
e. In the command prompt, type RMAN, then type the following command at the RMAN prompt:
alter database open resetlogs;
f. Close the command prompt. The recovery should now be complete.