Re: Missing archived logs in v$archived_log

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Sun, 20 Dec 2009 05:54:02 -0800 (PST)
Message-ID: <437a121e-80bf-44a2-a867-6c68e2d9874e_at_q16g2000vbc.googlegroups.com>

On Dec 20, 2:24 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Sat, 19 Dec 2009 21:39:04 -0800, zigzagdna wrote:
> > I am using Oracle 11g 11.1.0.7 on HP UNIX 11.23. My database has been
> > running in archived log mode.
> > Yet when I go and look in v$archived_log, I see some archived logs
> > missing,
> > i.e, when I do select name from v$archived_log, I see: arch1_891_XXX.arc
> > arch1_892_xxx.arc
> > arch1_895_xxx.arc
>
> > I see this happening every two three days, I do run
> > alter system archive log current
> > during my RMAN backups but that should not be the cause.
>
> > I have seen  this behavior since I started using Oracle 11.1.0.7, never
> > had this issue
> > with older releases.
>
> > I a not using any data guard. Any ideas will be greatly appreciated.
>
> Are you using RAC? I've had situations like that with RAC databases when
> the archive was not written down by the node I expected. In that
> situation, every instance had its own log_archive_dest.
>
> --http://mgogala.byethost5.com- Hide quoted text -
>
> - Show quoted text -

This is non RAC single instance. Received on Sun Dec 20 2009 - 07:54:02 CST