HP Data Protector 6.0 SUN Solaris10 (SPARC) Oracle10gR2 RAC (On RAW VxVM Volumes) with HP XP ZDB Proxy-Copy Method with IR

ManualsBrandsHP ManualsSoftwareHP OpenView Storage Data Protector V6.0 Software

HP OpenView Storage Data Protector

HP OpenView Storage Data Protector 6.0

SUN Solaris10 (SPARC) Oracle10gR2 Real Application Cluster (On

RAW VxVM Volumes) with

HP StorageWorks Disk Array XP

Zero Downtime Backup (ZDB) Proxy-Copy Method

with

Instant Recovery (IR)

Version 1.1

1 INTRODUCTION - 2 -

2 Overview of Oracle 10g RAC R2 Example Environment - 2 -

3 Preparing the HP Storage Works Disk Array XP Environment - 3 -

4 Preparing the Sun Cluster setup and Oracle 10g RAC R2 Environment - 4 -

4.1 Requirements.....................................................................................................- 4 -

4.2 Storage management .........................................................................................- 4 -

5 Installing Data Protector Agents on RAC Cluster Nodes - 7 -

6 Oracle 10g RAC R2 Integration and Configuration - 8 -

6.1 Configuring the Oracle Server.............................................................................- 8 -

6.2 Creating Backup Specifications .........................................................................- 13 -

7 Oracle 10g RAC R2 ZDB Backup and Recovery - 19 -

7.1 Oracle 10g RAC R2 ZDB Proxy Backup (non IR) - Example...................................- 19 -

7.2 Oracle 10g RAC R2 ZDB Proxy Restore and Recovery (non IR) - Example...............- 26 -

7.3 Oracle 10g RAC R2 ZDB Proxy Backup IR - Example ...........................................- 29 -

7.4 Oracle 10g RAC R2 ZDB Proxy Restore IR - Example ...........................................- 33 -

8 References - 35 -

- 1 -

Summary of content (35 pages)

