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。