在 MetroCluster 切回期间， Oracle 报告数据损坏

适用于

• ONTAP 9.5x
• VMware ESXi 6.7.0 Update 3
• 主机 HBA QLE269x ：驱动程序版本 3.1.31.0

问题描述

在双节点 MetroCluster 切回期间，多个主机应用程序报告数据损坏。

• Linux 服务器上的 Oracle ：

Media Recovery failed with error 742
Errors in file
/xxxx/ora_dba/dbtrace/diag/rdbms/xxx/xxx/trace/xxx__10284.trc:
ORA-00283: recovery session canceled due to errors
ORA-00742: Log read detects lost write in thread %d sequence %d block %d
ORA-00312: online log 4 thread 1: '/xxx6/xxx/log2/xxx_42.log'
ORA-00312: online log 4 thread 1: '/xxx4/xxx/log1/xxx_41.log'
ORA-283 signalled during: ALTER DATABASE RECOVER database ...

alter database open resetlogs
ORA-1139 signalled during: alter database open resetlogs..

Corrupt block relative dba: 0x00cxxxxx (file 3, block 121469) 
Bad header found during buffer read 

• ESX

2020-05-06T10:12:19.521Z info hostd[2100299] [Originator@6876 sub=Vimsvc.ha-eventmgr] Event 729 : At least one corrupt on-disk lock was detected on volume 59a52d1e-5c60xxxx-xxxx-a0369f8xxxxx (DTS_xx_xxx_00). Other regions of the volume might be damaged too.
 

• Windows

05/07/2020 09:03:32, Windows,Unknown,Backup detected log corruption in database DB