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 _________________________________________________________________ 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
Attachment:
~WRD000.jpg
Description: JPEG image