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

阵列增加硬盘导致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 |

3 Comments

这个问题甚是奇怪的说

应该来说,塞几个硬盘进去,不会有问题的了

无非是系统认不到硬盘

不过看os,似乎是scsi的阵列.呵呵

居然让俺猜到了,哈哈.

exp300还是exp400哟

如果是低端,应该不会是700吧