Re: archive logs grow too fast

I think the way I would tackle it would be to look in your alert log file and get the average amount of time it takes to fill up a redo log file (check the times where it states 'Thread advanced to log sequence ####'). Say the average is 10 minutes. Next, I would determine the redo log file size (obvious), we'll say they are 10MB. In this analogy, if you wanted to keep 24 hours worth of archive log files before backups, you would need to keep approx 144 log files on the disk (6 an hour * 24 hours). At 10MB each, that would be approx 1.4GB of space would you need to store your archive logs. You have to remember this is only an approximate amount of space because you're taking an average of the time between redo log switches, always leave a little extra in case your database is busier one day than another.

certainly this is unscientific, but I believe it would work ...

hth
John

Oleg Paraschenko wrote:
> Hello all,
>
> I'm interesting if there are method to calculate disk space required
> for archive logs. High accuracy is not required. I will be grateful
> for any recommendations how to start to investigate what and why I
> have in archive logs.
>
> Regards, Oleg
Received on Thu Feb 27 2003 - 06:52:13 CST