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

  • 2022/09/19
  • ORACLE 9i-23ai
  • 213 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,181 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

,

阅读全文