Re: archivelog mode

In article 8fm_at_netserver.univ-lille1.fr, noel_at_omega.univ-lille1.fr (Yves Noel) writes:
-->
-->Hi all DBAs !
-->
-->A little question before passing my database in ARCHIVELOG mode (I'ven't find a
-->clear explication in the doc) about the LOG_ARCHIVE_DEST file.
-->How does this file grow ? Indefinitely ? Or can I give it limits ?
-->Thanks in advance for responses. I use ORACLE v6.0.36 on DEC RISC ULTRIX.

When your archive log file grows to be as large as the paramater log_allocation it will create a new archive log file. The limit is specified by the log_allocation parameter

Here's an example from one of our init.ora's

log_archive_start = TRUE
log_archive_dest = /export/data29/archUK_MSTR/raUK_MSTR
log_allocation = 100000
log_checkpoint_interval = 100000

This will create archive log files called /export/data29/archUK_MSTR/raUK_MSTR/raUK_MSTR_XXX where XXX is an integer.

Each time the file gets to be 'log_allocation' big it will create a new file with an increment of 1 to the filename.

You can check the current and next numbers by issusing the command ARCHIVE LOG LIST in SQLDBA.

Hope this helps.

---
------------------------------------------------------------------------------
David Crowson   =%^)   |"For my part, I travel not to go anywhere, but to go. 
Oracle DBA(Ver.4,5,6,7)| I travel for travel's sake. The great affair is to
Amoco Exploration      | move, to get down off this featherbed of civilisation
Ealing, London, UK.    | and to find the globe granite underneath and strewn
"My views not Amoex's" | with cutting flints" : Robert Louis Stevenson