dataguard Broker

[Howard Latham]

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

[Andrew Kerber]

Can you send the full set of steps, commands, show configuration and show database verbose, for the broke configuration?

Sent from my iPad

Post by Howard Latham
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

[Stefan Knecht]

And particular, the alert logs and drc logs from both databases at the time
of the switchover where you ended up with two standbys would need to be
looked at. That'll show what exactly happened.

Post by Andrew Kerber
Can you send the full set of steps, commands, show configuration and show
database verbose, for the broke configuration?
Sent from my iPad
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

[Andrew Kerber]

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

Post by Howard Latham
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

[Andrew Kerber]

Are you using grid infrastructure? In that case the broker seems to randomly sometimes use the GI home tnsnames file instead of the dB home. I never figured out why. Use a soft link to avoid issues.

Sent from my iPad

Post by Howard Latham
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

[Jose Rodriguez]

I got into a similar situation simply by forgetting to use a TNS entry
while connecting to the Broker CLI and using a bequeath connection instead.
If you provide the details you've been asked for we may shed some further
light on this.

Cheers.
[image: Pythian] <http://www.pythian.com/>
*Jose Rodriguez* | Oracle Database Consultant | [image: LinkedIn]
<https://www.linkedin.com/company/pythian>
*t* [phone] <+1+613+565+8696> *ext.* 1393
*m* [phone] <+34+607+55+49+91>
***@pythian.com
*www.pythian.com* <https://www.pythian.com/>
[image: Pythian] <https://www.pythian.com/email-footer-click>

Post by Howard Latham
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