配置完DG后查看log_archive_dest_n状态:
select dest_name,status,error from v$archive_dest
DEST_NAME STATUS ERROR
-------------------- --------- ------------------------------
LOG_ARCHIVE_DEST_1 VALID
LOG_ARCHIVE_DEST_2 ERROR ORA-16047: DGID mismatch
between destination setting
and target database
查看解释:
16047, 00000, "DGID mismatch between destination setting and target database"
// *Cause: The DB_UNIQUE_NAME specified for the destination did not match
// the DB_UNIQUE_NAME at the target database.
// *Action: Make sure the DB_UNIQUE_NAME specified in the LOG_ARCHIVE_DEST_n
// parameter matches the DB_UNIQUE_NAME parameter defined at the
// destination.
我的DB_UNIQUE_NAME配置都没有问题。之后挨个check参数,结果杯具了,备库上的log_archive_config参数standby前多了个空格,顿时内流满面。
SQL> show parameter log_archive_config
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string DG_CONFIG=(primary, s
tandby)
SQL>
SQL> alter system set log_archive_config='DG_CONFIG=(primary,standby)' scope=both;
System altered.
SQL>
修改参数后一切正常。
select dest_name,status,error from v$archive_dest
DEST_NAME STATUS ERROR
-------------------- --------- ------------------------------
LOG_ARCHIVE_DEST_1 VALID
LOG_ARCHIVE_DEST_2 ERROR ORA-16047: DGID mismatch
between destination setting
and target database
查看解释:
16047, 00000, "DGID mismatch between destination setting and target database"
// *Cause: The DB_UNIQUE_NAME specified for the destination did not match
// the DB_UNIQUE_NAME at the target database.
// *Action: Make sure the DB_UNIQUE_NAME specified in the LOG_ARCHIVE_DEST_n
// parameter matches the DB_UNIQUE_NAME parameter defined at the
// destination.
我的DB_UNIQUE_NAME配置都没有问题。之后挨个check参数,结果杯具了,备库上的log_archive_config参数standby前多了个空格,顿时内流满面。
SQL> show parameter log_archive_config
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string DG_CONFIG=(primary, s
tandby)
SQL>
SQL> alter system set log_archive_config='DG_CONFIG=(primary,standby)' scope=both;
System altered.
SQL>
修改参数后一切正常。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7734298/viewspace-714410/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7734298/viewspace-714410/