Oracle 11gR2光钎链路切换crs服务发生crash

最新推荐文章于 2021-05-02 18:23:51 发布
最新推荐文章于 2021-05-02 18:23:51 发布
阅读量243 收藏
点赞数
文章标签： 运维 数据库

Oracle 11gR2光钎链路切换crs服务发生crash

 

背景:

我们将Oracle 11gR2(11.2.0.4)在RedHat EnterPrise 5.8上通过RDAC完成的多路径链路冗余，在部署完成后，我们需要做多路径链路冗余测试，我们的光钎链路连接方式如下。我们做多路径测试完成了如下几个组合：

拔线测试组合一：

1、 先拔下光钎链路 ②和④ 一切正常没有问题；插上五分钟后执行第2步。

2、 再拔下光钎链路 ①和③ 数据库服务正常，crs进程crash无法访问，手工重启crs进程即可。

拔线测试组合二：

1、 先拔下光钎链路 ①和③ 一切正常没有问题；插上五分钟后执行第2步。

2、 再拔下光钎链路 ②和④ 数据库服务正常，crs进程crash无法访问，手工重启crs进程即可。

拔线测试组合三：

1、 先拔下光钎链路 ①和④ 一切正常没有问题；插上五分钟后执行第2步。

2、 再拔下光钎链路 ②和③ 一切正常没有问题；

拔线测试组合四：

1、 先拔下光钎链路 ②和③ 一切正常没有问题；插上五分钟后执行第2步。

2、 再拔下光钎链路 ①和④ 一切正常没有问题；

控制器切换测试组合：

1、 进入存储管理控制台，查看当前磁盘所在控制器为A控，手动全部切换到B，一切正常没有问题。

2、 五分钟之后，再次进入存储管理控制台，将所有磁盘从B控制器切换到A控制器，一切正常没有问题。


 

      问题现象:

      问题发生在第一组和第二组的的测试2上面，问题现象如下:

  1. [grid@db01 ~] $ crs_stat -t -v
  2. CRS-0184: Cannot communicate with the CRS daemon.

  4. [root@db01 ~]# ps -ef|grep ora
  5. oracle 2687 1 0 00:12 ? 00:00:00 ora_pmon_woo
  6. oracle 2689 1 0 00:12 ? 00:00:00 ora_psp0_woo
  7. oracle 2691 1 0 00:12 ? 00:00:00 ora_vktm_woo
  8. oracle 2695 1 0 00:12 ? 00:00:00 ora_gen0_woo
  9. oracle 2697 1 0 00:12 ? 00:00:00 ora_diag_woo
  10. oracle 2699 1 0 00:12 ? 00:00:00 ora_dbrm_woo
  11. oracle 2701 1 0 00:12 ? 00:00:00 ora_dia0_woo
  12. oracle 2703 1 0 00:12 ? 00:00:00 ora_mman_woo
  13. oracle 2705 1 0 00:12 ? 00:00:00 ora_dbw0_woo
  14. oracle 2707 1 0 00:12 ? 00:00:00 ora_lgwr_woo
  15. oracle 2709 1 0 00:12 ? 00:00:01 ora_ckpt_woo
  16. oracle 2711 1 0 00:12 ? 00:00:00 ora_smon_woo
  17. oracle 2713 1 0 00:12 ? 00:00:00 ora_reco_woo
  18. oracle 2715 1 0 00:12 ? 00:00:00 ora_mmon_woo
  19. oracle 2717 1 0 00:12 ? 00:00:00 ora_mmnl_woo
  20. oracle 2719 1 0 00:12 ? 00:00:00 ora_d000_woo
  21. oracle 2721 1 0 00:12 ? 00:00:00 ora_s000_woo
  22. oracle 2728 1 0 00:12 ? 00:00:00 ora_rvwr_woo

  24. SQL> select host_name,instance_name,status from gv$instance;

  26. HOST_NAME INSTANCE_NAME STATUS
  27. ---------- ---------------- ------------
  28. db01 woo OPEN
  29. db02        woo                 OPEN

日志排查:

