How to Delete an Oracle Data Guard Protection Group

Before You Begin

To delete a protection group on all clusters, run the geopg delete command on each cluster where the protection group exists.

Before deleting a protection group, ensure that the following conditions are met:

• The protection group exists locally

• The protection group is offline on the local cluster

To keep the application resource groups online while deleting a protection group, remove the application resource groups from the protection group before deleting the protection group. You do not need to do anything to shadow RAC server proxy resource groups, as deleting the protection group removes these resource groups without affecting the RAC server proxy resource groups that they shadow.

1. Log in to a node in the cluster where you want to delete the protection group, for example, cluster-paris.

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

   cluster-paris is the primary cluster. See Example Sun Cluster Geographic Edition Cluster Configuration in Sun Cluster Geographic Edition System Administration Guide for a sample cluster configuration.

2. Delete the protection group.

   phys-node-n# geopg delete protectiongroupname

   This command deletes the configuration of the protection group from the local cluster. The command also removes the Oracle RAC server proxy resource groups and the replication resource group for the Oracle Data Guard Broker configuration in the protection group.

   If the protection group is not deleted, the Configuration status is set to Error. Resolve the error and rerun the geopg delete command.

Example 2–3 Deleting a Protection Group

This example shows how to delete a protection group from both partner clusters.

# rlogin cluster-paris -l root
phys-paris-1# geopg delete sales-pg
# rlogin cluster-newyork -l root
phys-newyork-1# geopg delete sales-pg

Example 2–4 Deleting a Protection Group While Keeping Application Resource Groups Online

This example shows how to keep two application resource groups, apprg1 and apprg2, online, while deleting the protection group that they share, sales-pg.

Remove the application resource groups from the protection group and delete the protection group.

phys-paris-1# geopg remove-resource-group apprg1,apprg2 sales-pg
phys-paris-1# geopg stop -e global sales-pg
phys-paris-1# geopg delete sales-pg

Unlike other data replication modules, the Oracle RAC server proxy resource group is not added to the protection group. Instead, a shadow RAC server proxy resource group is added to represent this resource group. You can add and remove the shadow RAC server proxy resource group to and from the protection group at any time without affecting the Oracle Data Guard data replication.

Consequently, the application resource groups that are shown in this example can have no data to replicate, as only Oracle Data Guard data replication is supported in this particular protection group. Application resource groups that might meet this criteria can be scalable web servers, where their data is static or held on some remote storage that is not controlled by this cluster.