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)',问题解决