OS message：

  1. Oct 30 13:48:23 db01 kernel: lpfc 0000:1b:00.0: 1:(0):0203 Devloss timeout on WWPN 20:34:00:80:e5:3f:7b:f0 NPort x0000e4 Data: x0 x7 x0
  2. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:0 Selection Retry count exhausted
  3. Oct 30 13:48:23 db01 kernel: 7 [RAIDarray.mpp]oracledb:0:0 Path Failed
  4. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:0 No new path: fall to failover controller case. vcmnd SN 74635 pdev H8:C0:T0:L0 0x00/0x00/0x00 0x00010000 mpp_status:6
  5. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:0 Failed controller to 1. retry. vcmnd SN 74635 pdev H8:C0:T0:L0 0x00/0x00/0x00 0x00010000 mpp_status:6
  6. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:0 Selection Retry count exhausted
  7. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:0 No new path: fall to failover controller case. vcmnd SN 74625 pdev H8:C0:T0:L0 0x00/0x00/0x00 0x00010000 mpp_status:6
  8. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:0 Failed controller to 1. retry. vcmnd SN 74625 pdev H8:C0:T0:L0 0x00/0x00/0x00 0x00010000 mpp_status:6
  9. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  10. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74645 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  11. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74645 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  12. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  13. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74644 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  14. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74644 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  15. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  16. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74643 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  17. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74643 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  18. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  19. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74642 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  20. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74642 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  21. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  22. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74634 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  23. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74634 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  24. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  25. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74632 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  26. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74632 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  27. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  28. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74631 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  29. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74631 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  30. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  31. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74624 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  32. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74624 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  33. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  34. Oct 30 13:48:23 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74622 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  35. Oct 30 13:48:23 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74622 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  36. Oct 30 13:48:23 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  37. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74621 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  38. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74621 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  39. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  40. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74620 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  41. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74620 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  42. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:1 Selection Retry count exhausted
  43. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:1 No new path: fall to failover controller case. vcmnd SN 74619 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  44. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:1 Failed controller to 1. retry. vcmnd SN 74619 pdev H8:C0:T0:L1 0x00/0x00/0x00 0x00010000 mpp_status:6
  45. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:2 Selection Retry count exhausted
  46. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:2 No new path: fall to failover controller case. vcmnd SN 74641 pdev H8:C0:T0:L2 0x00/0x00/0x00 0x00010000 mpp_status:6
  47. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:2 Failed controller to 1. retry. vcmnd SN 74641 pdev H8:C0:T0:L2 0x00/0x00/0x00 0x00010000 mpp_status:6
  48. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:2 Selection Retry count exhausted
  49. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:2 No new path: fall to failover controller case. vcmnd SN 74633 pdev H8:C0:T0:L2 0x00/0x00/0x00 0x00010000 mpp_status:6
  50. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:2 Failed controller to 1. retry. vcmnd SN 74633 pdev H8:C0:T0:L2 0x00/0x00/0x00 0x00010000 mpp_status:6
  51. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:2 Selection Retry count exhausted
  52. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:2 No new path: fall to failover controller case. vcmnd SN 74623 pdev H8:C0:T0:L2 0x00/0x00/0x00 0x00010000 mpp_status:6
  53. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:2 Failed controller to 1. retry. vcmnd SN 74623 pdev H8:C0:T0:L2 0x00/0x00/0x00 0x00010000 mpp_status:6
  54. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:3 Selection Retry count exhausted
  55. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:3 No new path: fall to failover controller case. vcmnd SN 74636 pdev H8:C0:T0:L3 0x00/0x00/0x00 0x00010000 mpp_status:6
  56. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:3 Failed controller to 1. retry. vcmnd SN 74636 pdev H8:C0:T0:L3 0x00/0x00/0x00 0x00010000 mpp_status:6
  57. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:3 Selection Retry count exhausted
  58. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:3 No new path: fall to failover controller case. vcmnd SN 74626 pdev H8:C0:T0:L3 0x00/0x00/0x00 0x00010000 mpp_status:6
  59. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:3 Failed controller to 1. retry. vcmnd SN 74626 pdev H8:C0:T0:L3 0x00/0x00/0x00 0x00010000 mpp_status:6
  60. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:3 Selection Retry count exhausted
  61. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:3 No new path: fall to failover controller case. vcmnd SN 74615 pdev H8:C0:T0:L3 0x00/0x00/0x00 0x00010000 mpp_status:6
  62. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:3 Failed controller to 1. retry. vcmnd SN 74615 pdev H8:C0:T0:L3 0x00/0x00/0x00 0x00010000 mpp_status:6
  63. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:3 Selection Retry count exhausted
  64. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:3 No new path: fall to failover controller case. vcmnd SN 74610 pdev H8:C0:T0:L3 0x00/0x00/0x00 0x00010000 mpp_status:6
  65. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:3 Failed controller to 1. retry. vcmnd SN 74610 pdev H8:C0:T0:L3 0x00/0x00/0x00 0x00010000 mpp_status:6
  66. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:4 Selection Retry count exhausted
  67. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:4 No new path: fall to failover controller case. vcmnd SN 74637 pdev H8:C0:T0:L4 0x00/0x00/0x00 0x00010000 mpp_status:6
  68. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:4 Failed controller to 1. retry. vcmnd SN 74637 pdev H8:C0:T0:L4 0x00/0x00/0x00 0x00010000 mpp_status:6
  69. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:4 Selection Retry count exhausted
  70. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:4 No new path: fall to failover controller case. vcmnd SN 74630 pdev H8:C0:T0:L4 0x00/0x00/0x00 0x00010000 mpp_status:6
  71. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:4 Failed controller to 1. retry. vcmnd SN 74630 pdev H8:C0:T0:L4 0x00/0x00/0x00 0x00010000 mpp_status:6
  72. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:4 Selection Retry count exhausted
  73. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:4 No new path: fall to failover controller case. vcmnd SN 74614 pdev H8:C0:T0:L4 0x00/0x00/0x00 0x00010000 mpp_status:6
  74. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:4 Failed controller to 1. retry. vcmnd SN 74614 pdev H8:C0:T0:L4 0x00/0x00/0x00 0x00010000 mpp_status:6
  75. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:4 Selection Retry count exhausted
  76. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:4 No new path: fall to failover controller case. vcmnd SN 74609 pdev H8:C0:T0:L4 0x00/0x00/0x00 0x00010000 mpp_status:6
  77. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:4 Failed controller to 1. retry. vcmnd SN 74609 pdev H8:C0:T0:L4 0x00/0x00/0x00 0x00010000 mpp_status:6
  78. Oct 30 13:48:24 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:5 Selection Retry count exhausted
  79. Oct 30 13:48:24 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:5 No new path: fall to failover controller case. vcmnd SN 74638 pdev H8:C0:T0:L5 0x00/0x00/0x00 0x00010000 mpp_status:6
  80. Oct 30 13:48:24 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:5 Failed controller to 1. retry. vcmnd SN 74638 pdev H8:C0:T0:L5 0x00/0x00/0x00 0x00010000 mpp_status:6
  81. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:5 Selection Retry count exhausted
  82. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:5 No new path: fall to failover controller case. vcmnd SN 74629 pdev H8:C0:T0:L5 0x00/0x00/0x00 0x00010000 mpp_status:6
  83. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:5 Failed controller to 1. retry. vcmnd SN 74629 pdev H8:C0:T0:L5 0x00/0x00/0x00 0x00010000 mpp_status:6
  84. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:5 Selection Retry count exhausted
  85. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:5 No new path: fall to failover controller case. vcmnd SN 74616 pdev H8:C0:T0:L5 0x00/0x00/0x00 0x00010000 mpp_status:6
  86. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:5 Failed controller to 1. retry. vcmnd SN 74616 pdev H8:C0:T0:L5 0x00/0x00/0x00 0x00010000 mpp_status:6
  87. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:5 Selection Retry count exhausted
  88. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:5 No new path: fall to failover controller case. vcmnd SN 74613 pdev H8:C0:T0:L5 0x00/0x00/0x00 0x00010000 mpp_status:6
  89. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:5 Failed controller to 1. retry. vcmnd SN 74613 pdev H8:C0:T0:L5 0x00/0x00/0x00 0x00010000 mpp_status:6
  90. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:6 Selection Retry count exhausted
  91. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:6 No new path: fall to failover controller case. vcmnd SN 74639 pdev H8:C0:T0:L6 0x00/0x00/0x00 0x00010000 mpp_status:6
  92. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:6 Failed controller to 1. retry. vcmnd SN 74639 pdev H8:C0:T0:L6 0x00/0x00/0x00 0x00010000 mpp_status:6
  93. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:6 Selection Retry count exhausted
  94. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:6 No new path: fall to failover controller case. vcmnd SN 74628 pdev H8:C0:T0:L6 0x00/0x00/0x00 0x00010000 mpp_status:6
  95. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:6 Failed controller to 1. retry. vcmnd SN 74628 pdev H8:C0:T0:L6 0x00/0x00/0x00 0x00010000 mpp_status:6
  96. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:6 Selection Retry count exhausted
  97. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:6 No new path: fall to failover controller case. vcmnd SN 74618 pdev H8:C0:T0:L6 0x00/0x00/0x00 0x00010000 mpp_status:6
  98. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:6 Failed controller to 1. retry. vcmnd SN 74618 pdev H8:C0:T0:L6 0x00/0x00/0x00 0x00010000 mpp_status:6
  99. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:6 Selection Retry count exhausted
  100. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:6 No new path: fall to failover controller case. vcmnd SN 74611 pdev H8:C0:T0:L6 0x00/0x00/0x00 0x00010000 mpp_status:6
  101. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:6 Failed controller to 1. retry. vcmnd SN 74611 pdev H8:C0:T0:L6 0x00/0x00/0x00 0x00010000 mpp_status:6
  102. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:7 Selection Retry count exhausted
  103. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:7 No new path: fall to failover controller case. vcmnd SN 74640 pdev H8:C0:T0:L7 0x00/0x00/0x00 0x00010000 mpp_status:6
  104. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:7 Failed controller to 1. retry. vcmnd SN 74640 pdev H8:C0:T0:L7 0x00/0x00/0x00 0x00010000 mpp_status:6
  105. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:7 Selection Retry count exhausted
  106. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:7 No new path: fall to failover controller case. vcmnd SN 74627 pdev H8:C0:T0:L7 0x00/0x00/0x00 0x00010000 mpp_status:6
  107. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:7 Failed controller to 1. retry. vcmnd SN 74627 pdev H8:C0:T0:L7 0x00/0x00/0x00 0x00010000 mpp_status:6
  108. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:7 Selection Retry count exhausted
  109. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:7 No new path: fall to failover controller case. vcmnd SN 74617 pdev H8:C0:T0:L7 0x00/0x00/0x00 0x00010000 mpp_status:6
  110. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:7 Failed controller to 1. retry. vcmnd SN 74617 pdev H8:C0:T0:L7 0x00/0x00/0x00 0x00010000 mpp_status:6
  111. Oct 30 13:48:25 db01 kernel: 94 [RAIDarray.mpp]oracledb:0:0:7 Selection Retry count exhausted
  112. Oct 30 13:48:25 db01 kernel: 496 [RAIDarray.mpp]oracledb:0:0:7 No new path: fall to failover controller case. vcmnd SN 74612 pdev H8:C0:T0:L7 0x00/0x00/0x00 0x00010000 mpp_status:6
  113. Oct 30 13:48:25 db01 kernel: 497 [RAIDarray.mpp]oracledb:0:0:7 Failed controller to 1. retry. vcmnd SN 74612 pdev H8:C0:T0:L7 0x00/0x00/0x00 0x00010000 mpp_status:6
  114. Oct 30 13:48:25 db01 kernel: 10 [RAIDarray.mpp]oracledb:1 Failover command issued
  115. Oct 30 13:48:25 db01 kernel: 801 [RAIDarray.mpp]Failover succeeded to oracledb:1


