ORA-15080: synchronous I/O operation to a disk faile

本文记录了一次Oracle RAC环境遇到的IO错误问题,详细分析了The Network Adapter could not establish the connection错误及ORA-15080等告警信息,故障原因在于存储掉电和交换机异常。文章分享了重启后的检查步骤,包括监听器重启、EM shell作业重启、手动全备执行以及状态检查。
部署运行你感兴趣的模型镜像

1 问题概述

生产环境中,有一套Oracle RAC,突然反映说IO 错误: The Network Adapter could not establish the connection,并且节点掉了一个。同时备库、单实例库均无法访问。

于是查看trace log进行分析,发现以下报错且不断循环:

Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_rfs_34796.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 38 logical extent 0 of file 262 in group 1 on disk 0 allocatio
05 WARNING: Write Failed. group:1 disk:0 AU:2112 offset:0 size:173056

Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_rfs_34796.trc:
ORA-15080: synchronous I/O operation to a disk failed
Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_rfs_101669.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 38 logical extent 0 of file 262 in group 1 on disk 0 allocatio
05
WARNING: failed to write mirror side 1 of virtual extent 37 logical extent 0 of file 266 in group 1 on disk 0 allocatio
112
WARNING: Write Failed. group:1 disk:0 AU:905 offset:721408 size:512Errors in file /u01/app/oracle/diag/rdbms/racdb_stan
b/trace/racdb_rfs_101669.trc:
ORA-15080: synchronous I/O operation to a disk failed

WARNING: failed to write mirror side 1 of virtual extent 37 logical extent 0 of file 266 in group 1 on disk 0 allocatio
112
Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_rfs_34796.trc:
ORA-15080: synchronous I/O operation to a disk failed
Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_rfs_101669.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 38 logical extent 0 of file 262 in group 1 on disk 0 allocatio
05
WARNING: failed to write mirror side 1 of virtual extent 36 logical extent 0 of file 266 in group 1 on disk 0 allocatio
111
Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_rfs_34796.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 38 logical extent 0 of file 262 in group 1 on disk 0 allocatio
05 NOTE: Suppress further IO Write errors on group:1 disk:0

Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_pr00_31669.trc:
ORA-00333: redo log read error block 74851 count 1
ORA-00312: online log 6 thread 2: '+FRA/racdb_standby/onlinelog/redo06.log'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_rfs_101669.trc:
ORA-15080: synchronous I/O operation to a disk failed
NOTE: Suppress further IO Write errors on group:1 disk:0
WARNING: failed to write mirror side 1 of virtual extent 37 logical extent 0 of file 266 in group 1 on disk 0 allocatio
112
Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_rfs_34796.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: Read Failed. group:1 disk:0 AU:2111 offset:574976 size:512
Errors in file /u01/app/oracle/diag/rdbms/racdb_standby/racdb/trace/racdb_rfs_101669.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 38 logical extent 0 of file 262 in group 1 on disk 0 allocatio
05
WARNING: failed to write mirror side 1 of virtual extent 37 logical extent 0 of file 266 in group 1 on disk 0 allocatio
112
.......
.......

2 问题解决

经过排查,是由于存储掉电引起的故障,有存储的交换机出现异常导致。
rac环境在存储掉电后,两个节点的服务器都会自动重启。之前的rac环境掉了一个节点是由于服务器光驱内有安装光盘卡住,导致未重启成功。

服务器重启后,rac环境自动重启,单实例环境手动重启。

重启后需要注意:

  • 无论单实例还是rac都要检查并重新开启监听
  • 如果EM上有shell作业的也需要重新开启EM
  • 受影响未执行备份作业的,为确保数据安全需要手动执行全备
  • 逐一检查各项状态是否正常,比如存储是否重新挂载、备库是否有gap等

您可能感兴趣的与本文相关的镜像

ACE-Step

ACE-Step

音乐合成
ACE-Step

ACE-Step是由中国团队阶跃星辰(StepFun)与ACE Studio联手打造的开源音乐生成模型。 它拥有3.5B参数量,支持快速高质量生成、强可控性和易于拓展的特点。 最厉害的是,它可以生成多种语言的歌曲,包括但不限于中文、英文、日文等19种语言

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值