Adding an Application Resource Group to an Oracle Data Guard Protection Group

Language:

To make an application highly available, you must ensure that the application is managed as a resource in an application resource group. Unlike other data replication modules, the Oracle database-server resource group is not added to the protection group. Instead, a shadow Oracle database-server resource group is added to represent this resource group.

You can add and remove the shadow Oracle database-server resource group to and from the protection group at any time without affecting the Oracle Data Guard data replication. This fact does not prevent you from adding other, non-Oracle database-server resource groups to the protection group if necessary. However, these applications cannot use any data that requires replication to the standby cluster as only Oracle Data Guard is supported in this type of protection group.

You need to replicate, on the standby cluster, all entities that you configure for the primary cluster's application resource group. Examples of entities that you need to replicate are application data resources, configuration files, and resource groups. Resource group names must also match on both clusters. In addition, the data that the application resource uses needs to be replicated on the standby cluster.

How to Add an Application Resource Group to an Oracle Data Guard Protection Group

Note - You can also accomplish this procedure by using the Oracle Solaris Cluster Manager browser interface. Click Partnerships, click the partnership name, click the protection group name, and in the Resource Groups section click Add Resource Groups. For more information about Oracle Solaris Cluster Manager, see Chapter 13, Using the Oracle Solaris Cluster Manager Browser Interface in Oracle Solaris Cluster 4.3 System Administration Guide.

Before You Begin

You can add an existing resource group, other than an Oracle database-server resource group containing an Oracle database-server resource, to the list of application resource groups for a protection group. If you do try to add an Oracle database-server resource group, the geopg command returns an error.

Before you add an application resource group (of any other type) to a protection group, ensure that the following conditions are met:

The protection group is defined.
The application resource group does not need any data replicating. You are not prevented from adding such resource groups, but the Oracle Data Guard module does not coordinate the switchover of other types of data replication.
The resource group to add already exists on both clusters and is in an appropriate state.

Assume the root role or assume a role that is assigned the Geo Management rights profile.
For more information, see Securing Geographic Edition Software in Oracle Solaris Cluster 4.3 Geographic Edition Installation and Configuration Guide.
Note - If you use a role with Geo Management rights, ensure that the /var/cluster/geo ACLs are correct on each node of both partner clusters. If necessary, assume the root role on the cluster node and set the correct ACLs.
```
# chmod A+user:username:rwx:allow /var/cluster/geo
```
The /var/cluster/geo directory must have the correct access control lists (ACL) applied for compatibility between the Geo Management rights profile and Oracle Data Guard.

Ensure that the Auto_start_on_new_cluster property of the resource group is set to False.

# clresourcegroup show -p Auto_start_on_new_cluster resource-group

If necessary, change the property value to False.

# clresourcegroup set -p Auto_start_on_new_cluster=False resource-group

If the application resource group must have dependencies on resource groups and resources that are not managed by this protection group, ensure that the External_Dependency_Allowed property of the protection group is set to True.
Issue the following command to view the current property setting:
```
# geopg list protection-group | grep -i external_dependency_allowed
```
If necessary, change the property value to True.
```
# geopg set-prop -p External_Dependency_Allowed=TRUE protection-group
```
Start the protection group or change the state of the application resource group to a state that is required for the addition to be allowed.
The following are Geographic Edition requirements for application resource groups:
- On the secondary cluster, the application resource group be in the Unmanaged state.
- If the protection group is stopped on the primary cluster, the application resource group must be Unmanaged on the primary cluster.
- If the protection group is active on the primary cluster, the application resource group must be in the Unmanaged or Online state on the primary cluster.
Add an application resource group to the protection group.
```
phys-node-n# geopg add-resource-group application-resource-group protection-group
```
application-resource-group

Specifies the name of the application resource group. You can specify more than one resource group in a comma-separated list.

protection-group

Specifies the name of the protection group.

This command adds an application resource group to a protection group on the local cluster. If the partner cluster contains a protection group of the same name, the command then propagates the new configuration information to the partner cluster.

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

After the application resource group is added to the protection group, the application resource group is managed as an entity of the protection group. The application resource group is affected by protection group operations such as start, stop, switchover, and takeover.

Example 2 Adding an Application Resource Group to an Oracle Data Guard Protection Group

This example shows how to add two application resource groups, apprg1 and apprg2, to sales-pg.

phys-paris-1# geopg add-resource-group apprg1,apprg2 sales-pg