PAGE 1
HP OpenView Storage Data Protector HP OpenView Storage Data Protector 6.0 SUN Solaris10 (SPARC) Oracle10gR2 Real Application Cluster (On RAW VxVM Volumes) with HP StorageWorks Disk Array XP Zero Downtime Backup (ZDB) Proxy-Copy Method with Instant Recovery (IR) Version 1.1 1 2 3 4 5 6 7 8 INTRODUCTION -2Overview of Oracle 10g RAC R2 Example Environment -2Preparing the HP Storage Works Disk Array XP Environment -3Preparing the Sun Cluster setup and Oracle 10g RAC R2 Environment -44.1 Requirements.....
PAGE 2
HP OpenView Storage Data Protector 1 INTRODUCTION This white paper is intended to provide supplementary information for installation and configuring HP OpenView Storage Data protector with Oracle Real Application Clusters 10g Release 2 running Solaris10 operating system for Proxy-Copy Zero Downtime Backup (ZDB) in HP StorageWorks Disk Array XP environments. There are variety of choices with regards to the installation and set-up of Oracle Real Application Clusters 10g on the Solaris10 platform.
PAGE 3
HP OpenView Storage Data Protector The Data Protector Server “victoria” is responsible for backing up the split-mirror data from disk array volume “S-VOL” to tape and is also the Data Protector Cell manager. This system is installed with the same version of the VxVM that is being used on the Application Nodes. The oracle database configuration, archive, data files are all on shared disks (RAW VxVM) and are accessed by each database server instance.
PAGE 4
HP OpenView Storage Data Protector For further information on HP StorageWorks Disk Array XP configuration procedures, please refer to: • HP OpenView Storage Data Protector Zero Downtime Backup Administrator’s Guide • HP OpenView Storage Data Protector Zero Downtime Backup Concepts Guide • HP OpenView Storage Data Protector Zero Downtime Backup Integration Guide 4 Preparing the Sun Cluster setup and Oracle 10g RAC R2 Environment This chapter gives supplementary information to the following documentation:
PAGE 5
HP OpenView Storage Data Protector (OCR), a mirrored OCR file (optional), the Oracle Clusterware voting disk, and additional voting disk files (optional).
PAGE 6
HP OpenView Storage Data Protector Number Size (MB) Purpose and Sample Logical Volume Name dbname_example_raw_160m 1 120 USERS tablespace: dbname_users_raw_120m 2 * number of instances 120 Two online redo log files for each instance (where n is the number of the instance and m is the log number, 1 or 2): dbname_redon_m_raw_120m 2 110 First and second control files: dbname_control{1|2}_raw_110m 1 5 Server parameter file (SPFILE): dbname_spfile_raw_5m 1 5 Password file: dbname_pwdfile_raw_5
PAGE 7
HP OpenView Storage Data Protector # vxdg -s import diskgroup Start all logical volumes: # /usr/sbin/vxvol startall After performing the steps above configure the RAC based instance using the RAW VxVM volumes. 5 Installing Data Protector Agents on RAC Cluster Nodes To back up a RAC Cluster, Data Protector integration software has to be installed on all the nodes in the RAC environment.
PAGE 8
HP OpenView Storage Data Protector For further information on installation procedures, please refer to: • HP OpenView Storage Data Protector Installation and Licensing Guide 6 Oracle 10g RAC R2 Integration and Configuration with Data Protector The following steps are executed after the Oracle Clusterware and RAC Oracle 10g software installation and database creation. The database RAC is created on RAW VxVM volumes using Database configuration assistant.
PAGE 9
HP OpenView Storage Data Protector In the Configure Oracle dialog box and in the General page, specify the pathname of the Oracle Server home directory.
PAGE 10
HP OpenView Storage Data Protector Figure 5 Configuring Oracle General page. List RAC1 and RAC2 net services names for the primary database separated by a comma. Note that each net service name resolves into a specific database instance.
PAGE 11
HP OpenView Storage Data Protector Figure 6 Configuring Oracle Primary page. As we use the recovery database catalog as an RMAN repository for backup history, we select Use recovery catalog and specify the login information to the recovery catalog. Note that for ZDB, the recovery catalog database must be selected.
PAGE 12
HP OpenView Storage Data Protector Figure 7 Configuring Oracle Catalog page. If you intend to back up a standby database, configure the standby database also. In the ZDB property page, select Backup method and then select PROXY in the drop-down list. In Backup control file copy location, you can specify the location on the source volumes where a backup copy of the current control file will be made during ZDB to disk. If you do not specify the location, o2rman.
PAGE 13
HP OpenView Storage Data Protector Figure 8 Configuring Oracle ZDB page. 6.2 Creating Backup Specifications To create an Oracle ZDB backup specification, proceed as follows: • In the Context List, click Backup. • In the Scoping Pane, expand Backup Specifications, right-click Oracle Server, and click Add Backup. • In the Create New Backup dialog box, select the following: To perform a ZDB of the entire database using the proxy-copy method, select the SMB_Proxy_Database template.
PAGE 14
HP OpenView Storage Data Protector Figure 9 Creating Backup Choosing templates. In the next screen (figure 10), from the Application system drop-down list, select the virtual server "atlantic".
PAGE 15
HP OpenView Storage Data Protector Figure 10 Creating Non IR Backup XP Options. By default the full database is selected for backup. The backup specification “ZDB_PROXY” is created: BARLIST "ZDB_PROXY" OWNER "oracle" "dba" "atlantic.somedomain.com" DESCRIPTION "Backs up the database instance and control file in the ZDB (split mirror or snapshot) mode using the proxy-copy method." DYNAMIC 1 5 BACKUP_TYPE SplitMirror SureStoreEXP { MIRROR local APPLICATION_SYSTEM atlantic.somedomain.
PAGE 16
HP OpenView Storage Data Protector } -sync CLIENT "RACD" atlantic.somedomain.com { -exec ob2rman.exe -args { "-backup" } -input { "run {" "allocate channel 'dev_0' type 'sbt_tape'" " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=RACD,OB2BARLIST=ZDB_P ROXY,OB2DMAP=1,OB2SMB=1)';" "backup incremental level " " format 'ZDB_PROXY.
PAGE 17
HP OpenView Storage Data Protector Figure 11 Creating IR Backup XP Options. The backup specification “ZDB_IR” is created: BARLIST "ZDB_IR" OWNER "oracle" "dba" "atlantic.somedomain.com" DESCRIPTION "Backs up the database instance and control file in the ZDB (split mirror or snapshot) mode using the proxy-copy method.
PAGE 18
HP OpenView Storage Data Protector } APPLICATION_SYSTEM atlantic.somedomain.com BACKUP_SYSTEM victoria.somedomain.com -establish -instant_restore -keep_version -start_on_app DEVICE "QUANTUM:DAT DAT160-000_" { -sync } CLIENT "RACD" atlantic.somedomain.com { -exec ob2rman.
PAGE 19
HP OpenView Storage Data Protector 7 Oracle 10g RAC R2 ZDB Backup and Recovery This chapter documents backup and recovery sessions which are based on standard procedures. Please refer to the following documentation for additional information: • HP OpenView Storage Data Protector Integration Guide for Oracle SAP • HP OpenView Storage Data Protector Zero Downtime Backup Integration Guide • HP OpenView Storage Data Protector Zero Downtime Backup Administrator’s Guide 7.
PAGE 20
HP OpenView Storage Data Protector Net service name: RAC1. Instance status: OPEN. Instance name: RAC1. Database DBID = 1888329729. Database control file type: CURRENT. Database log mode: ARCHIVELOG. [Normal] From: ob2rman@amazon "RACD" Time: 09/28/07 14:47:56 Starting Oracle Recovery Manager. Recovery Manager: Release 10.2.0.3.0 - Production on Fri Sep 28 14:47:56 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved.
PAGE 21
HP OpenView Storage Data Protector [Normal] From: SSEA@victoria"" Time: 9/28/2007 2:49:24 PM Starting agent on Victoria [Normal] From: SSEA@amazon "" Time: 9/28/2007 2:48:03 PM Resolving backup objects on the application system. [Normal] From: SSEA@amazon "" Time: 9/28/2007 2:48:03 PM Resolving of backup objects on the application system completed.
PAGE 22
HP OpenView Storage Data Protector [Normal] From: SSEA@amazon "" Time: 9/28/2007 2:48:11 PM The application system was successfully resumed.
PAGE 23
HP OpenView Storage Data Protector [Normal] From: OB2BAR_DMA@victoria"RACD" Time: 9/28/2007 2:50:44 PM Starting OB2BAR Backup: atlantic.somedomain.com:ZDB_PROXY.dbf "Oracle8" [Normal] From: OB2BAR_DMA@victoria"RACD" Time: 9/28/2007 2:50:45 PM Completed OB2BAR Backup: atlantic.somedomain.com:ZDB_PROXY.
PAGE 24
HP OpenView Storage Data Protector released channel: dev_0 Recovery Manager complete. [Normal] From: ob2rman@amazon "RACD" Time: 09/28/07 14:50:11 Oracle Recovery Manager completed. [Normal] From: ob2rman@amazon "RACD" Time: 09/28/07 14:50:11 Starting backup of Data Protector managed control file backup. [Normal] From: ob2rman@amazon "RACD" Time: 09/28/07 14:50:12 Backing up current control file completed. Location: /var/opt/omni/tmp/ctrl_RACD.dbf.
PAGE 25
HP OpenView Storage Data Protector 20750 0234h ( 564) CL1-C 0 81 0 STAT_PSUS 027Bh ( 635) ------------------------------------------------------------- 20750 ----------- [Normal] From: SSEA@victoria"" Time: 9/28/2007 2:52:15 PM COMPLETED SSEA-Backup Agent on Victoria. [Normal] From: SSEA@amazon "" Time: 9/28/2007 2:50:54 PM COMPLETED SSEA-Application Agent on amazon.
PAGE 26
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" 14:58:17 Starting restore of target database. Time: 09/28/07 Net service name: RAC2. Instance status: MOUNTED. Instance name: RAC2. Database DBID = 1888329729.
PAGE 27
HP OpenView Storage Data Protector channel dev_0: starting proxy restore channel dev_0: specifying datafile(s) for proxy restore restoring datafile 00001 to /dev/vx/rdsk/oradg/raw_RACD_system_508m proxy file handle=ZDB_PROXY.dbf restoring datafile 00002 to /dev/vx/rdsk/oradg/raw_RACD_undotbs1_508m proxy file handle=ZDB_PROXY.dbf restoring datafile 00003 to /dev/vx/rdsk/oradg/raw_RACD_sysaux_808m proxy file handle=ZDB_PROXY.
PAGE 28
HP OpenView Storage Data Protector [Normal] From: OB2BAR_DMA@amazon.somedomain.com "RACD" Time: 9/28/2007 3:05:32 PM Starting OB2BAR Restore: atlantic.somedomain.com.:ZDB_PROXY.dbf "Oracle8" [Normal] From: OB2BAR_DMA@amazon.somedomain.com "RACD" Time: 9/28/2007 3:05:43 PM Completed OB2BAR Restore: atlantic.somedomain.com.:ZDB_PROXY.
PAGE 29
HP OpenView Storage Data Protector 7.3 Oracle 10g RAC R2 ZDB Proxy Backup IR - Example The RAC ZDB backup (For IR) example was started with the GUI: Figure 12 Start Backup. [Normal] From: BSM@victoria.somedomain.com "ZDB_IR" Time: 11/15/2007 12:20:07 PM OB2BAR application on "atlantic.somedomain.com" successfully started. [Normal] From: ob2rman@amazon “RACD” Time: 11/15/07 12:17:37 Starting backup of target database. Net service name: RAC2. Instance status: OPEN. Instance name: RAC2.
PAGE 30
HP OpenView Storage Data Protector [Normal] From: ob2rman@amazon “RACD” Time: 11/15/07 12:17:46 Making list of target database datafiles. [Normal] From: ob2rman@amazon “RACD” Time: 11/15/07 12:17:46 Making list of target database files completed. [Normal] From: ob2rman@amazon “RACD” Time: 11/15/07 12:17:46 Creating list of target database files for resolving.
PAGE 31
HP OpenView Storage Data Protector ------------------------------------------------------------20750 0234h ( 564) CL1-C 0 81 0 STAT_PAIR 027Bh ( 635) ------------------------------------------------------------- ----------20750 ----------- [Normal] From: SSEA@amazon "" Time: 11/15/2007 12:17:57 PM Resolving of backup objects on the application system completed. [Normal] From: SSEA@victoria.somedomain.
PAGE 32
HP OpenView Storage Data Protector Preparing target database replica on the backup host. [Normal] From: SSEA@victoria.somedomain.com "" Time: 11/15/2007 12:18:55 PM The following disks were successfully mapped from LDEVs to character device path names of disks: SEQ# Port LDEV Target Lun Disk -------------------------------------------------------20750 CL1-C 027Bh ( 635) 15 89 c3t50060E8003510E02d0 -------------------------------------------------------[Normal] From: SSEA@victoria.somedomain.
PAGE 33
HP OpenView Storage Data Protector [Normal] From: SSEA@victoria.somedomain.com "" Time: 11/15/2007 12:19:08 PM COMPLETED SSEA-Backup Agent on victoria.somedomain.com. [Normal] From: SSEA@amazon "" Time: 11/15/2007 12:18:23 PM COMPLETED SSEA-Application Agent on amazon. [Normal] From: BSM@victoria.somedomain.com "ZDB_IR" 12:20:58 PM Time: 11/15/2007 Backup Statistics: Session Queuing Time (hours) 0.
PAGE 34
HP OpenView Storage Data Protector Disabling the application system. [Normal] From: SSEA@amazon "" Time: 11/15/2007 12:21:01 PM Disk group oradg has been successfully deported. [Normal] From: SSEA@amazon "" Time: 11/15/2007 12:21:01 PM The application system was successfully disabled. [Normal] From: SSEA@amazon "" Time: 11/15/2007 12:21:01 PM Starting Instant Recovery.
PAGE 35
HP OpenView Storage Data Protector 8 References • HP OpenView Storage Data Protector Integration Guide for Oracle SAP • HP OpenView Storage Data Protector Installation and Licensing Guide • HP OpenView Storage Data Protector Zero Downtime Backup Administrator’s Guide • HP OpenView Storage Data Protector Zero Downtime Backup Concepts Guide • HP OpenView Storage Data Protector Zero Downtime Backup Integration Guide • Oracle Database Administrator's Guide 10g Release 2 (10.