HP Data Protector 6.0 SUN Solaris10 (SPARC) Oracle10gR2 RAC (On RAW VxVM Volumes) with HP XP ZDB Proxy-Copy Method with IR
HP OpenView Storage Data Protector
7.2 Oracle 10g RAC R2 ZDB Proxy Restore and Recovery (non IR) - Example
To do the Full database restore shutdown all database instances from all cluster nodes and keep
them in mounted stated.
Following session log is the example of Full Restore from DP GUI:
[Normal] From: ob2rman@amazon.somedomain.com "RACD" Time: 09/28/07
14:58:17
Starting restore of target database.
Net service name: RAC2.
Instance status: MOUNTED.
Instance name: RAC2.
Database DBID = 1888329729.
Database control file type: CURRENT.
Database log mode: ARCHIVELOG.
Net service name: RAC1.
Instance status: MOUNTED.
Instance name: RAC1.
Database DBID = 1888329729.
Database control file type: CURRENT.
Database log mode: ARCHIVELOG.
[Normal] From: ob2rman@amazon.somedomain.com "RACD" Time: 09/28/07
14:58:19
Starting Oracle Recovery Manager.
Recovery Manager: Release 10.2.0.3.0 - Production on Fri Sep 28 14:58:19
2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> CONNECT TARGET *
2> CONNECT CATALOG *
3> run {
4> allocate channel 'dev_0' type 'sbt_tape'
5> parms
'ENV=(OB2PROXYCOPY=1,OB2BARTYPE=Oracle8,OB2APPNAME=RACD,OB2BARLIST=11909
71884,OB2BARHOSTNAME=atlantic.somedomain.com.)';
6> restore database;
7> release channel 'dev_0';
8> }
9> EXIT
connected to target database: RACD (DBID=1888329729, not open)
connected to recovery catalog database
allocated channel: dev_0
channel dev_0: sid=146 instance=RAC1 devtype=SBT_TAPE
channel dev_0: Data Protector
A.06.00/PHSS_35908/PHSS_35909/DPSOL_00261/DPLNX_
Starting restore at 28-SEP-07
- 26 -