Recovering the complete Oracle instance and
database using the original Oracle server
If you experience a
complete loss, deletion, or destruction of the Oracle instance or
database, you can use the same Oracle server for the recovery. You
can also use these instructions when you configure a new physical
server that uses the same server name and SID name.
To successfully complete
the recovery using this scenario, you must have the following
Table: Requirements when you recover using the
original Oracle server
If you do not know the DBID, you can find it in the Backup Exec
job log or in RMAN after you login.
ControlFile piece ID
You can identify the ControlFile piece ID in the Backup Exec
restore view in the Control Files subnode under the Oracle
A full system Oracle backup
The full system Oracle backup must include the
The original Oracle server
To successfully recover the Oracle system using disaster
recovery scenario 1, you must restore to the original Oracle
To recover the complete Oracle instance or
database after it has been lost, deleted, or destroyed, and you
want to use the original Oracle server for the recovery
Recreate the Oracle
database using the same name you used for the original database
that was lost.
Find and rename the
Create a new
To create a new pwd<SID>.ora file
Open a command
Type the following
To continue the disaster recovery
Open a command prompt and
do the following:
Type the following
Type CONNECT TARGET
Type SHUTDOWN ABORT;
Type STARTUP NOMOUNT;
Type SET DBID<dbid ID>;
Move to the Backup Exec
On the navigation bar,
click the arrow next to Restore.
Click New Restore Job.
On the Properties pane,
under Source, click Selections.
Select the appropriate
ControlFile for restore.
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.
After the restore job
finishes, exit Backup Exec.
Move to the Oracle
In the command prompt,
type the following command at the RMAN prompt: