Sun Cluster Geographic Edition Data Replication Guide for Oracle Data Guard

Migrating Services That Use Oracle Data Guard With a Switchover

You perform a switchover of an Oracle Data Guard protection group when you want to migrate services to the partner cluster in an orderly fashion. A switchover includes the following operations:

Application services are unmanaged on the former primary cluster cluster-paris.

For a reminder of which cluster is cluster-paris, see Example Sun Cluster Geographic Edition Cluster Configuration in Sun Cluster Geographic Edition System Administration Guide.
The data replication role is reversed and now continues to run from the new primary, cluster-newyork, to the former primary, cluster-paris.
Application services and the Oracle shadow RAC server proxy resource groups are brought online on the new primary cluster cluster-newyork.

This section provides the following information:

How to Switch Over an Oracle Data Guard Protection Group From the Primary to the Standby Cluster

Before You Begin

For a switchover to occur, data replication must be active between the primary cluster and the standby cluster, that is, the Oracle Data Guard Broker configuration is enabled. Additionally, the Oracle Data Guard Broker show configuration command must show a SUCCESS state. This state is reflected in the state of the Sun Cluster Geographic Edition replication resource for this Oracle Data Guard Broker configuration, which should show the online state.

Before you switch over a protection group from the primary cluster to the standby cluster, ensure that the following conditions are met:

Sun Cluster Geographic Edition software is running on the both clusters.
The standby cluster is a member of a partnership.
Both cluster partners can be reached.
The overall state of the protection group is set to OK.

Log in to a cluster node.

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.

Initiate the switchover.

The application resource groups that are a part of the protection group are stopped and started during the switchover.
phys-node-n# geopg switchover [-f] -m newprimarycluster protectiongroupname
-f

Forces the command to perform the operation without asking you for confirmation.

-m newprimarycluster

Specifies the name of the cluster that is to be the primary cluster for the protection group.

protectiongroupname

Specifies the name of the protection group.

Example 3–1 Forcing a Switchover From the Primary to the Standby Cluster

This example shows how to perform a switchover to the standby cluster.

phys-paris-1# geopg switchover -f -m cluster-newyork sales-pg

Actions Performed by the Sun Cluster Geographic Edition Software During a Switchover

When you run the geopg switchover command, the software confirms that the primary cluster does indeed hold the primary database. The command checks that the remote database is in an enabled state in the Oracle Data Guard Broker configuration. The command also confirms that the configuration is healthy by issuing the Oracle Data Guard command-line interface (dgmgrl) show configuration command to ensure that the command returns a SUCCESS state. If the output from this command indicates that Oracle Data Guard Broker is busy performing its own health check, the Oracle Data Guard command-line interface retries the command until it receives a SUCCESS response or until two minutes have passed. If the command-line interface is unable to get a SUCCESS response, the command fails. If the configuration is healthy, the software performs the following actions on the original primary cluster:

Takes the application resource groups offline and places them in the Unmanaged state
Performs a “switchover to standby-database-name” command for each Oracle Data Guard Broker configuration in the protection group

On the original standby cluster, the command takes the following actions:

Runs the script that is defined in the RoleChange_ActionCmd property
Brings all the Oracle shadow RAC server proxy resource groups and any other application resource groups online

If the command completes successfully, the standby cluster, cluster-newyork, becomes the new primary cluster for the protection group. The original primary cluster, cluster-paris, becomes the new standby cluster. Databases that are associated with the Oracle Data Guard Broker configurations of the protection group have their role reversed according to the role of the protection group on the local cluster. The Oracle shadow RAC server proxy resource group and any other application resource groups are online on the new primary cluster. Data replication from the new primary cluster to the new standby cluster begins.

This command returns an error if any of the previous operations fails. Run the geoadm status command to view the status of each component. For example, the Configuration status of the protection group might be set to Error, depending on the cause of the failure. The protection group might be activated or deactivated.

If the Configuration status of the protection group is set to Error, revalidate the protection group by using the procedures that are described in How to Validate an Oracle Data Guard Protection Group.

If the configuration of the protection group is not the same on each partner cluster, you need to resynchronize the configuration by using the procedures that are described in How to Resynchronize an Oracle Data Guard Protection Group.