Re: archivelog mode

David Crowson (zdxc0d_at_amoco.com) wrote:
: 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
 

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

    I don't believe that log_allocation has anything to do with it. It's merely based upon the size of the current online redo log - when the online redo log fills up, it's archived. Received on Wed Apr 06 1994 - 06:20:52 CEST