Sample Configurations with SGeRAC and Oracle RAC 10gR2, March 2009

ManualsBrandsHP ManualsSoftwareHP Serviceguard Extension for RAC (SGeRAC)

Assumptions for this sample configuration

1. Cluster hardware configured.

2. HP-UX 11i v2 0505 Enterprise Operating Environment.

3. Serviceguard and Serviceguard Extension for RAC installed.

4. Same private interconnect used for all inter-node traffic (Serviceguard, RAC, CSS)

5. One shared disk for shared volume group.

6. Two private disks (one disk per node for local file system for local Oracle storage)

Creating a SGeRAC cluster with SLVM for Oracle RAC 10g

The following sections describe the process for configuring SLVM.

SLVM Logical Volume Planning

For the sample configuration with SLVM, the following shared logical volumes are used. Note that

one SLVM volume group is used for both Oracle Clusterware (OC) required files and RAC database

files. When more than one RAC instance database or when the cluster will have more than one RAC

instance database, it is recommended that separate volume groups are used for OC and each RAC

instance database.

Using multiple volume groups permits better maintainability and manageability. For example, with

SLVM single node online volume reconfiguration (SNOR), it is possible to reconfiguration SLVM

volumes online while the RAC instance is running. Since SNOR requires that the target volume group

be deactivated on all but one node, if only one volume group is used, RAC instances and OC on

other nodes are impacted.

Figure 9. SLVM logical volume worksheet

RAW LOGICAL VOLUME NAME SIZE (MB)

Oracle Cluster Registry: _____/dev/vg_ops/rora_ocr_____108___ (one per

cluster)

Oracle Cluster Vote Disk: ____/dev/vg_ops/rora_vote_____28___ (one per

cluster)

Oracle Control File: _____/dev/vg_ops/ropsctl1.ctl______118______

Oracle Control File 2: ___/dev/vg_ops/ropsctl2.ctl______118______

Oracle Control File 3: ___/dev/vg_ops/ropsctl3.ctl______118______

Instance 1 Redo Log 1: ___/dev/vg_ops/rops1log1.log_____128______

Instance 1 Redo Log 2: ___/dev/vg_ops/rops1log2.log_____128_______

Instance 1 Redo Log 3: ___/dev/vg_ops/rops1log3.log_____128_______

Instance 1 Redo Log: __________________________________________________

Instance 2 Redo Log 1: ___/dev/vg_ops/rops2log1.log____128________

Instance 2 Redo Log 2: ___/dev/vg_ops/rops2log2.log____128________

Instance 2 Redo Log 3: ___/dev/vg_ops/rops2log3.log____128_________

Instance 2 Redo Log: _________________________________________________

Instance 2 Redo Log: __________________________________________________

Data: System ___/dev/vg_ops/ropssystem.dbf___508__________

Data: Sysaux ___/dev/vg_ops/ropssysaux.dbf___808__________

Data: Temp ___/dev/vg_ops/ropstemp.dbf______258_______

Data: Users ___/dev/vg_ops/ropsusers.dbf_____128_________

Data: User data ___/dev/vg_ops/ropsdata1.dbf_208__________

Data: User data ___/dev/vg_ops/ropsdata2.dbf__208__________

Data: User data ___/dev/vg_ops/ropsdata3.dbf__208__________

Parameter: spfile1 ___/dev/vg_ops/ropsspfile1.ora __5_____

Password: ______/dev/vg_ops/rpwdfile.ora__5_______

Instance 1 undotbs1: /dev/vg_ops/ropsundotbs1.dbf___508___

Instance 2 undotbs2: /dev/vg_ops/ropsundotbs2.dbf___508___

Data: example1__/dev/vg_ops/ropsexample1.dbf__________168____