From your description it almost sounds like your standby wasn’t the standby you
thought it was. Like your TNS is pointing somewhere other than you thought.
Sent from my iPad
On Oct 11, 2018, at 04:59, Howard Latham <howard.latham@xxxxxxxxx> wrote:
Oracle 11.2.0.4 redhat 5.
I just cant get it to work!
Everything in the DGB setup looked fine. Even got it checked by a third
party.
But just as last time we tried we got a message from broker saying cannot
switchover and primary was still primary but when I looked
then we had two standbys. Nightmare!
My question is why did that happen?
The standby/primary pair operate fine manually but I really wanted to use
DGB.
My method to recover from this was
1. Connect to standby which should be primary. Alter database activate
standby database;
2. Rman into standby which should be standby – restore database;
3. Start recovery at end of restore.
Howard A. Latham