Using Serviceguard Extension for RAC, 2nd Edition, February 2005 Update
Table Of Contents
- Using Serviceguard Extension for RAC
- 1 Introduction to Serviceguard Extension for RAC
- 2 Serviceguard Configuration for Oracle RAC
- Planning Database Storage
- Installing Serviceguard Extension for RAC
- Configuration File Parameters
- Creating a Storage Infrastructure with LVM
- Building Volume Groups for RAC on Mirrored Disks
- Building Mirrored Logical Volumes for RAC with LVM Commands
- Creating RAC Volume Groups on Disk Arrays
- Creating Logical Volumes for RAC on Disk Arrays
- Oracle Demo Database Files
- Displaying the Logical Volume Infrastructure
- Exporting the Logical Volume Infrastructure
- Installing Oracle Real Application Clusters
- Cluster Configuration ASCII File
- Creating a Storage Infrastructure with CVM
- Initializing the VERITAS Volume Manager
- Preparing the Cluster for Use with CVM
- Starting the Cluster and Identifying the Master Node
- Converting Disks from LVM to CVM
- Initializing Disks for CVM
- Creating Disk Groups for RAC
- Creating Volumes
- Oracle Demo Database Files
- Adding Disk Groups to the Cluster Configuration
- Using Packages to Configure Startup and Shutdown of RAC Instances
- Starting Oracle Instances
- Creating Packages to Launch Oracle RAC Instances
- Configuring Packages that Access the Oracle RAC Database
- running cluster:adding or removing packages
- Writing the Package Control Script
- Using Serviceguard Manager to Write the Package Control Script
- Using Commands to Write the Package Control Script
- Customizing the Package Control Script
- Optimizing for Large Numbers of Storage Units
- Customizing the Control Script for RAC Instances
- Configuring an Oracle RAC Instance Package
- Using Serviceguard Manager to a Configure Oracle RAC Instance Package
- Enabling DB Provider Monitoring
- 3 Maintenance and Troubleshooting
- Reviewing Cluster and Package States with the
- Managing the Shared Storage
- Removing ServiceGuard Extension for RAC from a System
- Monitoring Hardware
- Adding Disk Hardware
- Replacing Disks
- Replacement of I/O Cards
- Replacement of LAN Cards
- Monitoring RAC Instances
- A Blank Planning Worksheets
Serviceguard Configuration for Oracle RAC
Planning Database Storage
Chapter 232
Planning Database Storage
The files needed by the Oracle database must be placed on physical
volumes that are accessible to all RAC cluster nodes. This section shows
how to plan the volumes using either SLVM or VERITAS CVM storage
groups.
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 (an one undo tablespace for Oracle9) 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 A, “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.