Re: Dataguard errors in standby alert log

From: Don Seiler <don_at_seiler.us>
Date: Wed, 22 Sep 2010 07:56:58 -0500
Message-ID: <AANLkTimz2__w5pVvT10nZ_cz9fTWupA6pHQ6=0L==Doz_at_mail.gmail.com>

Yes this is a normal message for manual recovery. Are you using standard edition?

Don.

On 9/22/10, De DBA <dedba_at_tpg.com.au> wrote:
> G'day.
>
> I don't seem to be able to find an answer to this:
>
> Oracle 10.2.0.4 physical standby database on Solaris 10 64bit, SPARC.
>
> The v$archive_gap view does not have any entries, but the alert logs
> ever since the standby was created (2009) show:
>
> ..
> Media Recovery Log <log name>
> Errors with log <log name>
> ORA-00279 signalled ..
> ..
> ALTER DATABASE RECOVER CANCEL
> ..
>
> for *every* archive log that arrives.
>
> I found this site: http://www.dbvisit.com/knowledgebase.php , which says
> that at least the ORA-00279 is *normal* behaviour, but is it? Why would
> Oracle throw an error if it is in fact chugging along fine? I am unsure
> if this standby is in fact reliable. Can anyone shed light on this?
>
> Thanks,
> Tony
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 22 2010 - 07:56:58 CDT