Re: Missing archived logs in v$archived_log
From: bdbafh <bdbafh_at_gmail.com>
Date: Sun, 20 Dec 2009 07:31:58 -0800 (PST)
Message-ID: <a703112e-cfcc-4879-ab8e-9f0b8b11ee91_at_d10g2000yqh.googlegroups.com>
On Dec 20, 12:39 am, zigzagdna <zigzag..._at_yahoo.com> 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.
Date: Sun, 20 Dec 2009 07:31:58 -0800 (PST)
Message-ID: <a703112e-cfcc-4879-ab8e-9f0b8b11ee91_at_d10g2000yqh.googlegroups.com>
On Dec 20, 12:39 am, zigzagdna <zigzag..._at_yahoo.com> 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.
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