Oracle 在还原/导入时ASM 磁盘组dismounted由于 ” OSD-04016: Error queuing an asynchronous I/O request'”

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

适用于：

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 能解决该问题