Re: too many archive logs
Date: Wed, 18 Mar 2009 20:08:59 +0100
Message-ID: <49c1463a$0$2860$ba620e4c_at_news.skynet.be>
"mike" <michael.kidwell_at_hqda.army.mil> wrote in message
news:ba1dad6c-6e22-43e6-890e-d5eb56db377a_at_v39g2000yqm.googlegroups.com...
> I'm running 10.2.0.4 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