"Arup Nanda"
>
> tmail.com> cc:
> Sent by: Subject: Re: from
Non-Archive-Mode to Archive-Mode
> root@fatcity.
> com
>
&g
tmail.com> cc:
Sent by: Subject: Re: from Non-Archive-Mode to
Archive-Mode
t;[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 1:25 PM
Subject: Re: from Non-Archive-Mode to
Archive-Mode
> > Arup,> > From your past replies to the list,
I am surprised to hear you say t
tmail.com> cc:
Sent by: Subject: Re: from Non-Archive-Mode to
Archive-Mode
Title: RE: from Non-Archive-Mode to Archive-Mode
I personally use the following SQL to
get a very rough estimate of how much
archive space I'm going to need per day.
select (num_logs*bytes )/(1024*1024) "Megs per Day"
from (select ceil(avg(count(*))) num_logs from v
It depends on how much data is changed in the database. If there is no data
manipulation, then you need very little archive space (just enough for the
online logs when you run a backup). Look in the alert log to see how many
log switches occur. I think this will give you a reasonable estimate o
Murat,
The estimate of amount of space for archive logs come from your redo log
switch. If you have placed the init.ora parameter log_checkpoints_to_alert
set to TRUE, then your alert log file will have lines when the redo log
group switch fom one to the other. That will give you a rough idea of t