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

时间:2022-04-20 15:07:15
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 :
ORA-: failure in updating SPFILE
ORA-: incremental changes to "log_archive_dest_1" not allowed with SPFILE

更改为:

SQL> alter system set log_archive_dest_1='location=E:\arch ' scope=spfile;