Using Serviceguard Extension for RAC, 8th Edition, March 2009

ManualsBrandsHP ManualsSoftwareHP Serviceguard Extension for RAC (SGeRAC)

NOTE: For specific CFS Serviceguard Storage Management Suite product information refer to

your version of the HP Serviceguard Storage Management Suite Release Notes.

Volume Planning with CVM

Storage capacity for the Oracle database must be provided in the form of volumes located in

shared disk groups. The Oracle software requires at least two log files for each Oracle instance,

several Oracle control files and data files for the database itself. For all these files, Serviceguard

Extension for RAC uses HP-UX raw volumes, which are located in disk groups that are shared

between the nodes in the cluster. High availability is achieved by using high availability disk

arrays in RAID nodes. The logical units of storage on the arrays are accessed from each node

through multiple physical volume links via DMP (Dynamic Multi-pathing), which provides

redundant paths to each unit of storage.

Fill out the Veritas Volume worksheet to provide volume names for volumes that you will create

using the Veritas utilities. The Oracle DBA and the HP-UX system administrator should prepare

this worksheet together. Create entries for shared volumes only. For each volume, enter the full

pathname of the raw volume device file. Be sure to include the desired size in MB. Following

are sample worksheets filled out. Refer to Appendix B: “Blank Planning Worksheets”, for samples

of blank worksheets. Make as many copies as you need. Fill out the worksheet and keep it for

future reference.

ORACLE LOGICAL VOLUME WORKSHEET FOR LVM Page ___ of ____

===============================================================================

RAW LOGICAL VOLUME NAME SIZE (MB)

Oracle Cluster Registry: _____/dev/vg_ops/rora_ocr_____100___ (once per cluster)

Oracle Cluster Vote Disk: ____/dev/vg_ops/rora_vote_____20___ (once per cluster)

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

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

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

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

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

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

Instance 1 Redo Log: __________________________________________________

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

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

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

Instance 2 Redo Log: _________________________________________________

Instance 2 Redo Log: __________________________________________________

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

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

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

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

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

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

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

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

Password: ______/dev/vg_ops/rpwdfile.ora__5_______

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

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

Data: example1__/dev/vg_ops/ropsexample1.dbf__________160____

ORACLE LOGICAL VOLUME WORKSHEET FOR CVM Page ___ of ____

===============================================================================

RAW VOLUME NAME SIZE (MB)

Oracle Cluster Registry: _____/dev/vx/rdsk/ops_dg/ora_ocr_____100___ (once per cluster)

Oracle Cluster Vote Disk: ____/dev/vx/rdsk/ops_dg/ora_vote_____20___ (once per cluster)

Oracle Control File: _____/dev/vx/rdsk/ops_dg/opsctl1.ctl______110______

Oracle Control File 2: ___/dev/vx/rdsk/ops_dg/opsctl2.ctl______110______

Oracle Control File 3: ___/dev/vx/rdsk/ops_dg/opsctl3.ctl______110______

Instance 1 Redo Log 1: ___/dev/vx/rdsk/ops_dg/ops1log1.log_____120______

Instance 1 Redo Log 2: ___/dev/vx/rdsk/ops_dg/ops1log2.log_____120______

Instance 1 Redo Log 3: ___/dev/vx/rdsk/ops_dg/ops1log3.log_____120_______

Instance 1 Redo Log: __________________________________________________

Instance 2 Redo Log 1: ___/dev/vx/rdsk/ops_dg/ops2log1.log____120________

Planning Storage for Oracle 10g/11gR1 RAC 33