oracle ora 16047,搭建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)',问题解决

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值