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

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

27

积分

0

好友

0

主题
1#
发表于 2012-3-13 16:17:01 | 查看: 9378| 回复: 2
linux_64bit raid0(2个1T的磁盘组成)启动时报PCI: Not using MMCONFIG ?不知有人知道这是什么原因吗?
  1. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  2. ata4.00: configured for PIO0
  3. ata4: EH complete
  4. ata4.00: exception Emask 0x0 SAct 0x0 SErr 0x400001 action 0x6 frozen
  5. ata4.00: irq_stat 0x40000001
  6. ata4: SError: { RecovData Handshk }
  7. ata4.00: cmd a0/00:00:00:08:00/00:00:00:00:00/a0 tag 0 pio 8 in
  8.          cdb 25 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00
  9.          res 51/60:03:00:00:00/00:00:00:00:00/a0 Emask 0x1 (device error)
  10. ata4.00: status: { DRDY ERR }
  11. ata4: hard resetting link
  12. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  13. ata4.00: configured for PIO0
  14. ata4: exception Emask 0x10 SAct 0x0 SErr 0x400001 action 0x1 t4
  15. ata4: irq_stat 0x0c000000, interface fatal error
  16. ata4: SError: { RecovData Handshk }
  17. ata4.00: configured for PIO0
  18. ata4: EH complete
  19. ata4.00: exception Emask 0x0 SAct 0x0 SErr 0x400001 action 0x6 frozen
  20. ata4.00: irq_stat 0x40000001
  21. ata4: SError: { RecovData Handshk }
  22. ata4.00: cmd a0/00:00:00:08:00/00:00:00:00:00/a0 tag 0 pio 8 in
  23.          cdb 25 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00
  24.          res 51/40:03:00:00:00/00:00:00:00:00/a0 Emask 0x1 (device error)
  25. ata4.00: status: { DRDY ERR }
  26. ata4: hard resetting link
  27. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  28. ata4.00: configured for PIO0
  29. ata4: exception Emask 0x10 SAct 0x0 SErr 0x400001 action 0x1 t4
  30. ata4: irq_stat 0x0c000000, interface fatal error
  31. ata4: SError: { RecovData Handshk }
  32. ata4.00: configured for PIO0
  33. ata4: EH complete
  34. ata4.00: exception Emask 0x10 SAct 0x0 SErr 0x400101 action 0x6 frozen
  35. ata4.00: irq_stat 0x0c000000, interface fatal error
  36. ata4: SError: { RecovData UnrecovData Handshk }
  37. ata4.00: cmd a0/00:00:00:08:00/00:00:00:00:00/a0 tag 0 pio 8 in
  38.          cdb 25 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00
  39.          res 50/00:01:00:00:00/00:00:00:00:00/a0 Emask 0x10 (ATA bus error)
  40. ata4.00: status: { DRDY }
  41. ata4: hard resetting link
  42. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  43. ata4.00: configured for PIO0
  44. ata4: EH complete
  45. ata4.00: exception Emask 0x10 SAct 0x0 SErr 0x400101 action 0x6 frozen
  46. ata4.00: irq_stat 0x0c000000, interface fatal error
  47. ata4: SError: { RecovData UnrecovData Handshk }
  48. ata4.00: cmd a0/00:00:00:08:00/00:00:00:00:00/a0 tag 0 pio 8 in
  49.          cdb 25 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00
  50.          res 50/00:01:00:00:00/00:00:00:00:00/a0 Emask 0x10 (ATA bus error)
  51. ata4.00: status: { DRDY }
  52. ata4: hard resetting link
  53. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  54. ata4.00: configured for PIO0
  55. ata4: EH complete
  56. ata4.00: exception Emask 0x10 SAct 0x0 SErr 0x400101 action 0x6 frozen
  57. ata4.00: irq_stat 0x0c000000, interface fatal error
  58. ata4: SError: { RecovData UnrecovData Handshk }
  59. ata4.00: cmd a0/00:00:00:08:00/00:00:00:00:00/a0 tag 0 pio 8 in
  60.          cdb 25 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00
  61.          res 50/00:01:00:00:00/00:00:00:00:00/a0 Emask 0x10 (ATA bus error)
  62. ata4.00: status: { DRDY }
  63. ata4: hard resetting link
  64. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  65. ata4.00: configured for PIO0
  66. ata4: EH complete
  67. ata4.00: exception Emask 0x0 SAct 0x0 SErr 0x400001 action 0x6 frozen
  68. ata4.00: irq_stat 0x44000001
  69. ata4: SError: { RecovData Handshk }
  70. ata4.00: cmd a0/00:00:00:08:00/00:00:00:00:00/a0 tag 0 pio 8 in
  71.          cdb 25 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00
  72.          res 51/40:03:00:00:00/00:00:00:00:00/a0 Emask 0x1 (device error)
  73. ata4.00: status: { DRDY ERR }
  74. ata4: hard resetting link
  75. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  76. ata4.00: configured for PIO0
  77. ata4: exception Emask 0x10 SAct 0x0 SErr 0x0 action 0x1 t4
  78. ata4: irq_stat 0x08000000, interface fatal error
  79. ata4.00: configured for PIO0
  80. ata4: EH complete
  81. sr0: CDROM (ioctl) error, command: <6>Test Unit Ready 00 00 00 00 00 00
  82. sr: Current: sense key: Hardware Error
  83.     Add. Sense: Logical unit communication CRC error (Ultra-DMA/32)
  84. ata4.00: exception Emask 0x10 SAct 0x0 SErr 0x400101 action 0x6 frozen
  85. ata4.00: irq_stat 0x0c000000, interface fatal error
  86. ata4: SError: { RecovData UnrecovData Handshk }
  87. ata4.00: cmd a0/00:00:00:00:00/00:00:00:00:00/a0 tag 0
  88.          cdb 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00
  89.          res 50/00:03:00:00:00/00:00:00:00:00/a0 Emask 0x10 (ATA bus error)
  90. ata4.00: status: { DRDY }
  91. ata4: hard resetting link
  92. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  93. ata4.00: configured for PIO0
  94. ata4: EH complete
  95. ata4.00: exception Emask 0x10 SAct 0x0 SErr 0x400101 action 0x6 frozen
  96. ata4.00: irq_stat 0x08000000, interface fatal error
  97. ata4: SError: { RecovData UnrecovData Handshk }
  98. ata4.00: cmd a0/00:00:00:00:00/00:00:00:00:00/a0 tag 0
  99.          cdb 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00
  100.          res 50/00:01:00:00:00/00:00:00:00:00/a0 Emask 0x10 (ATA bus error)
  101. ata4.00: status: { DRDY }
  102. ata4: hard resetting link
  103. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  104. ata4.00: failed to set xfermode (err_mask=0x100)
  105. ata4: failed to recover some devices, retrying in 5 secs
  106. ata4: hard resetting link
  107. ata4: SATA link up 1.5 Gbps (SStatus 113 SControl 310)
  108. ata4.00: configured for PIO0
  109. ata4: exception Emask 0x10 SAct 0x0 SErr 0x400001 action 0x1 t4
  110. ata4: irq_stat 0x08000000, interface fatal error
  111. ata4: SError: { RecovData Handshk }
  112. ata4.00: configured for PIO0
  113. ata4: EH complete
  114. ata4.00: exception Emask 0x10 SAct 0x0 SErr 0x400101 action 0x6 frozen
  115. ata4.00: irq_stat 0x0c000000, interface fatal error
  116. ata4: SError: { RecovData UnrecovData Handshk }
  117. ata4.00: cmd a0/00:00:00:00:00/00:00:00:00:00/a0 tag 0
  118.          cdb 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00
  119.          res 50/00:01:00:00:00/00:00:00:00:00/a0 Emask 0x10 (ATA bus error)
