Re: changing archivelog mode in 10g

From: Bradd Piontek <>
Date: Tue, 12 Aug 2008 14:39:15 -0500
Message-ID: <>

Maybe I'm missing something. I thought all 'alter system archive log stop' did was stop the archiver processes. This didn't turn off archiving for the database. That has to be done in MOUNT mode. I believe the reason it isn't used anymore, is that log_archive_start has been deprecated (the archiver processes are automatically stopped/started when needed). My assumption was that they did this since log_archive_start had a tendency of being missed by dba's when enabling archivelog mode.
I could be mistaken.

Bradd Piontek
Oracle Blog: Linked In:

On Tue, Aug 12, 2008 at 12:45 PM, Maureen English <>wrote:

> Why did Oracle decide that stopping archive logging when
> the database was up and available is no longer a desired
> option?
> In 9i, we could do an 'alter system archive log stop;',
> but in 10g, this is not supported.
> It sure would make my life easier right about now....
> - Maureen
> University of Alaska
> --

Received on Tue Aug 12 2008 - 14:39:15 CDT

Original text of this message