Re: archival mode

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 4 Oct 2001 19:19:01 +0200
Message-ID: <trp73gcva7ju37@news.demon.nl>

"Knut Talman" <knut.talman_at_mytoys.de> wrote in message news:3BBC792E.C5BF4D67_at_mytoys.de...
> > AFAIK no, since you need to mount the database in exclusive mode to
> > issue "ALTER DATABASE archivelog".
> >
> > Beware: Altering the database is not enough in Oracle. You need to set
> > the instance parameter (init.ora) log_archive_start=true. This requires
> > a complete shutdown of the instance in 7.3.4.
>
> But you can stop archiving and restart it later w/o shuting down the db.
>
> svrmgrl> archive log stop
>
> or
>
> svrmgrl> archive log start
>
> Regards,
>
> Knut
>
> --
> Knut Talman Fon +49 30 72 62 01 411
> dba_at_myToys.de Fax +49 30 72 62 01 222
> The degree of normality in a database is inversely
> proportional to that of its DBA

Knut,
The commands you provide only stop *automatic* archiving, they *don't* stop archivelog in itself. For that you need to alter the database to noarchivelog.
Please consult the Oracle Server Administrators Manual to verify this, your response is -sorry to say so- completely incorrect.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 04 2001 - 12:19:01 CDT