dataguard之邏輯備庫報錯ORA-00600 [KSFD_DECAIOPC]

suifeng2316發表於2011-11-25
AI
早上剛到公司，發現一臺邏輯備庫告警日誌中出現以下錯誤：
Fri Nov 25 07:44:08 2011
Errors in file /home/oracle/admin/cms2009/bdump/cms2009_lsp0_19249.trc:
ORA-12801: error signaled in parallel query server P004
ORA-00600: internal error code, arguments: [kollasg:client lob on server], [], [], [], [], [], [], []
LOGSTDBY Apply process P005 pid=47 OS id=19263 stopped
……
Errors in file /home/oracle/admin/cms2009/bdump/cms2009_lsp0_19249.trc:
ORA-12801: error signaled in parallel query server P000
ORA-00600: internal error code, arguments: [KSFD_DECAIOPC], [0x24C52A500], [], [], [], [], [], []
LOGSTDBY Apply process P005 pid=47 OS id=19263 stopped
LOGSTDBY Apply process P004 pid=46 OS id=19261 stopped
LOGSTDBY Apply process P009 pid=50 OS id=19271 stopped
LOGSTDBY Apply process P010 pid=51 OS id=19273 stopped
LOGSTDBY Apply process P008 pid=49 OS id=19269 stopped
Fri Nov 25 07:44:14 2011
TLCR process death detected. Shutting down TLCR
於是立即檢查：
select * from v$Logstdby_state;
發現日誌應用已經停止，於是嘗試將其日誌應用重啟。
alter database start logical standby apply immediate;
執行完畢發現日誌應用一切正常。

之後一直在查詢錯誤原因所在，可能是bug所為：
Bug 7312623: ORA-00600 [KSFD_DECAIOPC] ON LOGICAL STANDBY DATABASE。






來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23073818/viewspace-712043/，如需轉載，請註明出處，否則將追究法律責任。

相關文章