« 旧书以及新书 新年以及旧年 | Blog首页 | 新年 新婚 »

阵列增加硬盘导致IO错误一例

前几天一个朋友的数据库出了点问题，传来的一段警告日志包含如下错误信息:

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) | Case | 1357 |

CaseDiskIBM