February 13, 2007
阵列增加硬盘导致IO错误一例
作者:eygle
出处:http://blog.eygle.com
前几天一个朋友的数据库出了点问题，传来的一段警告日志包含如下错误信息:
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-
Posted by eygle at 10:59 PM | Comments (3)