Using Serviceguard Extension for RAC, 6th Edition, April 2008
Instance 1 Redo Log 3: ___/dev/vg_ops/rops1log3.log_____120_______
Instance 1 Redo Log: __________________________________________________
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____
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 is a sample worksheet 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 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 1 Redo Log: __________________________________________________
Instance 2 Redo Log 1: ___/dev/vx/rdsk/ops_dg/ops2log1.log____120________
Instance 2 Redo Log 2: ___/dev/vx/rdsk/ops_dg/ops2log2.log____120________
Instance 2 Redo Log 3: ___/dev/vx/rdsk/ops_dg/ops2log3.log____120________
Instance 2 Redo Log: _________________________________________________
Instance 2 Redo Log: __________________________________________________
Planning Storage for Oracle 10g RAC 43