在配置 1 对 2 ADG 时遇到以下问题:
log_archive_dest_2 string service=sd_irracdstb ASYNC val
id_for=(ONLINE_LOGFILE,PRIMARY
_ROLE) db_unique_name=irracd
alter system set log_archive_dest_3="service=sd_irracdxpstb ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=irracdxp" scope=both sid="*";
alter system set log_archive_dest_state_3="enable" scope=both sid="*";
SQL> alter system set log_archive_dest_3='service=sd_irracdxpstb ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=irracdxp' scope=both;
alter system set log_archive_dest_3='service=sd_irracdxpstb ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=irracdxp' scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16025: parameter LOG_ARCHIVE_DEST_3 contains repeated or conflicting
attributes
SQL>
SQL>
SQL>
SQL> alter system set log_archive_dest_3='service=sd_irracdxpstb ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=irracdxp' scope=both sid='*';
System altered.
SQL> show parameter dest_3
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/66634/viewspace-1743739/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/66634/viewspace-1743739/