Re: dataguard Broker

From: Jose Rodriguez <jrodriguez2_at_pythian.com>
Date: Thu, 11 Oct 2018 13:28:53 +0200
Message-ID: <CAGV8MGps1wB9txYSef73=KP-MtkfEBobx0-BvdMiWmo322-E7A_at_mail.gmail.com>



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* +1 613 565 8696 <+1+613+565+8696> *ext.* 1393 *m* +34 607 55 49 91 <+34+607+55+49+91>
jrodriguez2_at_pythian.com
*www.pythian.com* <https://www.pythian.com/> [image: Pythian] <https://www.pythian.com/email-footer-click>

On Thu, 11 Oct 2018 at 12:00, Howard Latham <howard.latham_at_gmail.com> 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
>
>
>

-- 


--






--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 11 2018 - 13:28:53 CEST

Original text of this message