ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 搭建Dataguard时遭遇ORA-16047

搭建Dataguard时遭遇ORA-16047

原创 Linux操作系统 作者:lsq_008 时间:2010-09-13 20:39:32 0 删除 编辑

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博客 ” ,链接:https://blog.itpub.net/10972173/viewspace-673781/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 模拟数据块损坏
请登录后发表评论 登录
全部评论
十余年大型金融及电信系统数据库管理经验,曾服务于中国建设银行、中国移动。对oracle,mysql数据库有深入了解。 擅长python开发,独立开发了开源数据库自动化监控运维平台Power Monitor。

注册时间:2008-02-29

  • 博文量
    335
  • 访问量
    1369148