SQL> alter system set log_archive_dest_1='LOCATION= /archivelog';
alter system set log_archive_dest_1='LOCATION= /archivelog'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
SQL> select count(*) from v$session;
COUNT(*)
----------
16
SQL> alter system set log_archive_dest_1='LOCATION=/archivelog';
System altered.
SQL>
本文转自zylhsy 51CTO博客，原文链接：http://blog.51cto.com/yunlongzheng/820094，如需转载请自行联系原作者
