« 旧书以及新书 新年以及旧年 | Blog首页 | 新年 新婚 »
阵列增加硬盘导致IO错误一例
作者：eygle |【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】链接：http://www.eygle.com/archives/2007/02/diskio_fault_case.html
前几天一个朋友的数据库出了点问题，传来的一段警告日志包含如下错误信息:
ORA-01114: IO error writing block to file 15 (block # 1)
ORA-27041: unable to open file
Linux Error: 30: Read-only file system
Additional information: 3
Thu Feb 8 15:57:58 2007
Errors in file /oracle/admin/ccdb/udump/ccdb_ora_30307.trc:
ORA-01110: data file 14: '/data/system05.dbf'
ORA-01114: IO error writing block to file 14 (block # 1)
ORA-27041: unable to open file
Linux Error: 30: Read-only file system
Additional information: 3
Thu Feb 8 15:57:58 2007
Errors in file /oracle/admin/ccdb/udump/ccdb_ora_30307.trc:
ORA-01110: data file 13: '/data/system04.dbf'
ORA-01114: IO error writing block to file 13 (block # 1)
ORA-27041: unable to open file
Linux Error: 30: Read-only file system
Additional information: 3
....
Thu Feb 8 15:57:58 2007
Errors in file /oracle/admin/ccdb/bdump/ccdb_dbw0_30282.trc:
ORA-01186: file 11 failed verification tests
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: '/data/system02.dbf'
ORA-01208: data file is an old version - not accessing current version
Thu Feb 8 15:57:58 2007
File 11 not verified due to error ORA-01122
Thu Feb 8 15:57:58 2007
ORA-1221 signalled during: ALTER DATABASE OPEN...
一系列的错误提示都表明IO出了问题，经过询问得知，用户正在更换硬盘IBM的盘阵，刚刚插入了5块硬盘，结果发现数据库出现了问题，关闭之后就无法启动。
让用户把刚加入的硬盘拔掉，reboot一下盘阵，数据库恢复了正常。
不清楚是IBM什么型号的盘阵，加硬盘导致故障还是第一次遇到，记录一下.
-The End-
By eygle on 2007-02-13 22:59 | Comments (3) | Posted to Case | Edit |Pageviews:
网上相关主题:
留言 (3)
这个问题甚是奇怪的说
应该来说,塞几个硬盘进去,不会有问题的了
无非是系统认不到硬盘
不过看os,似乎是scsi的阵列.呵呵
Posted by: David.Guo at February 14, 2007 8:52 AM
是IBM的低端ScSI阵列。
Posted by: eygle at February 14, 2007 9:13 AM
居然让俺猜到了,哈哈.
exp300还是exp400哟
如果是低端,应该不会是700吧
Posted by: David.Guo at February 14, 2007 11:02 AM