ASM alert日志信息:


  1. Th Thu Oct 30 13:47:40 2014
    kjbdomdet send to inst 2
    detach from dom 4, sending detach message to inst 2
    WARNING: Offline for disk OCR_VOTE1 in mode 0x7f failed.
    WARNING: Offline for disk OCR_VOTE2 in mode 0x7f failed.
    WARNING: Offline for disk OCR_VOTE3 in mode 0x7f failed.
    WARNING: Offline for disk OCR_VOTE4 in mode 0x7f failed.
    WARNING: Offline for disk OCR_VOTE5 in mode 0x7f failed.
    Thu Oct 30 13:47:40 2014
    List of instances:
     1 2
    Dirty detach reconfiguration started (new ddet inc 1, cluster inc 4)
     Global Resource Directory partially frozen for dirty detach
    * dirty detach - domain 4 invalid = TRUE 
     17 GCS resources traversed, 0 cancelled
    Dirty Detach Reconfiguration complete
    Thu Oct 30 13:47:40 2014
    WARNING: dirty detached from domain 4
    NOTE: cache dismounted group 4/0x4558828B (OCR_VOT001) 
    SQL> alter diskgroup OCR_VOT001 dismount force /* ASM SERVER:1163428491 */ 
    Thu Oct 30 13:47:40 2014
    NOTE: cache deleting context for group OCR_VOT001 4/0x4558828b
    GMON dismounting group 4 at 19 for pid 28, osid 17335
    NOTE: Disk OCR_VOTE1 in mode 0x7f marked for de-assignment
    NOTE: Disk OCR_VOTE2 in mode 0x7f marked for de-assignment
    NOTE: Disk OCR_VOTE3 in mode 0x7f marked for de-assignment
    NOTE: Disk OCR_VOTE4 in mode 0x7f marked for de-assignment
    NOTE: Disk OCR_VOTE5 in mode 0x7f marked for de-assignment
    NOTE:Waiting for all pending writes to complete before de-registering: grpnum 4
    Thu Oct 30 13:47:58 2014
     Received dirty detach msg from inst 2 for dom 4
    Thu Oct 30 13:47:58 2014
    List of instances:
     1 2
    Dirty detach reconfiguration started (new ddet inc 2, cluster inc 4)
     Global Resource Directory partially frozen for dirty detach
    * dirty detach - domain 4 invalid = TRUE 
     0 GCS resources traversed, 0 cancelled
    freeing rdom 4
    Dirty Detach Reconfiguration complete
    Thu Oct 30 13:48:10 2014
    NOTE:Waiting for all pending writes to complete before de-registering: grpnum 4
    Thu Oct 30 13:48:24 2014
    ASM Health Checker found 1 new failures
    Thu Oct 30 13:48:26 2014
    Errors in file /DBSoft/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_6826.trc:
    ORA-15079: ASM file is closed
    Errors in file /DBSoft/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_6826.trc:
    ORA-15079: ASM file is closed
    Errors in file /DBSoft/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_6826.trc:
    ORA-15079: ASM file is closed
    Errors in file /DBSoft/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_6826.trc:
    ORA-15079: ASM file is closed
    Errors in file /DBSoft/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_6826.trc:
    ORA-15079: ASM file is closed
    WARNING: requested mirror side 1 of virtual extent 0 logical extent 0 offset 6754304 is not allocated; I/O request failed
    WARNING: requested mirror side 2 of virtual extent 0 logical extent 1 offset 6754304 is not allocated; I/O request failed
    WARNING: requested mirror side 3 of virtual extent 0 logical extent 2 offset 6754304 is not allocated; I/O request failed
    Errors in file /DBSoft/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_6826.trc:
    ORA-15079: ASM file is closed
    ORA-15079: ASM file is closed
    ORA-15079: ASM file is closed
    Thu Oct 30 13:48:26 2014
    SQL> alter diskgroup OCR_VOT001 check /* proxy */ 
    Thu Oct 30 13:48:40 2014
    SUCCESS: diskgroup OCR_VOT001 was dismounted
    SUCCESS: alter diskgroup OCR_VOT001 dismount force /* ASM SERVER:1163428491 */
    Thu Oct 30 13:48:40 2014
    ORA-15032: not all alterations performed
    ORA-15001: diskgroup "OCR_VOT001" does not exist or is not mounted
    ERROR: alter diskgroup OCR_VOT001 check /* proxy */
    Thu Oct 30 13:48:40 2014
    NOTE: diskgroup resource ora.OCR_VOT001.dg is offline
    SUCCESS: ASM-initiated MANDATORY DISMOUNT of group OCR_VOT001
    Thu Oct 30 13:48:46 2014
    NOTE: client exited [6814]
    Thu Oct 30 13:48:47 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17643] opening OCR file
    Thu Oct 30 13:48:49 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17656] opening OCR file
    Thu Oct 30 13:48:51 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17673] opening OCR file
    Thu Oct 30 13:48:53 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17720] opening OCR file
    Thu Oct 30 13:48:55 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17740] opening OCR file
    Thu Oct 30 13:49:02 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17760] opening OCR file
    Thu Oct 30 13:49:04 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17773] opening OCR file
    Thu Oct 30 13:49:06 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17790] opening OCR file
    Thu Oct 30 13:49:08 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17812] opening OCR file
    Thu Oct 30 13:49:10 2014
    NOTE: [crsd.bin@db01 (TNS V1-V3) 17826] opening OCR file
    Thu Oct 30 13:49:42 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18043] opening OCR file
    Thu Oct 30 13:49:43 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18087] opening OCR file
    Thu Oct 30 13:49:43 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18221] opening OCR file
    Thu Oct 30 13:49:44 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18274] opening OCR file
    Thu Oct 30 13:49:44 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18292] opening OCR file
    Thu Oct 30 13:49:45 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18416] opening OCR file
    Thu Oct 30 13:49:45 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18434] opening OCR file
    Thu Oct 30 13:49:46 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18536] opening OCR file
    Thu Oct 30 13:49:47 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18641] opening OCR file
    Thu Oct 30 13:49:47 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 18659] opening OCR file
    Thu Oct 30 13:53:36 2014
    WARNING: Waited 15 secs for write IO to PST disk 0 in group 1.
    WARNING: Waited 15 secs for write IO to PST disk 0 in group 1.
    WARNING: Waited 15 secs for write IO to PST disk 0 in group 2.
    WARNING: Waited 15 secs for write IO to PST disk 0 in group 2.
    WARNING: Waited 15 secs for write IO to PST disk 0 in group 3.
    WARNING: Waited 15 secs for write IO to PST disk 0 in group 3.
    Thu Oct 30 13:54:43 2014
    NOTE: [crsctl.bin@db01 (TNS V1-V3) 19810] opening OCR file

