Date - 01/2008
Affected Product & Version - NetVault: Backup 7.x and higher
Affected Module & Version - APM for Oracle (Version 4.x & 5.0)
OS Version - Windows 2000/2003
Application Information - Oracle 9.x or 10.x
Description:
Disaster recovery instructions for restoring a database using Oracle User Managed (Online) backups.
Symptoms:
NA
Disaster Recovery (DR) of Oracle Online backup to new target machine
1) Install oracle on the DR machine in same location as the original.
2) Ensure that NetVault client is installed on DR machine and the Oracle APM is installed.
3) Create the directory structure to hold oracle datafiles.
4) Restore the pfile/spfile ONLY from the Oracle backup (this does not require the database to exist)
5) Run oradim to create the database using the pfile/spfile recovered above
oradim -NEW -SID TEST -SRVC OracleServiceTEST -STARTMODE manual -PFILE C:\oracle\product\10.1.0\admin\TEST\pfile
6) In SQLPLUS mount the database
SQL> startup nomount
7) From the NetVault GUI restore the backup controlfile only
8) Copy the backup controlfile to the live controlfile locations & names
9) In SQLplus mount the database
SQL> alter database mount
10) In the NetVault GUI, restore all tablespaces and archive logs
11) In SQLPLUS recover the database:
SQL> recover database using backup controlfile until cancel;
(the until phrase can be altered to the required value)
SQL> alter database open resetlogs;
Now take a full backup of the newly recovered database.
English version available ID: 3359
Version française disponible ID
Deutsche Version verfügbar ID
