Re: RAC dataguard - what happens when recovering instance goes down ?

  • From: Karl Arao <karlarao@xxxxxxxxx>
  • To: martinfbrown@xxxxxxxxxxx
  • Date: Tue, 19 May 2009 10:14:37 +0800

Hi Martin,

That's cool :)
How do you flag such events in Nagios? and notify you through email?

I have Nagios books, but never had a chance to play with it.



- Karl Arao
http://karlarao.wordpress.com



On Tue, May 19, 2009 at 4:25 AM, Martin Brown <martinfbrown@xxxxxxxxxxx>wrote:

>  We use maximum performance with log_archive_min_succeed_dest set to 1. If
> the standby(s) fail, then nagios starts crying like a baby and we restart
> managed recovery. It usually catches up in less than 15 minutes -- even if
> it's been down for an hour.
>
> ------------------------------
> From: Mark.Bobak@xxxxxxxxxxxx
> To: premj@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Date: Mon, 18 May 2009 09:22:48 -0400
> Subject: RE: RAC dataguard - what happens when recovering instance goes
> down ?
>
>
>  Well, I’m no Dataguard expert, but, seems to me, if stand by site goes
> down, primary would remain up and as soon as standby was restored, log
> shipping would begin playing catch up.  Also, if you’re in maximum
> protection mode, then at some point, you’d run out of space to queue up
> archivelogs to be shipped to standby, at which point primary would hang….
>
>
>
> But, that’s all based on what I read, and zero experience so take it for
> what it’s worth….
>
>
>
> -Mark
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Prem Khanna J
> *Sent:* Monday, May 18, 2009 8:59 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* RAC dataguard - what happens when recovering instance goes down
> ?
>
>
>
> Friends,
>
> we have 2 node 10gR2 RAC dataguard setup on AIX5.3L.
>
> Just curiuous:
> what happens when the recovering standby instance goes down ?
> Has anyone come across this situation ? RTFM-ed , Google-ed ..
> but still could not find the answer !
>
> Regards,
> Prem
>
> [image: Image removed by 
> sender.]<http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?>
>
>
>
> ------------------------------
> Hotmail® has ever-growing storage! Don’t worry about storage limits. Check
> it 
> out.<http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage1_052009>
>

JPEG image

Other related posts: