Skip to main content
NetApp Knowledge Base

During the MetroCluster switchback Oracle reported data corruption

Views:
269
Visibility:
Public
Votes:
0
Category:
fas-systems
Specialty:
san
Last Updated:

Applies to

  • ONTAP 9.5X
  • VMware ESXi 6.7.0 Update 3
  • Host HBA QLE269x: driver version 3.1.31.0

Issue

During the switchback of 2-node MetroCluster, multiple host applications reported data corruption.

  • Oracle on Linux server:

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

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.