ORA-04045,Standby停止Apple log处理一例
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.
