Re: incremental changes to "log_archive_dest_1" not allowed with SPFILE

albanialbert_at_yahoo.de (Albert Albani) wrote in message news:<7c2ca73a.0407200834.1913800_at_posting.google.com>...
> Hello
>
> I am trying to alter the log_archive_dest_1 parameter in a spfile:
>
> SQL> alter system set log_archive_dest_1='c:\oracle\priamarydb\arch'
> scope=spfile;
>
> However, Oracle (9iR2) thinks that it is not possible:
> alter system set log_archive_dest_1='c:\oracle\priamarydb\arch'
> scope=spfile
> *
> ERROR at line 1:
> ORA-32017: failure in updating SPFILE
> ORA-16179: incremental changes to "log_archive_dest_1" not allowed
> with SPFILE
>
>
>
> I am stuck figuring out a) what an incremental change is, and b) if
> there is a workaround and c) if this is the expected behaviour or if
> this is some serious problem.
>
> Albert

It probably means you don't have enough information for the alter. Try:

alter system set log_archive_dest_1='c:\oracle\priamarydb\arch mandatory'
scope=spfile

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch192.htm#REFRN10086

I would recommend learning to use the documentation facilities {note curly braces in the documentation conventions} and metalink.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=437889.999

jg

--
@home.com is bogus.
Gimme money, mister! 
http://www.microsoft.com/presspass/press/2004/jul04/07-20boardPR.asp