RE: FRA Outage

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 27 Jun 2014 15:46:23 -0400
Message-ID: <087001cf9240$7a93c2e0$6fbb48a0$_at_rsiz.com>

Primary Outage: ? Outage in exactly what regard?  

Was it hung waiting for an available online redolog group, or did it actually come down?  

What were the messages (if any)?

Did any background processes stop? (If so, which ones, and was there log information?)  

I'd include this in the "should not happen" bucket based on the preliminary information given.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra (Redacted sender "smishra_97_at_yahoo.com" for DMARC)
Sent: Friday, June 27, 2014 3:18 PM
To: don_at_seiler.us; dmarc-noreply_at_freelists.org Cc: oracle-l digest users
Subject: Re: FRA Outage  

Don  

Thanks for the update. Log_archive_dest is not marked Mandatory. We also did few times patching on Standby as well OS maintenance and taken it down and that doesn't caused the outage but FRA filling on standby caused Primary outage is still mysterious. So want to check as how this is related.  

Sanjay  

On Friday, June 27, 2014 3:01 PM, Don Seiler <don_at_seiler.us> wrote:  

It can if the log_archive_dest that points to the standby is marked as "Mandatory". Otherwise if the standby is down the primary will just continue one and then RFS/FAL will fetch the missing logs when the standby is back up.  

On Fri, Jun 27, 2014 at 1:51 PM, Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:

Hi  

Does anyone know how FRA filling on Standby can cause outage on Production.? Has two standby and one primary non-RAC (Both Primary and Standby) where FRA on one Standby caused Outage on production. Database at all place is in Max performance mode. Saw this issue earlier few years back too  

TIA Sanjay  

-- 
Don Seiler
http://www.seiler.us <http://www.seiler.us/>  

 



--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 27 2014 - 21:46:23 CEST