Re: Missing archived logs in v$archived_log

From: bdbafh <>
Date: Sun, 20 Dec 2009 07:31:58 -0800 (PST)
Message-ID: <>

On Dec 20, 12:39 am, zigzagdna <> wrote:
> I am using Oracle 11g 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,
> never had this issue
> with older releases.
> I a not using any data guard. Any ideas will be greatly appreciated.

what do you see in the alert log regarding the log sequence# 893 being archived?

-bdbafh Received on Sun Dec 20 2009 - 09:31:58 CST

Original text of this message