incremental changes to "log_archive_dest_1" not allowed with SPFILE

From: Albert Albani <albanialbert_at_yahoo.de>
Date: 20 Jul 2004 09:34:54 -0700
Message-ID: <7c2ca73a.0407200834.1913800@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 Received on Tue Jul 20 2004 - 11:34:54 CDT