RAC一个节点的数据库无法启动:ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [,internalerror
一个客户的RAC节点硬件发生了变动,主机重启后数据库实例无法启动,远程登陆查看ALERT日志发现大量报错:
Writing to the above trace file is disabled for now on...
Errors in file /oracle/app/diag/rdbms/XXXX/XXXX2/trace/XXXX2_ora_184464.trc:
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1]
查了MOS,原因是主机的系统时间不对
,文档是ORA-00600: internal error code, arguments: [4:kgstmLdiToEpochTs] (文档 ID 1334956.1)
抓紧检查节点主机时间,果然是时间不对--年份不对,月日时分秒都是一致。主机的时间应该是更换硬件后恢复了初始时间1970年。
联系客户联系人,协调SA调整时间,又折腾一通,终于全部搞定。。
Bug 4401437 CONNECT BY query may fail with OERI:qergiStart1 / OERI:qesmmCValStat4
This note gives a brief overview of bug 4401437.
The content was last updated on: 03-APR-2009
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions BELOW 11.1
Versions confirmed as being affected
10.2.0.1
10.1.0.4
9.2.0.8
Platforms affected Generic (all / most platforms affected)
Workaround
Add a "no_filtering" hint to the query.
可以通过加no_filtering的 提示了 绕过该错误哦!
如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
[kccpb_sanity_check_2] indicates that the seq# of the last read block is
higher than the seq# of the control file header block. This is indication of
the lost write of the header block during commit of the previous cf
transaction.
因该是数据库损坏了,导致块内的SEQ#不正确。建议在有备份的情况下还原数据,否则的话需要专家做数据修复。 如果不是生产库的话,建议重建