问题说明:
今天在做DataGuard搭建练习,当执行如下命令时出现ORA-16179错误:
SQL> alter system set log_archive_dest_1='/oracle/app/fast_recovery_area/RUIADG/archivelog';
alter system set log_archive_dest_1='/oracle/app/fast_recovery_area/RUIADG/archivelog'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
原因说明:
缺少"location="字样
处理方式
修改命令如下:
SQL> alter system set log_archive_dest_1='location=/oracle/app/fast_recovery_area/RUIADG/archivelog';
System altered.