Arup,
>From your past replies to the list, I am surprised to hear you say this.
"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."
Regards
Raj
"Arup Nanda"
<arupnanda@ho To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
tmail.com> cc:
Sent by: Subject: Re: from Non-Archive-Mode to
Archive-Mode
root@fatcity.
com
January 17,
2003 09:35 AM
Please
respond to
ORACLE-L
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 the
time it takes to fill up a redo log. If you are using archiving, the redo
log has to be written to disk. In any one given day, you can then calculate
the archive log generation.
Then comes how you want to back it up and clean up the space. If you have a
process running that will scan for archive logs; back them to tape and then
delete it, then you have to figure out how often this process runs and how
much archive log stays on the disk before getting deleted.
Changing the log mode of the tablespace level does not change teh redo log
genration in most cases. If you define a tablespace or an object as
nologging, only a few operations like ALTER TABLE .. PARTITION, ALTER INDEX
REBUILD, direct load are not logged, all others are. And in any case the
system tables are always logged.
HTH.
Arup
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 5:08 AM
> Hi,
>
> how can I calculate/estimate the extra disk space I'll need if I
> change the log mode from non-archive-mode to archive-mode. I want to
change
> the log mode of all my objects. Do I need to do this one-by-one or is it
> enough if I change the log mode of my tablesapces?
>
> Thanks in advance
>
> Murat
>
>
>
> --------------------------------------
> Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda
ozel
> haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen
mesaji
> geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet
Hizmetleri
> Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic
bir
> hukuksal sorumlulugu kabul etmez.
>
> This e-mail communication is intended for the private use of the
persons
> named above. If you received this message in error, please
immediately
> notify the sender and delete it from your system. Rt.Net
Internet
> Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal
responsibility
> for the contents of this message.
> --------------------------------------
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: MURAT BALKAS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
