Re: changing archivelog mode in 10g
- From: Maureen English <sxmte@xxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 12 Aug 2008 14:46:40 -0800
Maybe it's me who missed something. The 10g SQL Reference shows the alter
system
command to have an archive_log_clause. One option for the syntax of this clause
is 'archive log stop', making the command 'alter system archive log stop'.
The description of the stop clause, however, says:
STOP Clause
In earlier releases, this clause disabled automatic archiving of redo log file
groups for
the thread assigned to your instance. This clause has been deprecated. It has
no effect,
and if you specify it, Oracle Database writes a message to the alert log.
Doesn't that mean the same thing as turning off archiving - or is that word
'automatic'
what's got me confused?
We never did this with a 9i database, but a user was loading so much data into
one of our
10g databases today that we kept running out of space for archive logs. It
would have been
nice to be able to turn off archive logging without shutting down the database.
- Maureen
Bradd Piontek wrote:
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: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd
On Tue, Aug 12, 2008 at 12:45 PM, Maureen English
<sxmte@xxxxxxxxxxxxxxxx <mailto:sxmte@xxxxxxxxxxxxxxxx>> 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
