Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Message from discussion Missing archived logs in v$archived_log

Path: g2news1.google.com!postnews.google.com!j4g2000yqe.googlegroups.com!not-for-mail
From: zigzagdna <zigzag...@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Missing archived logs in v$archived_log
Date: Sat, 19 Dec 2009 21:39:04 -0800 (PST)
Organization: http://groups.google.com
Lines: 19
Message-ID: <df53ea95-e3e0-41d5-8ac4-a1591c89b9bd@j4g2000yqe.googlegroups.com>
NNTP-Posting-Host: 148.177.1.213
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1261287544 18995 127.0.0.1 (20 Dec 2009 05:39:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 20 Dec 2009 05:39:04 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: j4g2000yqe.googlegroups.com; posting-host=148.177.1.213; 
	posting-account=PUA9dQoAAAAWB6fqjaJDJmTx7eb4x-f4
User-Agent: G2/1.0
X-HTTP-Via: 1.1 Application and Content Networking System Software 5.5.11
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
	CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; InfoPath.2; .NET 
	CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET CLR 1.1.4322; MS-RTC LM 
	8),gzip(gfe),gzip(gfe)

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.