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