SQL> alter system set log_archive_dest_1='D:\oracle\product\10.2.0\flash_recovery_area\BUT\archivedlog\';
alter system set log_archive_dest_1='D:\oracle\product\10.2.0\flash_recovery_area\BUT\archivedlog\'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

SQL> alter system set log_archive_dest_1='location=D:\oracle\product\10.2.0\flash_recovery_area\BUT\archivedlog\';
System altered.

--转自

Error Id: ORA-16179

Title: incremental changes to "string" not allowed with SPFILE

Description:

incremental changes to "string" not allowed with SPFILE

Action:

Specify either LOCATION or SERVICE plus all other attributes to be set in one ALTER SYSTEM/SESSION SET command.

Cause:

Incremental changes to a log_archive_dest_n parameter cannot be made when using an SPFILE.

Error Id: ORA-32017

Title: failure in updating SPFILE

Description:

failure in updating SPFILE

Action:

See associated errors.

Cause:

A failure occured while updating the SPFILE.

-- 来自：