SQL> alter system set log_archive_dest_1='/home/oracle/arch' scope=spfile;
alter system set log_archive_dest_1='/home/oracle/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
出错原因:少了LOCATION或SERVICE关键字
解决办法:加上相应关键字即可。
如:
SQL> alter system set log_archive_dest_1='location=/home/oracle/arch' scope=spfile;
System altered.
--本篇文章参考自:http://blog.csdn.net/wyzxg/article/details/4301214