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調整時間,又折騰一通,終於全部搞定。。
ORACLE資料庫中有一個SQL報錯ORA-00600,其中使用了SYS_CONNECT_BY_PATH對一些資料進行匯總,相助
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資料庫修複團隊成員幫您恢複!
詩檀軟體專業資料庫修複團隊
ORACLE ora-00600
[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#不正確。建議在有備份的情況下還原資料,否則的話需要專家做資料修複。 如果不是生產庫的話,建議重建