代码改变世界

ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

2015-07-09 13:06  abce  阅读(1269)  评论(0)    收藏  举报 
SQL> alter system set log_archive_dest_1='E:\arch ' scope=both;
alter system set log_archive_dest_1='E:\arch ' scope=both
*
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=E:\arch ' scope=spfile;