Re: initialize archive-log modus

From: Alistair Thomson <thomson_alistair_at_no.spam.yahoo.co.uk>
Date: Mon, 13 Jan 2003 15:22:46 -0000
Message-ID: <avulk8$sq7$1$8300dec7@news.demon.co.uk>

SQL> CREATE PFILE='d:\init.ora' FROM SPFILE;

This will create your pfile with all the parameters from the spfile. Edit the pfile restart your database using this pfile and then recreate the spfile. Then you will have to restart the database again using the spfile.

Alistair

"anja weiss" <anja-weiss_at_web.de> wrote in message news:724db49.0301130651.2643c891_at_posting.google.com...
> 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
Received on Mon Jan 13 2003 - 09:22:46 CST