Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Geographic Edition Data Replication Guide for Oracle Data Guard Oracle Solaris Cluster Geographic Edition

Search Scope:

- This Document
- Entire Library

## Creating, Modifying, Validating, and Deleting an Oracle Data Guard Protection Group

This section covers the following topics:

Note - You can create protection groups that are not configured to use data replication. To create a protection group that does not use a data replication subsystem, omit the `-d` datareplicationtype option when you use the `geopg` command. If you omit this option, the `geoadm status` command shows that the state of data replication is `NONE`.

## How to Create and Configure an Oracle Data Guard Protection Group

The following example builds on the example configuration that was described in Chapter 1, Replicating Data With Oracle Data Guard Software.

In this example, the `sales` database is online on the `cluster-paris` cluster and is protected by Oracle Data Guard.

Ensure that the `mysales.com` Oracle Data Guard Broker configuration exists before you proceed, as Geographic Edition does not create the configuration for you.

Before You Begin

Ensure that the following conditions are met:

- Your clusters are members of a partnership.

- The protection group that you are creating does not already exist.

Note - Protection group names are unique in the global Geographic Edition namespace. You cannot use the same protection group name in two partnerships on the same system.

You can also replicate the existing configuration of a protection group from a remote cluster to the local cluster. For more information, see Replicating the Oracle Data Guard Protection Group Configuration to a Partner Cluster.

1. Become superuser or assume a role that is assigned the Geo Management RBAC rights profile.

   For more information about RBAC, see Geographic Edition Software and RBAC in Oracle Solaris Cluster Geographic Edition System Administration Guide.

   Note - If you use a role with Geo Management RBAC rights, ensure that the `/var/cluster/geo` ACLs are correct on each node of both partner clusters. If necessary, become superuser 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 RBAC rights profile and Oracle Data Guard.

2. On all nodes of the local cluster, create a new protection group.

       phys-node-n# geopg create -s partnershipname -d odg \
       -o localrole [-p property [-p...]] protectiongroupname

   `-s` partnershipname

     Specifies the name of the partnership.

   `-d` `odg`

     Specifies that the protection group data is replicated by Oracle Data Guard software.

   `-o` localrole

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

   `-p` propertysetting

     Specifies the properties of the protection group.

     You can specify the following properties:

     - `Description` – Describes the protection group.

     - `Timeout` – Specifies the timeout period for the protection group, in seconds.

   protectiongroupname

     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 Geographic Edition System Administration Guide.

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

   Before creating the protection group, the data replication layer validates that the configuration is correct.

   - If the validation is successful, the local `Configuration` status is set to `OK` and the `Synchronization` status is set to `Error`.

   - If the validation is unsuccessful, the protection group is not created.

## How to Modify an Oracle Data Guard Protection Group

Before You Begin

Ensure that the protection group that you want to modify exists locally.

1. Become superuser or assume a role that is assigned the Geo Management RBAC rights profile.

   For more information about RBAC, see Geographic Edition Software and RBAC in Oracle Solaris Cluster Geographic Edition System Administration Guide.

   Note - If you use a role with Geo Management RBAC rights, ensure that the `/var/cluster/geo` ACLs are correct on each node of both partner clusters. If necessary, become superuser 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 RBAC rights profile and Oracle Data Guard.

2. Modify the configuration of the protection group.

       phys-node-n# geopg set-prop -p property[-p…] protectiongroupname

   `-p` property

     Specifies the properties of the protection group.

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

   protectiongroupname

     Specifies the name of the protection group.

   If the partner cluster contains a protection group of the same name, the `geopg set-prop` command also propagates the new configuration information to the partner cluster.

   The `geopg set-prop` command revalidates the protection group with the new configuration information. If the validation is unsuccessful on the local cluster, the configuration of the protection group is not modified. Otherwise, the protection group is modified and its status is set to `OK` on the local cluster.

   If the protection group status is set to `OK` on the local cluster, but the validation is unsuccessful on the partner cluster, the protection group is modified on the partner cluster and the configuration status is set to `Error` on the partner cluster.

   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 Geographic Edition System Administration Guide.

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

Example 2-2 Modifying the Configuration of a Protection Group

This example shows how to modify the `timeout` property of a protection group.

    phys-paris-1# geopg set-prop -p Timeout=300 sales-pg

## How to Validate an Oracle Data Guard Protection Group

Before You Begin

When the `Configuration` status of a protection group is displayed as `Error` in the output of the `geoadm status` command, you can validate the configuration by using the `geopg validate` command. This command checks the current state of the protection group and its entities.

If the protection group and its entities are valid, the `Configuration` status of the protection groups is set to `OK`. If the `geopg validate` command finds an error in the configuration files, the command displays a message about the error and the configuration remains in the error state. In such a case, you can fix the error in the configuration and run the `geopg validate` command again.

This command validates the configuration of the protection group on the local cluster only. To validate the protection group configuration on the partner cluster, run the command again on the partner cluster.

