存储宕机导致Oracle异常故障处理---惜分飞

Sun Jul 21 20:00:11 2024

Thread 1 advanced to log sequence 1594398 (LGWR switch)

  Current log# 5 seq# 1594398 mem# 0: +DATA/xff/onlinelog/group_5.412.906718739

Sun Jul 21 20:53:17 2024

WARNING: Write Failed. group:2 disk:0 AU:506916 offset:49152 size:16384

Sun Jul 21 20:53:17 2024

WARNING: Read Failed. group:2 disk:2 AU:506931 offset:49152 size:16384

WARNING: failed to read mirror side 1 of virtual extent 4 logical extent 0 of file 415 in group [2.34109396]

from disk ORACLE_DATA_0002  allocation unit 506931 reason error; if possible, will try another mirror side

Errors in file /users/oracle/app/db/diag/rdbms/xff/xff1/trace/xff1_ckpt_42142.trc:

ORA-15080: 与磁盘的同步 I/O 操作失败

ORA-27061: 异步 I/O 等待失败

Linux-x86_64 Error: 5: Input/output error

Additional information: -1

Additional information: 16384

WARNING: failed to write mirror side 1 of virtual extent 0 logical extent 0

of file 415 in group 2 on disk 0 allocation unit 506916

Errors in file /users/oracle/app/db/diag/rdbms/xff/xff1/trace/xff1_ckpt_42142.trc:

ORA-00206: 写入控制文件时出错 (块 3, # 块 1)

ORA-00202: 控制文件: ''+DATA/xff/controlfile/current.415.906718737''

ORA-15081: 无法将 I/O 操作提交到磁盘

ORA-15081: 无法将 I/O 操作提交到磁盘

Errors in file /users/oracle/app/db/diag/rdbms/xff/xff1/trace/xff1_ckpt_42142.trc:

ORA-00221: 写入控制文件时出错

ORA-00206: 写入控制文件时出错 (块 3, # 块 1)

ORA-00202: 控制文件: ''+DATA/xff/controlfile/current.415.906718737''

ORA-15081: 无法将 I/O 操作提交到磁盘

ORA-15081: 无法将 I/O 操作提交到磁盘

CKPT (ospid: 42142): terminating the instance due to error 221

Errors in file /users/oracle/app/db/diag/rdbms/xff/xff1/trace/xff1_lmon_42087.trc:

ORA-00202: 控制文件: ''+DATA/xff/controlfile/current.415.906718737''

ORA-15081: 无法将 I/O 操作提交到磁盘

ORA-27072: 文件 I/O 错误

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 1038194784

Additional information: -1

Sun Jul 21 20:53:19 2024

ORA-1092 : opitsk aborting process

Sun Jul 21 20:53:24 2024

ORA-1092 : opitsk aborting process

Sun Jul 21 20:53:24 20