CRS 日志:

  1. 2014-10-30 13:48:26.715: [ CRSPE][1174640960]{2:1454:184} RI [ora.OCR_VOT001.dg db02 1] new target state: [OFFLINE] old value: [ONLINE]
  2. 2014-10-30 13:48:26.716: [ CRSOCR][1166235968]{2:1454:184} Multi Write Batch processing...
  3. 2014-10-30 13:48:26.716: [ CRSPE][1174640960]{2:1454:184} RI [ora.OCR_VOT001.dg db02 1] new internal state: [STOPPING] old value: [STABLE]
  4. 2014-10-30 13:48:26.716: [ CRSPE][1174640960]{2:1454:184} Sending message to a**: id = 3284
  5. 2014-10-30 13:48:26.716: [ CRSPE][1174640960]{2:1454:184} CRS-2673: Attempting to stop \

故障处理有两种方法：

多路径切换层面，参考如下:

FailOverQuiescenceTime:

Quiescence Timeout before Failover (Mode Select Page 2C) command. Thetime,in seconds,the array will wait for a quiescence condition to clear for an explicitfailover operation. A typical setting is 20 seconds.

 

FailedPathCheckingInterval:

This parameter defines how long (in seconds) the MPP drivershould wait before initiating a path-validation action.Default value is 60 seconds.

 

