ORA-16179: incremental&nbsp…

 

Cause:没加 location=

 

SQL> alter system setlog_archive_dest_1='/u01/archivelog';
alter system set log_archive_dest_1='/u01/archivelog'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowedwith SPFILE

SQL>
SQL>  alter system setlog_archive_dest_1='location=/u01/archivelog';

System altered.

SQL>