由第三方软件or硬件提供商导致的oracle database 损坏问题

本文参考自:Known Corruption issues caused by 3rd party Software/Hardware Provider (Doc ID 1323649.1)

Applies to: 

Oracle Database - Enterprise Edition - Version 8.0.6.0 to 12.1.0.1 [Release 8.0.6 to 12.1]
Information in this document applies to any platform.

Purpose

This document is intended to consolidate all corruption issues for which 3rd party providers (non-Oracle) have identified software problems to be the root cause of what is overwriting the Oracle datafiles or losing IO (lost write) producing corruption errors like:


ORA-1578  "ORACLE data block corrupted (file # %s, block # %s)"
ORA-1565  "error in identifying file '%s'"
ORA-353   "log corruption near block %s change %s time %s"
ORA-354   "corrupt redo log block header"
ORA-27047 "unable to read the header block of file"
ORA-27048 "skgfifi: file header information is invalid"
ORA-752 "recovery detected a lost write of a data block"
ORA-600 [3020] "Stuck Recovery"

Details

Note 1587427.1 Block Corruption (ALL ZERO) detected after reclaiming space on Veritas Filesystem

Note 1545366.1 Physical Corrupted Blocks consisting of all Zeroes indicate a problem with OS, HW or Storage

Note 373595.1 ORA-1578 ORA-27047 ORA-27048 Corrupt blocks when using RMAN / NetBackup

Note 2035575.1 ORA-1578 Database Corruption with String int_WriteData by dbclient log in NetBackup / RMAN

Note 1323567.1 ORA-1578 blocks overwritten by EMC Networker - RMAN Networker Module for Oracle (NMO)

Note 1313454.1 ORA-1578 Block overwritten with string "DiskDescription cyl alt hd sec" when using Symantec / Veritas

Note 1323108.1 ORA-1578 Data Block Corruptions when using EMC Storage. Blocks with 0xc9 byte

Note 1323532.1 ORA-1578 ORA-354 ORA-600 [3020] Misplaced blocks by Symantec / Veritas after adding LUN

Note 1525108.1 ORA-1578 Misplaced blocks against datafiles stored in NFS filers

Note 1923358.1 ORA-1578 Misplaced blocks against datafiles stored on LINUX in NFS filers

Note 1487957.1 ORA-1578 ORA-353 ORA-19599 Corrupt blocks with zeros when filesystemio_options=SETALL on ext4 file system using Linux

Note 1486903.1 ORA-1578 Transient Corruption - Caused by Parity Error on EMC DMX4

Note 1512717.1 Database Corruption due to Lost IO on Hitachi storage. ORA-600 [kdsgrp1] ORA-1499 ORA-1410 ORA-600 [3020]

Note 779711.1 ORA-354 ORA-353 Corrupt Redo Log Block Header against online redolog using EMC/Cisco SANTap Service

Note 1498389.1 ORA-354 Redo log corruption when using Xisgo Driver

Note 1512717.1 Database Corruption due to Lost IO on Hitachi storage. ORA-600 [kdsgrp1] ORA-1499 ORA-1410 ORA-600 [3020]

Note 1675764.1 Database  Corruption due to stale/old blocks after EMC SRDF/A DR switchover -  ORA-600 [25027] ORA-600 [kdsgrp1] ORA-8103 ORA-1410

Note 1905184.1 Database corruption due to lost write while using EMC DATAMOVER

Note 1900359.1 Transient Corruption in OVM Linux - Reread finds a valid block version

References

NOTE:1512717.1 - Database Corruption due to Lost IO on Hitachi storage. ORA-600 [kdsgrp1] ORA-1499 ORA-1410 ORA-600 [3020]
NOTE:1545366.1 - Physical Corrupted Blocks consisting of all Zeroes indicate a problem with OS, HW or Storage
NOTE:1487957.1 - ORA-1578 ORA-353 ORA-19599 Corrupt blocks with zeros when filesystemio_options=SETALL on ext4 file system using Linux
NOTE:1498389.1 - ORA-354 Redo log corruption when using Xisgo Driver
NOTE:1675764.1 - Database Corruption due to stale/old blocks after EMC SRDF/A DR switchover - ORA-600 [25027] ORA-600 [kdsgrp1] ORA-8103 ORA-1410
NOTE:1900359.1 - Transient Corruption in OVM Linux - Reread finds a valid block version
NOTE:1905184.1 - Database corruption due to lost write while using EMC DATAMOVER
NOTE:373595.1 - ORA-1578 ORA-27047 ORA-27048 Corrupt blocks when using RMAN / NetBackup
NOTE:1525108.1 - ORA-1578 Misplaced blocks against datafiles stored in NFS filers
NOTE:1323108.1 - ORA-1578 Data Block Corruptions when using EMC Storage. Blocks with 0xc9 byte
NOTE:1313454.1 - ORA-1578 Block overwritten with string "DiskDescription cyl alt hd sec" when using Symantec / Veritas
NOTE:1486903.1 - ORA-1578 Transient Corruption - Caused by Parity Error on EMC DMX4
NOTE:1587427.1 - Block Corruption (ALL ZERO) detected after reclaiming space on Veritas Filesystem
NOTE:1323567.1 - ORA-1578 blocks overwritten by EMC Networker - RMAN Networker Module for Oracle (NMO)
NOTE:1323532.1 - ORA-1578 ORA-354 ORA-600 [3020] Misplaced blocks by Symantec / Veritas after adding LUN
NOTE:1923358.1 - ORA-1578 Misplaced blocks on LINUX against datafiles stored in NFS filers
NOTE:2035575.1 - ORA-1578 Database Corruption with String int_WriteData by dbclient log in NetBackup / RMAN
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值