Re: archivelog mode

From: David Crowson <zdxc0d_at_amoco.com>
Date: Tue, 5 Apr 1994 10:44:20 CDT
Message-ID: <1994Apr5.104420.9756_at_amoco.com>


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
Received on Tue Apr 05 1994 - 17:44:20 CEST

Original text of this message