诗檀软件专业数据库修复团队
适用于：
Oracle Database - Enterprise Edition – 版本 11.2.0.3及以上
本文信息适用于任何平台。
症状
在还原数据库或以并行属性使用impdp时，会生成以下错误且磁盘组会脱机
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 2) The system cannot find the file specified.
WARNING: Write Failed. group:1 disk:0 AU:1 offset:1044480 size:4096
WARNING: Hbeat write to PST disk 0.4109271146 (ARCH_0000) in group 1 failed.
detach from dom 1, sending detach message to inst 2
ERROR: ORA-15130 in COD recovery for diskgroup 1/0x233e7092 (ARCH)
ERROR: ORA-15130 thrown in RBAL for group number 1
Errors in file E:\APP\ORACLE\diag\asm\+asm\+asm1\trace\+asm1_rbal_5472.trc:
ORA-15130: diskgroup "ARCH" is being dismounted >>>>>>>>>>>>>>>>>>>>>>>>>>> Diskgroup getting dismounted as its not able to handle async io
List of instances:
1 2
Dirty detach reconfiguration started (new ddet inc 1, cluster inc 4)
Global Resource Directory partially frozen for dirty detach
* dirty detach - domain 1 invalid = TRUE
326 GCS resources traversed, 0 cancelled
ERROR: -9(Error 27070, OS Error (OSD-04016: Error queuing an asynchronous I/O request. >>>>>>>>>>>>> Not able to handle async io
O/S-Error: (OS 2) The system cannot find the file specified.)
原因
Filesystemio_options 被设为none
解决方案
将 filesystemio_options 更改为async 能解决该问题