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:
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
