Re: "Sticky" Archived logs

From: Stojan Veselinovski <stojan.veselinovski_at_gmail.com>
Date: Sun, 26 Jan 2014 13:12:57 +1100
Message-ID: <CALn1tDsk9awf+pEfiCyJF1jdWaDP7q4g3fTaFye6wDhEaLzgKA_at_mail.gmail.com>

Only going off faint memory here but I recall a similar issue a year or two back.

I think it was the archivers on the primary which were stuck somehow.  Killing them fixed our issue.

Stojan.

On Sat, Jan 25, 2014 at 4:31 AM, Nassyam Basha <nassyambasha_at_gmail.com>wrote:

> 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 Sun Jan 26 2014 - 03:12:57 CET