Under certain circumstances after a switchover, the protection group roles might no longer match the database roles. Examples of when this might happen are if the Database Administrator issues an Oracle Data Guard switchover directly, or if checks run during a protection-group switchover fail but the switchover successfully completes. If the protection group and database roles no longer match, you must manually synchronize them.
Perform this procedure to change the roles of a Geographic Edition protection group to match the roles of an Oracle Data Guard configuration that has been switched.
# clresource status odg-configuration-odg-rep-rs
Faulted - Role "physical standby database" given for database local-database does not match role "primary database" configured Oracle Data Guard.
# geadm status Cluster: cluster-paris Partnership "paris-newyork-ps" : OK Partner clusters : cluster-newyork Synchronization : OK ICRM Connection : OK Heartbeat "hb_cluster-paris~cluster-newyork" monitoring "cluster-newyork": OK Plug-in "ping_plugin" : Inactive Plug-in "tcp_udp_plugin" : OK Protection group "odg-pg" : Error Partnership : paris-newyork-ps Synchronization : OK Cluster cluster-paris : Error Role : Secondary Activation state : Activated Configuration : Error Data replication : Error Resource groups : OK Cluster cluster-newyork : Error Role : Primary Activation state : Deactivated Configuration : Error Data replication : Error Resource groups : OK
DGMGRL> show configuration; Configuration Name: odg-configuration Enabled: YES Protection Mode: MaxPerformance Databases: local-database - Primary database remote-database - Physical standby database Fast-Start Failover: DISABLED Current status for "odg-configuration": SUCCESS DGMGRL>
phys-paris-1# geopg stop -e local odg-pg
phys-paris-1# geopg takeover -f odg-pg Processing operation... The timeout period for this operation on each cluster is 3600 seconds (3600000 milliseconds)… "Takeover" operation succeeded for the protection group "odg-pg". phys-paris-1#
phys-paris-1# geopg validate odg-pg phys-newyork-1# geopg validate odg-pg
phys-paris-1# geopg start -e global odg-pg Processing operation... The timeout period for this operation on each cluster is 3600 seconds (3600000 milliseconds)… Protection group "odg-pg" successfully started. phys-paris-1#
phys-paris-1# geoadm status Cluster: cluster-paris Partnership "paris-newyork-ps" : OK Partner clusters : cluster-newyork Synchronization : OK ICRM Connection : OK Heartbeat "hb_cluster-paris~cluster-newyork" monitoring "cluster-newyork": OK Plug-in "ping_plugin" : Inactive Plug-in "tcp_udp_plugin" : OK Protection group "odg-pg" : OK Partnership : paris-newyork-ps Synchronization : OK Cluster cluster-paris : OK Role : Primary Activation state : Activated Configuration : OK Data replication : OK Resource groups : OK Cluster cluster-newyork : OK Role : Secondary Activation state : Activated Configuration : OK Data replication : OK Resource groups : OK