Symantec Backup Exec

To recover the complete Oracle instance and database to a computer other than the original Oracle Server

1. Recreate the Oracle instance using the same name you used for the original instance that was lost.

2. Find and rename the pwd<SID>.ora file.

3. Do the following in the order listed to create a new pwd<SID>.ora file:

   • Open a command prompt.

   • Type the following command:

     orapwd file=path\pwdsid.ora password=<password>

4. Type the following commands in the order listed:

   • RMAN

   • CONNECT TARGET <sys/password@sid>;

   • SHUTDOWN ABORT;

   • STARTUP NOMOUNT;

   • SET DBID<dbid ID>;

5. Move to the Backup Exec media server.

6. On the navigation bar, click the arrow next to Restore and click New Restore Job.

7. On the Properties pane, under Source, click Selections.

8. Select the appropriate ControlFile to restore.

9. On the Restore job properties pane, under Destination, click Oracle Redirection.

10. Check the check box for the option, Restore Oracle instance to server.

11. Enter account credentials to access the new or alternate Oracle server.

12. Check the check box for the option, Restore datafiles to the following path

13. Type a path to the new database.

14. Check the check box for the option, Restore archived log files to the following path

15. Click Run Now.

    The restore job will fail because the recovery portion encounters inconsistent archive logs. This is a normal occurrence during a disaster recovery.

16. Move to the Oracle server.

17. Type Alter database open resetlogs;.

18. Do one of the following:

    
    

    If an error is encountered while Oracle tries to open the database	Note the online redo log path and then update the path. See Updating the online redo log file path.
    If an error does not occur	Do nothing. The disaster recovery is complete.