Egg：

  1. [root@db01 ~]# cat /etc/mpp.conf
  2. VirtualDiskProductId=VirtualDisk
  3. DebugLevel=0x0
  4. NotReadyWaitTime=270
  5. BusyWaitTime=270
  6. QuiescenceWaitTime=270
  7. InquiryWaitTime=60
  8. MaxLunsPerArray=256
  9. MaxPathsPerController=4
  10. ScanInterval=60
  11. InquiryInterval=1
  12. MaxArrayModules=30
  13. ErrorLevel=3
  14. SelectionTimeoutRetryCount=0
  15. UaRetryCount=10
  16. RetryCount=10
  17. SynchTimeout=170
  18. FailOverQuiescenceTime=20
  19. FailoverTimeout=120
  20. FailBackToCurrentAllowed=1
  21. ControllerIoWaitTime=300
  22. ArrayIoWaitTime=600
  23. DisableLUNRebalance=0
  24. SelectiveTransferMaxTransferAttempts=5
  25. SelectiveTransferMinIOWaitTime=3
  26. IdlePathCheckingInterval=60
  27. RecheckFailedPathWaitTime=30
  28. FailedPathCheckingInterval=60
  29. ArrayFailoverWaitTime=300
  30. PrintSenseBuffer=0
  31. ClassicModeFailover=0
  32. AVTModeFailover=0
  33. LunFailoverDelay=3
  34. LoadBalancePolicy=1
  35. ImmediateVirtLunCreate=0
  36. BusResetTimeout=150
  37. LunScanDelay=2
  38. AllowHBAsgDevs=0
  39. S2ToS3Key=471f51f35ec5426e