复制代码
启动会报这个错误,并连接不上数据库,关机把磁盘接口重新插拔一下,再启动可能还会报错,但启动脚本可以正常启动数据库,后在red hat官网查到是一个bug,升级内核后
偶尔还会报ata4: exception Emask 0x10 SAct 0x0 SErr 0x400001 action 0x1 t4
ata4: irq_stat 0x08000000, interface fatal error
ata4: SError: { RecovData Handshk }

[ 本帖最后由 majuthink 于 2012-3-13 22:08 编辑 ]

dmesg.txt

49.56 KB, 下载次数: 1348

2#
发表于 2012-3-13 16:38:16
PCI: Not using MMCONFIG  ==> 这是BIOS 的一个bug ,Linux启动常见,可以忽略该问题

ata4.00: exception Emask 0x0 SAct 0x0 SErr 0x400001 action 0x6 frozen
ata4.00: irq_stat 0x40000001
ata4: SError: { RecovData Handshk }

ODM Finding:

Drive interface issue #3

An example:

   ata2.00: exception Emask 0x10 SAct 0x7ff4f SErr 0x400100 action 0x6 frozen
   ata2.00: irq_stat 0x08000000, interface fatal error
   ata2: SError: { UnrecovData Handshk }

From an expert:

"This is transmission error. Most common causes are power related or
unreliable connection especially if backplanes are involved. Is the
problem still reproducible? If so, can you please try to move it to
different power connector and SATA port and see what changes?"
--
tejun


建议你检查 ata4 对应磁盘设备的 电源和接口 是否正常, 可能的话 换一个接口插槽。

回复 只看该作者 道具 举报

3#
发表于 2012-3-13 22:06:43

谢谢坛主

谢谢坛主的解答,这都是以前测试库所用服务器的问题,今天一并提出来与大家分享。

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-11-15 10:25 , Processed in 0.057568 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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