Re: archival mode

From: Uwe Schneider <uwe_at_richard-schneider.de>
Date: Thu, 04 Oct 2001 15:03:20 +0200
Message-ID: <3BBC5E17.40ECBA6C@richard-schneider.de>

Thomas wrote:
>
> Hello
>
> Is it possible to switch the archival mode on or off without closing the database ?
>
> Oracle Version: 7.3.4
>
> regards
> Thomas

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.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!

Received on Thu Oct 04 2001 - 08:03:20 CDT