Date - 01/2008
Affected Product & Version - NetVault: Backup 8.0
Affected Module & Version - APM for Oracle (Version 5.0)
OS Version - Windows 2000/2003
Application Information - Oracle 10.0.2.x
Description:
Disaster Recovery (DR) instructions for restoring a database using RMAN where no catalog is used and there is no autobackup controlfile.
DR of Oracle RMAN backup (APM 5.0)
Server is Windows,
No autobackup controlfile,
No RMAN catalog.
If restoring to a new server (ie not original backup source) then ensure you select the target server on the "Target" tab of the restore job.
For DR testing, we recommend you shut down the NetVault Client services on the Original/LIVE Oracle server to prevent errors.
1) Install Oracle on DR machine in the same location as on the original server.
2) Ensure NVclient is installed and nvpluginaccess has been run (if this is not done you will get a ORA-06512: at
"SYS.X$DBMS_BACKUP_RESTORE", line 4772 error at step 7).
3) Configure the Oracle plugin:
a) NetVault server (set it to the current NetVault server)
b) Do restore from NetVault server (set it to the NetVault server originally used in the backup)
c) Restore Backup taken from NetVault Client (set to the original Oracle Server NetVault Client name)
4) Create the directory structure to hold the Oracle datafiles.
5) Using the NetVault GUI restore the pfile/spfile ONLY from the Oracle backup (this does not require the database to exist).
6) Create the database using oradim:
e.g.
oradim -NEW -SID TEST -SRVC OracleServiceTEST -STARTMODE manual -PFILE C:\Oracle\product\10.1.0\admin\TEST\pfile
7) Recover the most recent (or other as required) controlfile:
First identify the name of the backup piece containing the controlfile using the NetVault Restore screen.
In APM 5.0 this can be found in the "Restore Options" Tab in the backup piece marked with "Controlfile Included" -
NB pick the last one of these from the backup - there is often more than one.
e.g.:
The backup piece with the controlfile is identified as:
nv_kerri:#236:nv_kerri:695_643454951:RMAN FULL DB TEST_1199784418
In a SQLPLUS session do a "startup nomount"
SQL> startup nomount
Then use the following script to recover the first controlfile from the backup media.
DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype := dbms_backup_restore.deviceallocate('sbt_tape', params=>' ');
dbms_backup_restore.restoresetdatafile;
dbms_backup_restore.restorecontrolfileto('destination path & name of control file');
dbms_backup_restore.restorebackuppiece('backup piece name identified above',done=>done);
END;
/
NB. - you need to substitute the backup piece name and the destination path and name of the controlfile you are restoring to appropriate values.
8) Shutdown the instance
SQL> shutdown immediate
9) Copy the restored controlfile to the required controlfiles. (control01.ctl, control02.ctl etc)
10) Start the database and mount:
SQL> startup database mount
11) Using the NetVault GUI - restore "Whole Database" and select complete recovery.
12) you may need also to manually run:
In SQLPLUS:
SQL> recover database using backup controlfile until cancel;
Then
SQL> alter database open resetlogs;