早上刚到公司，发现一台逻辑备库告警日志中出现以下错误：

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博客

dataguard之逻辑备库报错ORA-00600 [KSFD_DECAIOPC]