Re: dataguard Broker

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Thu, 11 Oct 2018 21:20:47 +0700
Message-ID: <CAP50yQ8uSD-wJZxGxyrvVJ9dh=xu_H2K3=WBnVY0i3=EbGS8+Q_at_mail.gmail.com>



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.

On Thu, Oct 11, 2018 at 5:57 PM Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> Can you send the full set of steps, commands, show configuration and show
> database verbose, for the broke configuration?
>
> Sent from my iPad
>
> On Oct 11, 2018, at 04:59, 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
>
>
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 11 2018 - 16:20:47 CEST

Original text of this message