Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

39

积分

0

好友

5

主题
1#
发表于 2012-12-19 16:25:07 | 查看: 4391| 回复: 3
本帖最后由 makaveli 于 2012-12-20 15:14 编辑

现在有套linux 5.8上的11.1.0.7的rac库,已经打到psu7.12,public ip为两块网卡绑定,现在进行故障切换测试,同时拔掉一台机器两根public网卡的网线后,vip没有进行切换,请各位帮忙诊断下是哪里的问题。

1.rar

783.86 KB, 下载次数: 901

节点一日志

2.rar

1.17 MB, 下载次数: 1022

节点二日志

2#
发表于 2012-12-19 17:47:53
问题解决了,谢谢2群的小江帮忙。
参考VIP does not Failover or Network Resource Stays Online after Disconnected Cables for Bond Public Network [ID 1276737.1]文档。通过mii-tool检查正常,参考文档解决 bug 10020138的步骤修改racgvip文件后vip能够正常漂移了。
  1. Another potential solution is fix for bug 10020138 (fixed 11.2.0.3, 12.1). Due to this bug, interface check may not use mii-tool as _LINK_STAT was not reset. The workaround is to locate the following in $ORA_CRS_HOME/bin/racgvip:

  2.        else
  3.          logx "checkIf: ethtool checked if=$_IF failed"
  4.        fi

  5. And change it to:

  6.        else
  7.          logx "checkIf: ethtool checked if=$_IF failed"
  8.          _LINK_STAT=
  9.        fi
复制代码

回复 只看该作者 道具 举报

3#
发表于 2012-12-20 14:52:46
就你的日志看 似乎有一次failover啊,14:58 12-19

  1. 2012-12-18 14:36:32.587: [  CRSRES][1509714240] Start of `ora.nsbxdb2.vip` on member `nsbxdb1` succeeded.
  2. 2012-12-18 14:38:05.116: [  OCRUTL][1295698240]u_freem: mem passed is null
  3. 2012-12-18 14:38:06.572: [    CRSD][1497106752] SM: rE2Ec: 4
  4. 2012-12-18 14:38:06.573: [  CRSRES][1536997696] StopResource: setting CLI values
  5. 2012-12-18 14:38:06.955: [    CRSD][1536997696] SM:dE2Ec: all E2E cmds done. 0
  6. 2012-12-19 14:58:27.154: [ CRSCOMM][1532795200] CLEANUP: Searching for connections to failed node nsbxdb2
  7. 2012-12-19 14:58:27.154: [  CRSEVT][1532795200] Processing member leave for nsbxdb2, incarnation: 250787480
  8. 2012-12-19 14:58:27.155: [    CRSD][1532795200] SM: recovery in process: 8
  9. 2012-12-19 14:58:27.155: [  CRSEVT][1532795200] Do failover for: nsbxdb2
  10. 2012-12-19 14:58:27.232: [  OCRSRV][1532795200]s_update_remote_cache_int: FAILED TO RCV ACK FROM node 2 retcode 7
  11. 2012-12-19 14:58:27.292: [  CRSRES][1532795200]  startup = 0
  12. 2012-12-19 14:58:27.301: [  CRSRES][1532795200]  startup = 0
  13. 2012-12-19 14:58:27.307: [  CRSRES][1532795200]  startup = 0
  14. 2012-12-19 14:58:27.314: [  CRSRES][1532795200]  startup = 0
  15. 2012-12-19 14:58:27.320: [  CRSRES][1532795200]  startup = 0
  16. 2012-12-19 14:58:27.327: [  CRSRES][1532795200]  startup = 0
  17. 2012-12-19 14:58:27.369: [  CRSRES][1534896448] startRunnable: setting CLI values
  18. 2012-12-19 14:58:27.373: [  CRSRES][1534896448] Attempting to start `ora.nsbxdb2.vip` on member `nsbxdb1`
  19. 2012-12-19 14:58:30.686: [  CRSRES][1534896448] Start of `ora.nsbxdb2.vip` on member `nsbxdb1` succeeded.
  20. 2012-12-19 14:58:30.700: [  CRSEVT][1532795200] Post recovery done evmd event for: nsbxdb2
  21. 2012-12-19 14:58:30.700: [    CRSD][1532795200] SM: recoveryDone: 0
  22. 2012-12-19 14:58:30.702: [  CRSEVT][1532795200] Processing RecoveryDone
复制代码
VIP does not Failover or Network Resource Stays Online after Disconnected Cables for Bond Public Network [ID 1276737.1]        To Bottom       
10g/11gR1: VIP does not relocate back to the home node even after the public network problem is resolved [ID 805969.1]        To Bottom       
11gR2 VIP Does not Fail Over After Public Network Issue if Application VIP is ONLINE and Added With "appvipcfg create" [ID 1457380.1]

回复 只看该作者 道具 举报

4#
发表于 2012-12-22 20:58:43
Liu Maclean(刘相兵 发表于 2012-12-20 14:52
就你的日志看 似乎有一次failover啊,14:58 12-19VIP does not Failover or Network Resource Stays Online ...

谢ml提供的文档,这个问题已经解决了。

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 06:34 , Processed in 0.049577 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569