Re: archival mode

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 5 Oct 2001 06:29:14 +1000
Message-ID: <3bbcc634@news.iprimus.com.au>

Alter system noarchivelog is not a valid command. Alter database noarchivelog is what you are thinking of, and that can indeed be issued whilst the database is open. However, alter database archivelog (to switch it back into archive mode) can ONLY be issued from the MOUNT state, and it requires a clean shutdown first.

Alter database archivelog or noarchivelog sets a bit in the Control File, so the command effective permanently, until you decide to change your mind. It's not something that is only valid for the lifetime of the Instance.

I suspect you have this somewhat confused with alter system archive log start=TRUE, which switches on ARCH for the purposes of actually taking the archivelog copies. That is for sure an 'Instance only' command, which is why there's an init.ora parameter, log_archive_start, which can be set to TRUE to ensure ARCH is switched on at every bounce.

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"Steven King" <sking_at_dataintensity.com> wrote in message
news:44eb09a6.0110040907.5ce65216_at_posting.google.com...


> thomas.hiller_at_warema.de (Thomas) wrote in message

news:<6e366956.0110032330.32ef4b65_at_posting.google.com>...


> > Hello

> >

> > Is it possible to switch the archival mode on or off without closing the

database ?


> >

> > Oracle Version: 7.3.4

> >

> > regards

> > Thomas

>

> You can do an alter system noarchivelog.  Just remember, an alter

> system command is only in effect for the life of the instance. Also be

> aware if you turn off  achiving and at some point turn it on again,

> make sure you have taken a backup of the database or you will have

> gaps in your archive log sequence numbers (preventing recovery).

Received on Thu Oct 04 2001 - 15:29:14 CDT