Re: Missing archived logs in v$archived_log

From: ddf <>
Date: Mon, 21 Dec 2009 05:42:54 -0800 (PST)
Message-ID: <>

On Dec 20, 6:24 pm, zigzagdna <> wrote:
> On Dec 20, 10:31 am, bdbafh <> wrote:
> > On Dec 20, 12:39 am, 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.
> > what do you see in the alert log regarding the log sequence# 893 being
> > archived?
> > -bdbafh- Hide quoted text -
> > - Show quoted text -
> I looked in alert.log. I do not see anything which indicates that this
> log was not archived. I do
> see
> ORA-19510: failed to set size of  blocks for file "" (block size=)
> Looking more in this error, it appears that archived logs are getting
> deleted while archive switch is being done.
> I have no clue who is deleting archived logs. My RMAN backup when they
> do archived log backup do
> not delete the archived log. Following configuration parameters for
> Should retain archived logs.
> Yet ARCHIVED LOGS are being depleted by some Oracle process. Clearly
> there is some bug in Oracle Hide quoted text -
> - Show quoted text -

Most likely your backup command. When archivelog deletion policy is set to NONE then all archivelogs are eligible for removal after backup:

"The archived redo log deletion policy is configured to NONE by default. In this case, RMAN considers archived redo log files in the recovery area as eligible for deletion if they meet both of the following conditions:

The archived redo logs, whether in the flash recovery area or outside of it, have been transferred to the required remote destinations specified by LOG_ARCHIVE_DEST_n.

The archived redo logs have been backed up at least once to disk or SBT or the logs are obsolete according to the backup retention policy.

The backup retention policy considers logs obsolete only if the logs are not needed by a guaranteed restore point and the logs are not needed by Oracle Flashback Database. Archived redo logs are needed by Flashback Database if the logs were created later than SYSDATE-'DB_FLASHBACK_RETENTION_TARGET'." You've backed them up, so they're eligible for deletion. I expect your backup command is deleting all input expecting that your nonexistent  deletion policy is 'protecting' them; it isn't. If you do want to keep them around a while you need to actually configure a deletion policy:

CONFIGURE ARCHIVELOG DELETION POLICY BACKED UP 2 TIMES TO SBT for example. Then this first backup would NOT delete the input.

I think the only 'bug' in this situation is you not reading the manual:

David Fitzjarrell Received on Mon Dec 21 2009 - 07:42:54 CST

Original text of this message