搭建Dataguard时遭遇ORA-16047

dg搭建完毕后，日志无法传输到standby端，alert 日志报错：

Errors in file /home/db/oracle/admin/ebank/bdump/ebank_arc1_4537.trc:
ORA-16047: DGID mismatch between destination setting and standby
Mon Sep 13 12:28:12 2010
PING[ARC1]: Heartbeat failed to connect to standby 'standby'. Error is 16047.
Mon Sep 13 12:28:12 2010
Errors in file /home/db/oracle/admin/ebank/bdump/ebank_arc1_4537.trc:
ORA-16047: DGID mismatch between destination setting and standby

trace文件里可见：
*** 2010-09-13 12:28:12.148
Redo shipping client performing standby login
*** 2010-09-13 12:28:12.223 64561 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16047 attaching to destination LOG_ARCHIVE_DEST_3 standby host 'standby'
ORA-16047: DGID mismatch between destination setting and standby
*** 2010-09-13 12:28:12.240 60679 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'standby'. Error is 16047.
*** 2010-09-13 12:28:12.240 58941 kcrr.c
kcrrfail: dest:3 err:16047 force:0 blast:1
Redo shipping client performing standby login
*** 2010-09-13 12:28:12.348 64561 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16047 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'b2cyj'
ORA-16047: DGID mismatch between destination setting and standby
*** 2010-09-13 12:28:12.368 60679 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'b2cyj'. Error is 16047.
*** 2010-09-13 12:28:12.368 58941 kcrr.c
kcrrfail: dest:2 err:16047 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2010-09-13 12:29:12.420
kcrrwkx: nothing to do (end)
*** 2010-09-13 12:30:12.455
kcrrwkx: nothing to do (end)

在网上查了一下，将standby端的初始化参数文件里添加了LOG_ARCHIVE_CONFIG='DG_CONFIG=(ebank,b2cyj,standby)'，问题解决

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

转载于:http://blog.itpub.net/10972173/viewspace-673781/