10g添加归档目录时报错：ORA-16179

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>