搭建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
环境是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.
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/