ora-01115错误

SQL> select * from  am_assets_project_tasks t where source_system_id='1';

select * from  am_assets_project_tasks t where source_system_id='1'

               *

ERROR at line 1:

ORA-01115: IO error reading block from file 11 (block # 395547)

ORA-01110: data file 11: '/export/home/ora10g/eamdev/oradata/eamfj_02.dbf'

ORA-27091: unable to queue I/O

ORA-27072: File I/O error

Additional information: 3

Additional information: 395539

Additional information: 8192

初步定为是硬件问题，因为是非归档模式，不能在线offline 数据文件，停止数据库，移动数据文件去新的磁盘。不料发生错误
cp：eamfj_02.dbf'：无此设备或地址。
运行fsck -y命令进行磁盘检测
报错如下：

** /dev/dsk/c1d0s3

** Currently Mounted on /export/home

** Phase 1 - Check Blocks and Sizes

FRAGMENT 458800 DUP I=130123 LFN 2457696

FRAGMENT 458801 DUP I=130123 LFN 2457697

FRAGMENT 458802 DUP I=130123 LFN 2457698

FRAGMENT 458803 DUP I=130123 LFN 2457699

FRAGMENT 458804 DUP I=130123 LFN 2457700

FRAGMENT 458805 DUP I=130123 LFN 2457701

FRAGMENT 458806 DUP I=130123 LFN 2457702

FRAGMENT 458807 DUP I=130123 LFN 2457703

FRAGMENT 49551616 DUP I=130123 LFN 2457704

FRAGMENT 49551617 DUP I=130123 LFN 2457705

EXCESSIVE DUPLICATE FRAGMENTS I=130123

CONTINUE?  yes

FRAGMENT 1684096000 OUT OF RANGE I=130123 LFN 2457744

FRAGMENT 2037279085 OUT OF RANGE I=130123 LFN 2457752

FRAGMENT 859003251 OUT OF RANGE I=130123 LFN 2457760

FRAGMENT 892482099 OUT OF RANGE I=130123 LFN 2457768

FRAGMENT -1176162256 OUT OF RANGE I=130123 LFN 2457776

FRAGMENT -1079646017 OUT OF RANGE I=130123 LFN 2457784

FRAGMENT -442068247 OUT OF RANGE I=130123 LFN 2457792

FRAGMENT -2115526985 OUT OF RANGE I=130123 LFN 2457800

FRAGMENT -1313741387 OUT OF RANGE I=130123 LFN 2457808

FRAGMENT -441678363 OUT OF RANGE I=130123 LFN 2457816

EXCESSIVE BAD FRAGMENTS I=130123

CONTINUE?  yes

INCORRECT DISK BLOCK COUNT I=130123 (6331776 should be 4918048)

CORRECT?  yes

FRAGMENT 402669568 DUP I=203847 LFN 3243352

FRAGMENT 402669569 DUP I=203847 LFN 3243353

FRAGMENT 402669570 DUP I=203847 LFN 3243354

FRAGMENT 402669571 DUP I=203847 LFN 3243355

FRAGMENT 402669572 DUP I=203847 LFN 3243356

FRAGMENT 402669573 DUP I=203847 LFN 3243357

FRAGMENT 402669574 DUP I=203847 LFN 3243358

FRAGMENT 402669575 DUP I=203847 LFN 3243359

CANNOT READ: DISK BLOCK 990233872: No such device or address

CONTINUE?  yes

THE FOLLOWING SECTORS COULD NOT BE READ: 990233872 990233873 990233874 990233875 990233876 990233877 990233878 990233879 990233880 990233881 990233882 990233883 990233884 990233885 990233886 990233887

INCORRECT DISK BLOCK COUNT I=58665172 (560 should be 208)

CORRECT?  yes

CANNOT READ: DISK BLOCK 990219568: No such device or address

CONTINUE?  yes

THE FOLLOWING SECTORS COULD NOT BE READ: 990219664 990219672 990219673 990219674 990219675 990219676 990219677 990219678 990219679

CANNOT READ: DISK BLOCK 990219680: No such device or address

CONTINUE?  yes

初步定为为磁盘坏道导致了数据块损坏。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21416913/viewspace-742181/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21416913/viewspace-742181/