RE: RAC dataguard - what happens when recovering instance goes down ?
Date: Mon, 18 May 2009 16:25:17 -0400
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.
To: premj_at_rediffmail.com; oracle-l_at_freelists.org 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….
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prem Khanna J
Sent: Monday, May 18, 2009 8:59 AM
Subject: RAC dataguard - what happens when recovering instance goes down ?
we have 2 node 10gR2 RAC dataguard setup on AIX5.3L.
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 !
Hotmail® has ever-growing storage! Don’t worry about storage limits. http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage1_052009
Received on Mon May 18 2009 - 15:25:17 CDT