WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192

系统平台：AIX  6100-05-05-1112

数据库版本：11.2.0.2.0

 

实例的 alert 报错：

 

Errors in file /oracle/app/oracle/diag/rdbms/cshsc/cshsc/trace/cshsc_ora_50987280.trc:
WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
WARNING: failed to read mirror side 1 of virtual extent 12324 logical extent 0 of file 263 in group [5.939757579] from disk CSHSCDG_0003  allocation unit 14009 reason error; if possible,will try another mirror side
Errors in file /oracle/app/oracle/diag/rdbms/cshsc/cshsc/trace/cshsc_ora_50987280.trc:
WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
WARNING: failed to read mirror side 1 of virtual extent 12324 logical extent 0 of file 263 in group [5.939757579] from disk CSHSCDG_0003  allocation unit 14009 reason error; if possible,will try another mirror side
Errors in file /oracle/app/oracle/diag/rdbms/cshsc/cshsc/trace/cshsc_ora_50987280.trc:
WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
WARNING: failed to read mirror side 1 of virtual extent 12324 logical extent 0 of file 263 in group [5.939757579] from disk CSHSCDG_0003  allocation unit 14009 reason error; if possible,will try another mirror side
Errors in file /oracle/app/oracle/diag/rdbms/cshsc/cshsc/trace/cshsc_ora_50987280.trc:
WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
WARNING: failed to read mirror side 1 of virtual extent 12324 logical extent 0 of file 263 in group [5.939757579] from disk CSHSCDG_0003  allocation unit 14009 reason error; if possible,will try another mirror side
Errors in file /oracle/app/oracle/diag/rdbms/cshsc/cshsc/trace/cshsc_ora_50987280.trc:
WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
WARNING: failed to read mirror side 1 of virtual extent 12324 logical extent 0 of file 263 in group [5.939757579] from disk CSHSCDG_0003  allocation unit 14009 reason error; if possible,will try another mirror side

 

 

 

cshsc_ora_50987280.trc 的内容如下：

 

WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
path:/dev/rhdisk46
         incarnation:0xeb2380e3 synchronous result:'I/O error'
         subsys:System iop:0x110a3ac70 bufp:0x7000002a6b9e000 osderr:0x434c5344 osderr1:0x0
WARNING: failed to read mirror side 1 of virtual extent 12324 logical extent 0 of file 263 in group [5.939757579] from disk CSHSCDG_0003  allocation unit 14009 reason e
rror; if possible,will try another mirror side
WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
path:/dev/rhdisk46
         incarnation:0xeb2380e3 synchronous result:'I/O error'
         subsys:System iop:0x110a3ac70 bufp:0x7000002a6b9e000 osderr:0x434c5344 osderr1:0x0
WARNING: failed to read mirror side 1 of virtual extent 12324 logical extent 0 of file 263 in group [5.939757579] from disk CSHSCDG_0003  allocation unit 14009 reason e
rror; if possible,will try another mirror side
WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
path:/dev/rhdisk46
         incarnation:0xeb2380e3 synchronous result:'I/O error'
         subsys:System iop:0x110a3ac70 bufp:0x7000002a6b9e000 osderr:0x434c5344 osderr1:0x0
WARNING: failed to read mirror side 1 of virtual extent 12324 logical extent 0 of file 263 in group [5.939757579] from disk CSHSCDG_0003  allocation unit 14009 reason e
rror; if possible,will try another mirror side

 

 

Cause

Check:

1) ASM side:

* Make sure the ASM instance remains up and running, despite of these entries/messages.
* Verify that all ASM disk groups remain mounted and have no offlined ASM disks.
* Overall, the ASM instance is functional (one can connect to it, run queries on the various v$asm% views, like: v$asm_diskgroup, v$asm_disk)

2) The database remains open and operational (no outage).

3) Storage level:

* The sysadmin, storage admin, and storage vendor has verified no errors in the OS system logs nor any other storage related logs, in regards to any of the disks or devices utilized by the ASM disk groups.

Furthermore, they have ran all due IO and hardware diagnostics on these devices/disks and they found no real IO or hardware related issue.

4) After all above checked okay, then this is related to Bug:10051315 , Bug:10055063 and Bug:10422126 which fix is included in 11.2.0.3

Solution

Either use the work-around or apply the merge patch.

1) Work-around:

Prevent the file system from filling up by a) saving these files to another location with larger storage space or some type of offline storage (i.e., tape, etc.) AND b) either truncate or remove the logs / trc files periodically and systematically (i.e, cron job, etc)

2) Merge patch:

Select proper Oracle Release/version and platform, and apply patch: https://updates.oracle.com/download/10422126.html

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

转载于:http://blog.itpub.net/22308399/viewspace-752211/