Creating the RAC Database

After installing Oracle RAC, create the RAC database from the site which has the source disks of the replication. In this manual, this site is referred to as the local site. The RAC database creation is replicated to the remote site through physical replication and the identical RAC database can be configured on the remote site from the replication target disks.

In our example configuration, a database, hrdb, is created from the San Francisco site. This database is replicated to the San Jose site. After the RAC database is created at the San Francisco site, the identical RAC database must be configured at the San Jose site.

The example hrdb RAC database uses the Cluster File System for storing its data files. The Cluster File System for the RAC data files is created over the replicated disk array disk group. There are two file systems for each RAC database files; one for the database data files and the other for the flash recovery area. The subsequent sections describe the procedures to set up the file systems for RAC database files.

The RAC database can also be configured to use CVM or SLVM raw volumes. As a result, appropriate CVM disk groups or SLVM volume groups must be created with required raw volumes over the replicated disks.

Setting up CFS File Systems for RAC Database Data Files

This section describes how to create CFS file systems for RAC database data files. If you have SLVM configured in your environment, then you must create shared LVM volume groups for the RAC database and import them on all the nodes. For more information on creating shared LVM volume groups for the RAC database, see the Using Serviceguard Extension for RAC manual available at http://www.hp.com/go/hpux-serviceguard-docs.

If you have CVM in your environment, then you must configure CVM disk group MNP packages for all the nodes in the site using the cfsdgadm command and then create volumes. For more information on creating CVM disk group MNP packages, see the Serviceguard Extension for Oracle RAC manual available at http://www.hp.com/go/hpux-serviceguard-docs.

The following procedure explains the steps to configure the CFS file systems for the example hrdb database.

Complete the following procedure on the CFS cluster master node to set up the CFS file systems:

1.Initialize the source disks of the replication pair.

/etc/vx/bin/vxdisksetup -i c4t0d1 /etc/vx/bin/vxdisksetup -i c4t0d2

2.Create a disk group for the RAC database data files. vxdg –s init hrdbdg c4t0d1 c4t0d2

3.Create Serviceguard Disk Group MNP packages for the disk groups. cfsdgadm add hrdbdg sfo_hrdb_dg all=sw SFO_1 SFO_2

4.Activate the CVM disk group in the local site CFS sub-cluster. cfsdgadm activate hrdbdg

5.Create a volume from the disk group. vxassist -g hrdbdg make rac_vol 4500m

6.Create a file system using the created volume.

newfs -F vxfs /dev/vx/rdsk/hrdbdg/rac_vol

7.Create mount points for the RAC database data files and set appropriate permissions. mkdir /cfs

chmod 775 /cfs

Configuring Oracle RAC Database in a Site Aware Disaster Tolerant Architecture 373