ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST

搭建Data Guard时遇到 ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST错误
环境是Oracle 11.2.0.3,错误如下：
SQL> alter system set log_archive_dest_1='location=/u01/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=jyp';
alter system set log_archive_dest_1='location=/u01/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=jyp'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST

从错误信息看，应该是设置了log_archive_dest参数
SQL> show parameter log_archive
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string
log_archive_dest                     string      /u01/oracle/arch
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
更改log_archive_dest后，执行成功
SQL> alter system set log_archive_dest='';
System altered.
SQL> alter system set log_archive_dest_1='location=/u01/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=jyp';
System altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10271187/viewspace-1977754/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10271187/viewspace-1977754/