Re: FRA Outage

From: Don Seiler <don_at_seiler.us>
Date: Fri, 27 Jun 2014 14:29:20 -0500
Message-ID: <CAHJZqBCdkRjOs=jemp20KWLdsRpKO9Tw966TCNOiQZZnnawrSg_at_mail.gmail.com>

Interesting. I could see the primary archiver maybe hanging while waiting for the standby instance to respond, which it won't if that instance is frozen waiting for archivelog space to be freed up. This is all kind of rambling though and better served by an actual sandbox test somewhere.

Don.

On Fri, Jun 27, 2014 at 2:18 PM, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:

> 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
>
>
>

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

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

Received on Fri Jun 27 2014 - 21:29:20 CEST