Re: Arch log files sizes
Date: Wed, 12 Nov 2008 15:35:07 -0500
One other thing, regardless of how big your redo logs are, having the archivelog destination fill up is a complete brand newbie error. Okay, it happens, but better not let it happen again, or too often if there are mitigating circumstances like a standby with dog slow connection (and you can even compensate for that).
If you're on 'NIX, script something to check the space used in the archivelog filesystem and have it backup and delete at a specified point and at least send you an email/page when space is getting tight.
If you're on Windows, it's much the same, just a little more difficult (for me anyway, I am not a Windows guy but i wrote .bat files to do it for the DBs I do have on that O/S).
If you're using Grid Control, you can set an alert with a "corrective action."
On Wed, Nov 12, 2008 at 2:18 PM, Tim Gorman <tim_at_evdbt.com> wrote:
> The size of an archived redo log file won't be any larger than your online
> redo log files, but they can be smaller for lots of reasons. One cause is
> issuing the command ALTER SYSTEM SWITCH LOGFILE at random times -- that'll
> generate a bunch of smaller archived redo log files. Instance shutdown will
> essentially have the same effect. If you're running Data Guard, some
> parameter settings (i.e. archive_lag_target > 0) can cause switches to occur
> before the online log files "fill".
> Hope this helps....
> Tim Gorman
> consultant - Evergreen Database Technologies, Inc.
> P.O. Box 630791, Highlands Ranch CO 80163-0791
> website = http://www.EvDBT.com/
> email = Tim_at_EvDBT.com
> mobile = +1-303-885-4526
> fax = +1-303-484-3608
> Yahoo IM = tim_evdbt
> Prabhu, Krishnaswamy wrote:
> We are running 10204 instances, recently the arch log destination got
> filled up 100% and we noticed few arch logs files sizes are varying, the
> sizes are twice larger than the average file size, archive_lag_target is set
> to 0. Can anyone please throw more insight on this.
> Team India gets set to thwart Australia's quest for the final frontier.
> Catch the action on MSN Try it now! <http://sports.in.msn.com/>
> -- http://www.freelists.org/webpage/oracle-l