Re: Missing archived logs in v$archived_log

From: Mladen Gogala <>
Date: Sun, 20 Dec 2009 07:24:22 +0000 (UTC)
Message-ID: <hgkjf6$8g0$>

On Sat, 19 Dec 2009 21:39:04 -0800, 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.

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.

Received on Sun Dec 20 2009 - 01:24:22 CST

Original text of this message