Troubleshooting Oracle 11.2.0.4 frequently ORA-8103 on Local non-prefixed index

  • 2022/09/19
  • ORACLE 9i-23ai
  • 214 views
  • Troubleshooting Oracle 11.2.0.4 frequently ORA-8103 on Local non-prefixed index已关闭评论

最近遇到了2个客户出现在11.2.0.4环境中频繁出现ora-8103的问题，基本上都是索引对象object mismatch, 重建后过段时间会再现， 该类问题使用rman validate logical 还无法发现，算是当前oracle软件的一个未知bug.

阅读全文

12c R2 DB Alert Log频繁输出”An internal routine has requested a dump of selected redo”

  • 2020/08/14
  • Cloud, ORACLE 9i-23ai
  • 1,184 views
  • 12c R2 DB Alert Log频繁输出”An internal routine has requested a dump of selected redo”已关闭评论

1套Oracle 12.2 4Nodes RAC ON SELS11的本地磁盘使用率告警，DIAG目录在不断的生成redo dump的trace file, db alert log也在不停的显示如下信息:
An internal routine has requested a dump of selected redo.
This usually happens following a specific internal error

,

阅读全文

Troubleshooting Oracle ORA-1410 & ORA-01499 & ORA-08103 block corrupted

  • 2016/11/19
  • ORACLE 9i-23ai
  • 1,905 views
  • Troubleshooting Oracle ORA-1410 & ORA-01499 & ORA-08103 block corrupted已关闭评论

ORA-1499 is produced by statement “ANALIZE TABLE|CLUSTER VALIDATE STRUCTURE CASCADE” to report an inconsistency between a table or a cluster and its index where an index,ORA-8103 is caused by an invalid block type. The block header has an invalid block type or the block type inside the block is not expected

, , , ,

阅读全文