Re: 9i: initialize archive-log modus

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Mon, 13 Jan 2003 16:38:36 +0100
Message-ID: <3E22DD7C.5070904@science-computing.de>

anja weiss wrote:
> On my oracle 9i-System I want to initialize the automatic archive log
> modus. Unfortunately there is no init<sid>.ora. The database-instance
> is mounted by the spfile. Has anyone an idea how i can initialize the
> automatic archive-log modus without editing the init<sid>.ora?
>
> Thanks a lot!
> Anja

sqlplus '/ as sysdba' -- replace ' with " if on windows

alter system set <parameter>=<value> scope=spfile;

If you're unsure about which parameter to set: show parameter archive

Best regards,

Holger Received on Mon Jan 13 2003 - 09:38:36 CST