Recovering the complete Oracle instance and database using the original Oracle server

You can use the same Oracle server for a recovery if you experience a complete loss, deletion, or destruction of the Oracle instance or database.

See Requirements for recovering the complete Oracle instance and database using the original Oracle server.

To recover the complete Oracle instance or database using the original Oracle server

  1. Recreate the Oracle database using the same name you used for the original database 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 for restore.

  9. 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.

  10. After the restore job finishes, exit Backup Exec.

  11. At the Oracle server command prompt, type:

    Alter database open resetlogs;

  12. Close the command prompt.

Recovering the complete Oracle instance and database using the original Oracle server