LOG_ARCHIVE_START in oracle 9i

[newcomer]

Hi,

In oracle 8i I used to set the following parameters before opening my database in archive mode
log_archive_start =
log_archive_dest_1 =
log_archive_format =

Presently I created a database in oracle 9i and the init file that got created automatically, these parameters are missing there.

Then I tried to configure those thru SPFILE , but while trying the same I am getting the following error. How to resove this prob. I would like to set those parameters in my 9i database.

SQL> alter system set log_archive_start=TRUE
scope=BOTH;

alter system set log_archive_start=TRUE
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

Regards

[ggnanaraj]

Check this out...

http://download-west.oracle.com/docs...redo.htm#14904

HTH.

[newcomer]

Hi,

I already tried that

shutdown immediate;
startup mount;
alter database archivelog;
archive log start;
alter database open;

But I would like to make it automatically, like in 8i what I did. So how to update my parameter file?

Regards

[ggnanaraj]

Originally posted by newcomer
SQL> alter system set log_archive_start=TRUE
scope=BOTH;

alter system set log_archive_start=TRUE
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

You cannot modify this parameter dynamically, without bouncing the database.

http://download-west.oracle.com/docs...hredo.htm#4751

HTH.

[abhaysk]

Originally posted by newcomer
Hi,

But I would like to make it automatically, like in 8i what I did. So how to update my parameter file?

Regards

There are some prams which can be modified dynamiclly and in effect without bouncing the DB ( but will be effective until bounce ). but this 1 cant be done.

Abhay.

[mkminda]

use
alter system log_archive_start=true scope=spfile;

it will alter the parameter in spfile dynamically so that it will be true at next startup also
and use
alter system archive log start;
for current instance of the database
its working with oracle 9r2

Good bye