Re: "Sticky" Archived logs

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Fri, 24 Jan 2014 23:01:34 +0530
Message-ID: <CAABGLu+XECo4F5HGT4xbLAi0S71q1VfSdbGZwRHeUppeR=s-Kg_at_mail.gmail.com>

What is the status from "v$managed_standby" for the sequence standby is expecting? is at WAIT_FOR_LOG?

Interesting why there is no information either on primary or standby alert logs such as possible network disconnect or anything else.

If it is ADG, i would have looked at ASH report for the standby (or) also we can check the wait events from the primary database using views(v$session)

-Is the DR site is too far (or) have enough amount of bandwidth to accomodate redo transactions?
Hope there is no delay_mins applicable.

• Nassyam Basha

On Fri, Jan 24, 2014 at 9:18 PM, Howard Latham <howard.latham_at_gmail.com>wrote:

> Oracle 11 Redhat Linux 4 Physical DG.
>
> Anyone ever seen this?
>
> My standby stopped advancing. So I did what I always do
> crashed the recovery and ran it manually. This usually highlights the
> problem
> or even cures it. But All I get is one archived log applied then it froze
> again.
> I have done this several times and each time the 'stuck' log is applied
> almost immediately then the db apply stops again. No errors just a lot of
> silence!
>
>
> --
> Howard A. Latham
>
>
>

-- 
Thanks & Regards,
Nassyam Basha.
www.oracle-ckpt.com

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

Received on Fri Jan 24 2014 - 18:31:34 CET