ASM检测时间方面：

只需要调整ASM隐含参数 _asm_hbeatiowait的值将其调大些，我这直接调到120了，重新执行五组测试，问题没有再现，故障解决。

（参看隐含参数值得方法参考: archive-1980）

 

Egg：

  1. [root@db01 ~] # su – gird
  2. [grid@db01 ~] $ sqlplus sysasm/oracle
  3. SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 12 22:15:18 2014
  4. Copyright (c) 1982, 2013, Oracle. All rights reserved.

  6. Connected to:
  7. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  8. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  10. SQL> alter system set \










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

转载于:http://blog.itpub.net/20674423/viewspace-1329772/

cufkt46657
关注
oracle数据存储底层恢复,oracle数据文件的一次恢复经历
weixin_33795542的博客
04-04 247
环境介绍：双机操作系统：solaris 10数据库版本：oracle 11g R1 64bit1、半夜接到电话，说数据库报大量错误，起来查看数据库，发现数据库已崩溃，查看alert日志，发现I/O报错：Wed Dec 18 00:36:57 2013KCF: write/open error block=0x98abe online=1file=89 /dev/raw/raw03error=270...
Oracle-在ASM无法正常启动下，修改ASM实例参数
sinat_36757755的博客
08-14 1663
在对ASM实例参数进行配置时，可能会遇到参数修改之后无法正常启动ASM实例的情况，这时候需要我们人为的对参数文件配置进行修正乃至回退，但ASM实例的参数文件通常是存放在ASM磁盘的OCR投票盘里面，在ASM实例没有启动的情况下，是无法正常去读取修改的，这时候就需要我们通过一个临时的参数文件启动ASM实例，再去读取修改参数文件。 本文主要讲述如何通过一个临时的参数文件启动ASM实例并读取修改ASM参数文件。...
ASM _asm_hbeatiowait
小楼一夜听春雨，深巷明朝卖杏花
09-04 4898
最近一个数据库节点的集群宕了，但是数据库正常，节点没有被踢出集群，下面是ASM记录的日志。   WARNING: Waited 391 secs for write IO to PST disk 0 in group 2. WARNING: Waited 391 secs for write IO to PST disk 0 in group 2. Fri Aug 31 09:49:27 ...
oracle数据库asm坏块,虚拟机RAC的ASM磁盘组坏块导致重建DB
weixin_29589063的博客
04-11 394
CRS-0215: Could not start resource 'ora.RAC.RAC1.inst'.检查相关的日志：首先查看了下asm的日志：alert_+ASM1.loged Nov 23 15:14:12 2011Starting Oracle instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0In...
oracle硬盘状态不对,Oracle ASM异常dismount磁盘组
weixin_36260016的博客
04-09 1099
朋友反馈他们单位Oracle RAC中的一个节点异常关闭了，操作环境是IBM小机720,EMC存储，Oracle是11.2.0.4。收集了一些信息给我，查看该节点实例的alert.log文件发现了如下信息:Thu Mar 31 14:29:18 2016NOTE:Waiting for all pending writes to complete before de-registering: gr...
Oracle11GR2 RAC for AIX安装配置
08-04
Oracle 11gR2 RAC (Real Application Clusters) 是一种高可用性和容错性的数据库解决方案，允许在多台服务器之间共享一个数据库实例。在IBM AIX操作系统上配置Oracle RAC，可以确保数据的持续可用性，即使单个服务器...
Linux安装Oracle 11gR2 Grid集群
05-23
### Linux安装Oracle 11gR2 Grid集群详解 #### 一、背景介绍 Oracle 11g Release 2 (11.2) 是Oracle公司发布的一款成熟的关系型数据库管理系统，广泛应用于各种业务环境中。在Linux环境下部署Oracle 11g R2 Grid...
Oracle 11gR2 RAC RHEl6 安装规范和手册
12-07
- **CRS (Cluster Ready Services)**：自 Oracle 11g 第 2 版起，CRS 成为 Oracle Grid Infrastructure 的一部分，负责管理集群资源和服务。 ##### 4. Oracle Database 11gR2 安装 - **软件包准备**：获取 Oracle ...
Oracle 11gR2 RAC 添加节点 案例
最新发布
04-20
Oracle 11gR2 Real Application Clusters (RAC) 是一种高可用性和负载均衡解决方案，它允许多台服务器共享同一个数据库实例，从而提供服务的持续性和性能优化。本案例将详细阐述如何在已有的Oracle 11gR2 RAC环境中...
【故障】RAC ASM磁盘路径故障导致OCR和Voting Disk被Force Dismount
08-13
NULL 博文链接：https://askerain.iteye.com/blog/2295536
linux区分网卡光卡,Linux 系统中的光纤卡问题
weixin_32506761的博客
05-02 599
linux 5 + rac 10.2.0.4磁盘经常非常繁忙,导致经常出现数据库hang的情况,一节点无故重启。简要做如下记录:--get wwwn on Linux OS[root@prod01 host5]# pwd/sys/class/fc_host/host5[root@test01 host5]# ls -ls port_name0 -r--r--r-- 1 root root 4096...
oracle 2703,Oracle11gR2光钎链路切换crs服务发生crash
weixin_30055951的博客
04-11 203
Oracle 11gR2光钎链路切换crs服务发生crash背景:我们将Oracle 11gR2(11.2.0.4)在RedHat EnterPrise 5.8上通过RDAC完成的多路径链路冗余，在部署完成后，我们需要做多路径链路冗余测试，我们的光钎链路连接方式如下。我们做多路径测试完成了如下几个组合：拔线测试组合一：1、 先拔下光钎链路 ②和④ 一切正常没有问题；插上五分钟后执行第2步。2、 再...
linux光纤网卡设置方法,Linux 系统中的光纤卡问题
weixin_42415498的博客
05-01 1854
linux 5 + rac 10.2.0.4磁盘经常非常繁忙,导致经常出现数据库hang的情况,一节点无故重启。简要做如下记录:--get wwwn on Linux OS[root@prod01 host5]# pwd/sys/class/fc_host/host5[root@test01 host5]# ls -ls port_name0 -r--r--r-- 1 root root 4096...
ORACLE RAC 11.2.0.4 for RHEL6.8 集群CRS异常导致集群命令无法使用
www_xue_xi的博客
07-24 8339
经查看集群相关日志可以确定，由于存储磁盘出现IO问题（或光线闪断、或IO延迟），导致集群CRS异常宕机。但是，比较奇怪的是，虽然CSR掉线了，ASM实例 和DB实例却好好的，还可以正常使用。查询oracle support发现一篇文章1581684.1 提到ASM CRS仲裁盘访问超时与隐藏参数_asm_hbeatiowait有关系，而ASM的 隐藏参数_asm_hbeatiowait由于操作系统多路径Multipath配置的polling_interval有关，具体的故障原因是操作系统盘的判断访问超时远大
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent
jade 的专栏
10-21 4756
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent -bash-3.2$ cat /etc/release                    Oracle Solaris 10 8/11 s10s_u10wos_17b SPARC   Copyright (c) 1983, 2011, Or
11.2 RAC自动启动报错诊断（二）
ckawt40802的专栏
06-02 590
一个客户的11.2 RAC for Linux X86-64环境停电后出现了故障，RAC环境无法自动启动。 这一篇描述新的问题。 11.2 RAC自动启动报错诊断：http://yan...
虚拟机RAC的ASM磁盘组坏块导致重建DB
编程开发资料库
11-23 262
2011.11.23虚拟机RAC的ASM磁盘组坏块导致重建DB 刚刚在公司的一台PC机器上用vmware workstation8搭建了一套10gr2的rac环境，用的是裸设备+ASM搭建，在安装成功后，不小心被直接重启了下主机，结果再次启动虚拟机的时候提示到有磁盘损坏，也没有在意。但是在启动RAC的时候出现了问题，一开始的现象是如下几个个资源没办法随着其他资源一起启动： ora.node1....
oracle数据文件的一次恢复经历
weixin_34341229的博客
12-24 205
环境介绍：双机 操作系统：solaris 10 数据库版本：oracle 11g R1 64bit1、半夜接到电话，说数据库报大量错误，起来查看数据库，发现数据库已崩溃，查看alert日志，发现I/O报错：Wed Dec 18 00:36:57 2013 KCF: write/open error block=0x98abe online=1 file=89 /d...
Linux环境下Oracle 11gR2 Grid集群安装步骤
7. 安装Grid Infrastructure：这是Oracle 11gR2集群的基础，包括CRS（Cluster Ready Services）和OCFS2（Oracle Cluster File System 2）。 8. 安装数据库软件：在Grid Infrastructure之上安装数据库实例，配置RAC...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值