Using Serviceguard Extension for RAC, 6th Edition, April 2008
Planning Storage for Oracle 10g RAC
Volume Planning with SLVM
Storage capacity for the Oracle database must be provided in the form of logical volumes
located in shared volume 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 logical volumes,
which are located in volume groups that are shared between the nodes in the cluster.
High availability is achieved by using high availability disk arrays in RAID modes.
The logical units of storage on the arrays are accessed from each node through multiple
physical volume links (PV links, also known as alternate links), which provide
redundant paths to each unit of storage.Fill out a Logical Volume worksheet to provide
logical volume names for logical volumes that you will create with the lvcreate
command. The Oracle DBA and the HP-UX system administrator should prepare this
worksheet together. Create entries for shared volumes only. For each logical volume,
enter the full pathname of the raw logical volume device file. Be sure to include the
desired size in MB. Following is a sample worksheet filled out. However, this sample
is only representative. For different versions of the Oracle database, the size of files are
different. 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.
Storage Planning with CFS
With CFS, the database software, database files (control, redo, data files), and archive
logs may reside on a cluster file system visible by all nodes. Also, the OCR and vote
device can reside on CFS directories.
The following software needs to be installed in order to use this configuration:
• SGeRAC
• CFS
CFS and CVM are not supported on all versions of HP-UX (on HP-UX releases that
support them; see “About Veritas CFS and CVM from Symantec” (page 25)).
NOTE: For specific CFS Serviceguard Storage Management Suite product information
refer to your version of the HP Serviceguard Storage Management Suite Release Notes.
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_______
42 Serviceguard Configuration for Oracle 10g RAC