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>...
>
> 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.

Hi, Albert,

The error description for ORA-16179 is confusing, but its suggested action is clear. When you move from the old log_archive_dest to the "new" log_archive_dest_<n>, a common mistake is missing the required string "location=" or "service=". So you need to say

log_archive_dest_1='location=c:\oracle\priamarydb\arch'

Make sure you have no spaces inside the quoted string.

Yong Huang Received on Thu Jul 22 2004 - 08:42:53 CDT