Before validating the configuration of a protection group, ensure that the protection group you want to validate exists locally and that the common agent container is online on all nodes of both clusters in the partnership.

1. Become superuser or assume a role that is assigned the Geo Management RBAC rights profile.

   For more information about RBAC, see Geographic Edition Software and RBAC in Oracle Solaris Cluster Geographic Edition System Administration Guide.

   Note - If you use a role with Geo Management RBAC rights, ensure that the `/var/cluster/geo` ACLs are correct on each node of both partner clusters. If necessary, become superuser 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 RBAC rights profile and Oracle Data Guard.

2. Validate the configuration of the protection group.

   This command validates the configuration of a single protection group on the local cluster only.

       phys-node-n# geopg validate protectiongroupname

Example 2-3 Validating the Configuration of a Protection Group

This example shows how to validate a protection group.

    phys-node-n# geopg validate sales-pg

### How the Data Replication Layer Validates the Application Resource Groups and Data Replication Entities

During protection group validation, the Oracle Data Guard data replication layer validates the application resource groups in the protection group and the data replication entities. The Oracle Data Guard data replication layer verifies the following conditions:

- The resource group under the control of the protection group that is being validated does not contain a resource group that contains an Oracle database-server resource.

  Specifically, if you add a failover resource group, it must not contain a `SUNW.oracle_server` resource. Or, if you add a scalable resource group, it must not contain a `SUNW.scalable_rac_server_proxy` resource.

  You cannot add these resource groups to an Oracle Data Guard protection group because the Oracle database that is managed by the Oracle database-server resource is shut down on the standby cluster when the protection group is started globally, thus disabling the Oracle Data Guard data replication.

- The `Auto_start_on_new_cluster` property in an application resource group in the protection group is set to `False`.

  When you bring a protection group online on the primary cluster, the data replication layer brings the application resources groups that are participating in that protection group online only on the same primary cluster. Setting the `Auto_start_on_new_cluster` property to `False` prevents the Oracle Solaris Cluster resource group manager from automatically starting the application resource groups. In this case, the startup of resource groups is reserved for the Geographic Edition software.

  When the protection group is activated, application resource groups in the protection group need to be online only on the primary cluster.

- The Oracle `dgmgrl` command shows a `SUCCESS` status for each of the Oracle Data Guard Broker configurations.

  The presence of Oracle `ORA-` messages in the output from the `dgmgrl` command might indicate that the `sysdba_username` password is incorrect or that the cluster has been disabled. This information is reflected in the status of the replication resource for the Oracle Data Guard Broker configuration.

- The Oracle Data Guard Broker configuration details match those held by Geographic Edition.

  The details to check include which cluster is primary, the configuration name, the database mode (for both the primary and standby cluster), the replication mode, and the standby type.

- The `sysdba_username` password is valid for the standby cluster, to ensure that switchovers are possible.

  If the `sysdba_username` property is not " ", the username and password combination must be correct. Or, the Oracle wallet connection mechanism, using `dgmgrl /@service_name`, must work correctly.

- The Oracle Data Guard Broker property `BystandersFollowRoleChange` is set to `NONE` and the Oracle Data Guard Broker setting `FAST_START FAILOVER` is disabled.

When validation is complete, Geographic Edition software creates the shadow Oracle database-server resource group and resource, the replication resource group, and the resources for this replication resource group, if they do not exist, and brings them online. If a resource group or a resource with the same name already exists, the Geographic Edition operations might fail. Geographic Edition software cannot create a new resource group or resource of the same name as one that already exists.

The `Configuration` status is set to `OK` after successful validation. If validation is not successful, the `Configuration` status is set to `Error`.

## How to Delete an Oracle Data Guard Protection Group

Perform this procedure on each cluster where you want to delete the protection group, for example, `cluster-paris`, where `cluster-paris` is the primary cluster. See Example Geographic Edition Cluster Configuration in Oracle Solaris Cluster Geographic Edition System Administration Guide for a sample cluster configuration.

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

Note - To keep the application resource groups in the protection group 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 Oracle database-server resource groups, as deleting the protection group removes these resource groups without affecting the Oracle database-server resource groups that they shadow.

1. Become superuser or assume a role that is assigned the Geo Management RBAC rights profile.

   For more information about RBAC, see Geographic Edition Software and RBAC in Oracle Solaris Cluster Geographic Edition System Administration Guide.

   Note - If you use a role with Geo Management RBAC rights, ensure that the `/var/cluster/geo` ACLs are correct on each node of both partner clusters. If necessary, become superuser 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 RBAC rights profile and Oracle Data Guard.

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 database-server 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-4 Deleting a Protection Group

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

    # ssh root@cluster-paris
    phys-paris-1# geopg delete sales-pg
    # ssh root@cluster-newyork
    phys-newyork-1# geopg delete sales-pg

Copyright © 2008, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices |