Administering Oracle Data Guard Application Resource Groups

Language:

This section shows you how to delete an application resource group from an Oracle Data Guard protection group.

How to Delete an Application Resource Group From an Oracle Data Guard Protection Group

You can remove an application resource group from a protection group without altering the state or contents of the application resource group. You can remove shadow Oracle database-server resource groups at any time, without affecting the Oracle database-server resource groups or Oracle databases that they represent. You can remove these resource groups because the shadow Oracle database-server resource groups simply reflect the status of the real Oracle database-server resource groups and do not control the Oracle databases.

Note - You can also accomplish this task by using the Oracle Solaris Cluster Manager browser interface. Click Partnerships, click the partnership name, click the protection group name, and in the Data Replication Components section click Remove. 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

Ensure that the following conditions are met:

The protection group is defined on the local cluster.
The resource group to remove is part of the application resource groups of the protection group.

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.
Remove the application resource group from the protection group.
```
phys-node-n# geopg remove-resource-group resource-group-list protection-group
```
resource-group-list

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 removes an application resource group from a protection group on the local cluster. If the partner cluster contains a protection group of the same name, the application resource group is also removed from the protection group of the partner cluster.

If the resource group that is being removed shares dependencies with other resource groups in the protection group and the External_Dependency_Allowed protection group property is set to FALSE, you also need to remove all other resource groups that share dependencies with the resource group that is being removed.

If the remove operation fails on the local cluster, the configuration of the protection group is not modified. Otherwise, the Configuration is removed and its status is set to OK on the local cluster.

If the Configuration status is set to OK on the local cluster, but the remove operation is unsuccessful on the partner cluster, the Configuration is removed from the partner cluster and the configuration status is set to Error on the partner cluster.

Example 4 Deleting an Application Resource Group From a Protection Group

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

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