Missing archived logs in v$archived_log

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Sat, 19 Dec 2009 21:39:04 -0800 (PST)
Message-ID: <df53ea95-e3e0-41d5-8ac4-a1591c89b9bd_at_j4g2000yqe.googlegroups.com>



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. Received on Sat Dec 19 2009 - 23:39:04 CST

Original text of this message