SQL> alter system set log_archive_dest_1='/oracle/backup/arch' scope=spfile;
alter system set log_archive_dest_1='/oracle/backup/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,经常忘记这个locaton而出现错误,一时还想不起来,先记在这。
SQL> alter system set log_archive_dest_1='location=/oracle/backup/arch' scope=spfile;
System altered.
SQL>