-
LOG_ARCHIVE_START in oracle 9i
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
Nwcomer
Student
-
-
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
Nwcomer
Student
-
Re: LOG_ARCHIVE_START in oracle 9i
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.
-
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|