ORA-04045,Standby停止Apple log处理一例

今天检查数据库, 发现standby 已经停止apply 了. 查看日志发现如下错误:

LOGSTDBY status: ORA-04045: errors during recompilation/revalidation of MES.BARCODE_INFO_TR1

LOGSTDBY Apply process P005 pid=29 OS id=2232 stopped

Wed Jun 11 08:48:47 2008

LOGSTDBY status: ORA-04045: errors during recompilation/revalidation of MES.BARCODE_INFO_TR1

LOGSTDBY Apply process P004 pid=28 OS id=1580 stopped

Wed Jun 11 08:48:47 2008

LOGSTDBY status: ORA-04045: errors during recompilation/revalidation of MES.BARCODE_INFO_TR1

LOGSTDBY Apply process P007 pid=31 OS id=1248 stopped

Wed Jun 11 08:48:47 2008

LOGSTDBY status: ORA-04045: errors during recompilation/revalidation of MES.BARCODE_INFO_TR1

LOGSTDBY Apply process P008 pid=32 OS id=2668 stopped

Wed Jun 11 08:48:47 2008

Errors in file d:"mes"dump"bdump"mess_lsp0_2648.trc:

ORA-12801: error signaled in parallel query server P005

ORA-04045: errors during recompilation/revalidation of MES.BARCODE_INFO_TR1

LOGSTDBY Analyzer process P003 pid=27 OS id=2028 stopped

LOGSTDBY Apply process P006 pid=30 OS id=2480 stopped

Wed Jun 11 08:48:47 2008

LOGSTDBY status: ORA-16222: automatic Logical Standby retry of last action

LOGSTDBY status: ORA-16111: log mining and apply setting up

Wed Jun 11 08:48:47 2008

检查Trigger MES.BARCODE_INFO_TR1的状态,为不可用.发现这个trigger用到了一个DB_LINK.检查此DB_LINK,发现不可用.突然想到可能是standby的TNSNAMES和主库不同,修改成相同后,编译这个trigger,成功.

重新Apply,检查LOG,发现开始Apply.

转载于:https://www.cnblogs.com/kevinsun/archive/2008/06/11/1217514.html