Troubleshooting Oracle ASM diskgroup dismount with ORA-15335 ORA-15066 ORA-15196 when delete instance use DBCA

  • 2024/04/14
  • ORACLE 9i-23ai
  • 199 views
  • Troubleshooting Oracle ASM diskgroup dismount with ORA-15335 ORA-15066 ORA-15196 when delete instance use DBCA已关闭评论

环境为Oracle 11.2.0.4 2节点RAC的情况下，今天我们遇到了一个问题。同事在使用DBCA删除一个已经损坏的数据库实例时，意外地导致了当前唯一存活的数据库实例崩溃。进一步的检查发现，ASM磁盘组不可用，而ASM警报日志显示了ASM磁盘文件头损坏、ASM元数据损坏以及ORA-15196: 无效的ASM块头的错误。为什么删除数据库实例会导致ASM磁盘组不可用，并且发现ASM元数据损坏呢？

, , , ,

阅读全文

Troubleshooting ORA-01578 ORA-01110 ORA-26040 NOLOGGING corrupted block

  • 2020/05/20
  • Cloud, ORACLE 9i-23ai
  • 2,460 views
  • Troubleshooting ORA-01578 ORA-01110 ORA-26040 NOLOGGING corrupted block已关闭评论

The following errors have recently occurred in our database( Oracle 19c RAC):
ORA-01578: ORACLE data block corrupted (file # xxx, block # yyyyy)
ORA-01110: data file xxx: ‘xxxxxxxxxxxxxxxxx.dbf’
ORA-26040: Data block was loaded using the NOLOGGING option

, , , ,

阅读全文

DBVerify report Corrupt block “Completely zero block found during dbv” when use RAW Device, but rman not.

  • 2016/09/11
  • ORACLE 9i-23ai
  • 837 views
  • DBVerify report Corrupt block “Completely zero block found during dbv” when use RAW Device, but rman not.已关闭评论

因为raw device头上记录的是552959 个块数，但数据文件实际为540640个块数， 所以在oracle 未使用的block都未格式化,但是DBV如果不指定end 截至位置都会扫描， 所以DBV会提示那些都是勘误块， 使用RMAN未发现。

, , ,

阅读全文