ORA-16179 关键字错误导致log_archive_dest_3设置失败

denglj

在配置备库时，设置log_archive_dest_3参数报以下异常

SQL> alter system set log_archive_dest_3=’service= meddocdgbak lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=meddocdgbak’;
alter system set log_archive_dest_3=’service= meddocdgbak lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=meddocdgbak’;
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_3" not allowed with SPFILE

经查询资料，这种情况通常是关键字写错造成.然后仔细确认参数，发现service= meddocdgbak在等号后面有一个空格，将此空格删除，在执行语句，异常解除.