Re: Missing archived logs in v$archived_log
Date: Sun, 20 Dec 2009 07:24:22 +0000 (UTC)
Message-ID: <hgkjf6$8g0$2_at_news.eternal-september.org>
On Sat, 19 Dec 2009 21:39:04 -0800, zigzagdna 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.
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.
-- http://mgogala.byethost5.comReceived on Sun Dec 20 2009 - 01:24:22 CST