redo异常强制拉库报ORA-600 kcbzib_kcrsds_1修复---惜分飞

本文记录了一次Oracle12c数据库中因多路径异常导致的Redo写丢失问题及后续数据库崩溃的情况。详细分析了从节点2的崩溃到节点1实例恢复失败的过程,并分享了使用第三方工具强制恢复数据库后遇到的ORA-600kcbzib_kcrsds_1错误的处理方法。

节点2 asm dismount导致redo写报错(ORA-00340,ORA-00345),经过分析asm和系统日志,确认是由于多路径异常导致io异常

2022-01-24T23:44:39.966602+08:00

WARNING: group 4 is being dismounted.

WARNING: ASMB force dismounting group 4 (REDO) due to ASM server dismount

SUCCESS: diskgroup REDO was dismounted

2022-01-24T23:44:41.103783+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF2/trace/XFF2_lgwr_228507.trc:

ORA-00345: redo log write error block 11961764 count 6

ORA-00312: online log 10 thread 2: '+REDO/XFF/ONLINELOG/group_10.261.1074690685'

2022-01-24T23:44:41.156809+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF2/trace/XFF2_lgwr_228507.trc:

ORA-00340: IO error processing online log 10 of thread 2

ORA-00345: redo log write error block 11961764 count 6

ORA-00312: online log 10 thread 2: '+REDO/XFF/ONLINELOG/group_10.261.1074690685'

Errors in file /u01/app/oracle/diag/rdbms/xff/XFF2/trace/XFF2_lgwr_228507.trc  (incident=1341402):

ORA-340 [] [] [] [] [] [] [] [] [] [] [] []

Incident details in: /u01/app/oracle/diag/rdbms/xff/XFF2/incident/incdir_1341402/XFF2_lgwr_228507_i1341402.trc

2022-01-24T23:44:41.505251+08:00

USER (ospid: 133928): terminating the instance due to error 340

由于节点2是突然crash,节点1做实例恢复失败,由于节点2的redo发生了写丢失,导致节点1实例恢复后库crash,进而是的该集群的相关数据库节点全部crash

2022-01-24T23:46:08.440519+08:00

Slave encountered ORA-10388 exception during crash recovery

2022-01-24T23:46:08.442854+08:00

Slave encountered ORA-10388 exception during crash recovery

Abort recovery for domain 0, flags 4

2022-01-24T23:46:08.444531+08:00

Aborting crash recovery due to error 742

2022-01-

评论 2
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值