Re: Oracle shutdown and startup

From: Hermi <hs_at_technologist.com>
Date: Tue, 5 Dec 2000 04:19:59 +0100
Message-ID: <90hmte$3n1$06$1@news.t-online.com>

David Fitzjarrell wrote:

> If you have archivelog mode running and you wish to
> disable it you would need to edit the init<SID>.ora file
> then shutdown and restart the
> instance. The "archive_log = TRUE" line would need to be

sorry, that won't work.

Archive-Log mode is recorded in the control-file. You alter the status of archivelog-mode by typing ALTER DATABASE ARCHIVELOG or
ALTER DATABASE NOARCHIVELOG. In your initSID.ora you switch the automatic archiving on or off with the parameter
LOG_ARCHIVE_START = TRUE | FALSE You can run a database in ARCHIVELOG-mode with LOG_ARCHIVE_:START = FALSE.
Then you have to archive the logs manually or the instance will hang when redo logs are full.

have fun
--= Hermi =-- Received on Mon Dec 04 2000 - 21:19:59 CST