Re: too many archive logs

From: Matthias Hoys <>
Date: Wed, 18 Mar 2009 20:08:59 +0100
Message-ID: <49c1463a$0$2860$>

"mike" <> wrote in message
> I'm running on solaris 10 (sparc 64).
> I'm in archivelog mode with 3 groups of redo logs sized at 200M (at
> 100M I was getting checkpoint can't complete messages). I've got
> archive_lag_target set to 900. Watching the alert log all seems to be
> fine. However, when I go to /flash_recovery_area/SID/archivelog, there
> are thousands of archive files, mostly between 10 and 20 MB. For
> example, at 6:49 I see six 11MB archives. Some days there are ~ 6000
> archive logs. Interestingly, they seem to get progressively smaller.
> At midnight the archive logs are over a 100M, by 7am they are down to
> 11M with occasional outliers.
> This seems to be impacting my backups, which are taking 20 hours when
> I'd expect them to take less than 2.
> Thanks in advance.

Do you have scheduled jobs or other processes which have "alter system switch logfile" in their application code ?

Matthias Received on Wed Mar 18 2009 - 14:08:59 CDT

Original text of this message