今天遇到错误
ORA-01115: IO error reading block from file 11 (block # 1024771)
ORA-01110: data file 11: '/oradata/ufida/NNC_DATA03_02.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 3
ORA-01110: data file 11: '/oradata/ufida/NNC_DATA03_02.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 3
然后查看日志并没有错误记录，同时找出这个块的所在的表，进行了全表扫描，为发现错误，同时进行了DBV也未发现损坏的块。
然后进入METALINK找到如下文章：
ORA-01115 ORA-01110 ORA-27091 ORA-27072 Error: 5: I/O error [ID 559697.1]修改时间:2011-11-18类型:PROBLEM状态:PUBLISHED优先级:2
注释 (0)
注释 (0)
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:Oracle Server - Enterprise Edition - Version: 9.2.0.8and later [Release: 9.2 and later ]
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 16-Feb-2011***
Symptoms
Changes
Cause
Solution
References
Applies to:Oracle Server - Enterprise Edition - Version: 9.2.0.8and later [Release: 9.2 and later ]
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 16-Feb-2011***
IBM AIX Based Systems (64-bit)SymptomsAfter patching the OS with Patch IBM Technology Level 6 (5300-06) or Level 7 (5300-07), the application log started reporting the following errors:
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file :
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
ORA-01110: data file :
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
- The errors are not reported in the alert log file.
- Running dbv against datafiles from the error messages shows no errors.
- All the mandatory OS patches are applied.
- Oracle patch for Bug 5496862- IO READING PROBLEMS AFTER INSTALLING IBM TECHNOLOGY LEVEL 5 (5300-05) was installed before patching the OS.
- Running dbv against datafiles from the error messages shows no errors.
- All the mandatory OS patches are applied.
- Oracle patch for Bug 5496862- IO READING PROBLEMS AFTER INSTALLING IBM TECHNOLOGY LEVEL 5 (5300-05) was installed before patching the OS.
ChangesPatch IBM Technology Level 6 (5300-06) or higher was applied to the OS.CauseThe value of maxreqs (4096) was too low. This asynchronous I/O parameter specifies the maximum number of asynchronous I/O requests that can be outstanding at any one time and has as default value 4096.SolutionIncrease maxreqs to a value greater than or equal to 8192.Steps:
1. run aioo -a command to double check current setting for aio0 device
2. run aioo -o maxreqs= to set maxreqs dynamically
3. chdev -l aio0 -a maxreqs= -P to set the value of maxreqs permanently for next reboot
4. run aioo -a to confirm change
5. restart oracle
NOTE: Values that fixed the errors: 8192, 16384 or 32768.
应该就是这个BUG引起的然后查看了Bug 5496862，这个BUG在10.2.0.3中已经修复，而我们的数据库是10.2.0.4，所以不存在这个问题。
