I ran into below error when performed a switchover operation in my dataguard configuration which has one primary and two standby databases.
"ORA-16597: Oracle Data Guard broker detects two or more primary databases"
Please see below
[oracle@dbhost01 ]$ dgmgrl /
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Wed Apr 19 15:13:05 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "tureepr"
Connected as SYSDG.
DGMGRL> connect sys/ringrose;
Connected to "tureepr"
Connected as SYSDBA.
DGMGRL> show configuration;
Configuration - tureepr_cfg
Protection Mode: MaxPerformance
Members:
tureepr - Primary database
tureedr - Physical standby database
tureetr - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 35 seconds ago)
Performing the swithcover operation.
DGMGRL> switchover to tureetr;
Performing switchover NOW, please wait...
Operation requires a connection to database "tureetr"
Connecting ...
Connected to "tureetr"
Connected as SYSDBA.
New primary database "tureetr" is opening...
Oracle Clusterware is restarting database "tureepr" ...
Connected to "tureepr"
Switchover succeeded, new primary is "tureetr"
DGMGRL>
DGMGRL> show configuration;
Configuration - tureepr_cfg
Protection Mode: MaxPerformance
Members:
tureetr - Primary database
tureepr - Physical standby database
tureedr - Physical standby database (disabled)
ORA-16597: Oracle Data Guard broker detects two or more primary databases
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 60 seconds ago)
DGMGRL>
Even though the switchover was completed successfully, for some reason, I see one of the second standby database in disabled state and I also see below error.
ORA-16597: Oracle Data Guard broker detects two or more primary databases
First, I went ahead and enabled the second standby database which got disabled during the switchover operation
DGMGRL> enable database tureedr
Enabled.
DGMGRL>
Surprisingly When I checked the configuration, I saw that the configuration came back to normal, wondering how and why ...
DGMGRL> show configuration;
Configuration - tureepr_cfg
Protection Mode: MaxPerformance
Members:
tureetr - Primary database
tureepr - Physical standby database
tureedr - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 52 seconds ago)
DGMGRL>
No comments:
Post a Comment