修改log_archive_dest_1参数时出错
SQL> alter system set log_archive_dest_1='/u01/app/oracle/fra'; *alter system set log_archive_dest_1='/u01/app/oracle/fra' * ERROR at line 1: ORA-32017: failure in updating SPFILE ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
第 1 行出现错误:
ORA-32017: 更新 SPFILE 时失败
ORA-16179: 不允许使用 SPFILE 对 “log_archive_dest_1” 进行增量更改
[oracle@localhost bin]$ oerr ora 16179 16179, 00000, "incremental changes to \"%s\" not allowed with SPFILE" // *Cause: Incremental changes to a log_archive_dest_n parameter cannot // be made when using an SPFILE. // *Action: Specify either LOCATION or SERVICE plus all other attributes // to be set in one ALTER SYSTEM/SESSION SET command.
更改为：
alter system set log_archive_dest_1=‘location=e:\oracle11g\archivelog’;
