Creating an SRDF Protection Group to Support Oracle RAC

Language:

Geographic Edition software supports Oracle Real Application Clusters (Oracle RAC) with SRDF software. This section contains the following information:

Requirements to Support Oracle RAC With Data Replication Software

Observe the following requirements when you configure Oracle RAC:

Each Oracle Clusterware OCR and Voting Disk Location must be in its own device group on each cluster and cannot be replicated.
Static data such as Oracle Clusterware and database binaries are not required to be replicated. But this data must be accessible from all nodes of both clusters.
You must create storage resources for dynamic database files that are replicated in their own resource groups. These storage resources must be separate from the resource group that holds the storage resource for Oracle Clusterware.
To be able to leave Oracle RAC infrastructure resource groups outside of Geographic Edition control, you must run Geographic Edition binaries on both cluster partners and set the Oracle RAC protection group External_Dependency_Allowed property to true.
Do not add the Oracle Clusterware OCR and Voting Disk device group to the protection group's cluster_dgs property.
Do not add Oracle RAC infrastructure resource groups to the protection group. Only add the rac_server_proxy resource group and resource groups for device groups that are replicated to the protection group. Also, you must set to False the Auto_start_on_new_cluster resource group property for the rac_server_proxy resource group and resource groups and for device groups that are replicated.
When you use a cluster file system for an Oracle RAC file system, such as a flash recovery area, alert, or trace log files, you must manually create on both clusters a separate resource group that uses the HAStoragePlus resource to bring online these corresponding file systems. You must set a strong resource dependency from non-Oracle Clusterware SUNW.ScalDeviceGroup resources to this HAStoragePlus resource. Then add this HAStoragePlus resource group to the Oracle RAC protection group.

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 (Oracle RAC), ensure that the following conditions are met:

Read Requirements to Support Oracle RAC With Data Replication Software.
The node list of the protection group must be the same as the node list of Oracle RAC framework resource group.
If one cluster is running Oracle RAC on a different number of nodes than another cluster, ensure that all nodes on both clusters have the same resource groups defined.

Log in to a cluster node on the primary cluster.
You must be assigned the Geo Management rights profile to complete this procedure. For more information, see Securing Geographic Edition Software in Oracle Solaris Cluster 4.3 Geographic Edition Installation and Configuration Guide.
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 partnership \
-o local-role \
-d srdf \
-p External_Dependency_Allowed=true \
[-p property [-p...]] \
protection-group
```
–s partnership

Specifies the name of the partnership.

–o local-role

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 SRDF software.

–p property-setting
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 Oracle RAC, set 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 device group where the data is written.
For more information about the properties you can set, see Appendix A, Standard Geographic Edition Properties, in Oracle Solaris Cluster 4.3 Geographic Edition System Administration Guide.
protection-group

Specifies the name of the protection group.
For information about the names and values that are supported by Geographic Edition software, see Appendix B, Legal Names and Values of Geographic Edition Entities, in Oracle Solaris Cluster 4.3 Geographic Edition System Administration Guide.

For more information about the geopg command, refer to the geopg(1M) man page.
Add an SRDF device group to the protection group.
```
# geopg add-device-group [-p property [-p…]] protection-group
```
–p property-setting

Specifies the properties of the protection group.

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

protection-group

Specifies the name of the protection group.
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 Oracle 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 Oracle RAC databases can be on the cluster, and the databases can be under Geographic Edition control or not under its control.
```
# geopg add-resource-group resource-group protection-group
```
resource-group

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.

protection-group

Specifies the name of the protection group.