How to Create a Protection Group for Oracle Real Application Clusters

Before You Begin

Before you create a protection group for Oracle Real Application Clusters (RAC), ensure that the following conditions are met:

• Read Requirements to Support Oracle Real Application Clusters With Data Replication Software.

• The node list of the protection group must be the same as the node list of RAC framework resource group.

• If one cluster is running RAC on a different number of nodes than another cluster, ensure that all nodes on both clusters have the same resource groups defined.

• If you are using the VERITAS Volume Manager cluster feature to manage data, you must specify the cluster feature disk group and Sun Cluster device groups for other data volumes in the cluster_dgs property.

When a cluster and the VERITAS Volume Manager cluster feature software restart, the RAC framework automatically tries to import all cluster feature device groups that were imported already before cluster went down. Therefore, the attempt to import the device groups to the original primary fails.

1. Log in to a cluster node on the primary cluster.

   You must be assigned the Geo Management RBAC rights profile to complete this procedure. For more information about RBAC, see Sun Cluster Geographic Edition Software and RBAC in Sun Cluster Geographic Edition System Administration Guide.

2. Create a new protection group by using the geopg create command.

   This command creates a protection group on all nodes of the local cluster.

   # geopg create -s partnershipname -o localrole -d srdf \ -p External_Dependency_Allowed=true [-p property [-p...]] protectiongroupname

   -s partnershipname

   Specifies the name of the partnership.

   -o localrole

   Specifies the role of this protection group on the local cluster as primary.

   -d srdf

   Specifies that the protection group data is replicated by the EMC Symmetrix Remote Data Facility software.

   -p propertysetting

   Specifies the properties of the protection group.

   You can specify the following properties:

   • Description – Describes the protection group.

   • External_Dependency_Allowed - Specifies whether to allow any dependencies between resource groups and resources that belong to this protection group and resource groups and resources that do not belong to this protection group. For RAC, setting this property to true.

   • Timeout – Specifies the timeout period for the protection group in seconds.

   • Nodelist – Lists the host names of the machines that can be primary for the replication subsystem.

   • Cluster_dgs – Specifies the VERITAS Volume Manager cluster feature disk group where the data is written.

   For more information about the properties you can set, see Appendix A, Standard Sun Cluster Geographic Edition Properties, in Sun Cluster Geographic Edition System Administration Guide.

   protectiongroupname

   Specifies the name of the protection group.

   For information about the names and values that are supported by Sun Cluster Geographic Edition software, see Appendix B, Legal Names and Values of Sun Cluster Geographic Edition Entities, in Sun Cluster Geographic Edition System Administration Guide.

   For more information about the geopg command, refer to the geopg(1M) man page.

3. Add an EMC Symmetrix Remote Data Facility device group to the protection group.

   # geopg add-device-group [-p property [-p...]] protectiongroupname

   -p propertysetting

   Specifies the properties of the protection group.

   For more information about the properties you can set, see Appendix A, Standard Sun Cluster Geographic Edition Properties, in Sun Cluster Geographic Edition System Administration Guide.

   protectiongroupname

   Specifies the name of the protection group.

4. Add to the protection group only the rac_server_proxy resource group and the resource groups for device groups that are replicated.

   ---

   Note –

   Do not add the RAC framework resource group to the protection group. This ensures that, if the protection group becomes secondary on the node, the framework resource group does not become unmanaged. In addition, multiple RAC databases can be on the cluster, and the databases can be under Sun Cluster Geographic Edition control or not under its control.

   ---

   # geopg add-resource-group resourcegroup protectiongroupname

   resourcegroup

   Specifies a comma-separated list of resource groups to add to or delete from the protection group. The specified resource groups must already be defined.

   The protection group must be online before you add a resource group. The geopg add-resource-group command fails when a protection group is offline and the resource group that is being added is online.

   ---

   Note –

   If a protection group has already been started at the time that you add a resource group, the resource group remains unmanaged. You must start the resource group manually by running the geopg start command.

   ---

   protectiongroupname

   Specifies the name of the protection group.

Example 2–3 Creating a Protection Group for RAC

This example creates the protection group pg1 which uses RAC and the cluster feature.

A cluster feature disk group oracle-dg controls the data which is replicated by the EMC Symmetrix Remote Data Facility device group DG01. The node list of the RAC framework resource group is set to all nodes of the cluster.

1. Create the protection group on the primary cluster with the cluster feature disk group oracle-dg.

   # geopg create -s pts1 -o PRIMARY -d srdf -p cluster_dgs=racdbdg \ -p external_dependency_allowed=true pg1 Protection group "pg1" successfully created.

2. Add the EMC Symmetrix Remote Data Facility device group DG01 to protection group pg1.

   # geopg add-device-group DG01 pg1 Device group "DG01" successfully added to the protection group "pg1".

3. Add the rac_server_proxy_rg resource group and the replicated device-group resource groups, hasp4rac-rg and scaldbdg-rg, to the protection group.

   # geopg add-resource-group rac_server_proxy-rg,hasp4rac-rg,scaldbdg-rg pg1