1.问题:
复制进程Abend出现报错:
ERROR OGG-00664 OCI Error Flushing database inbound server, ‘OGG$REP1’ (status = 26804-ORA-26804: Apply “OGG$REP1” is disabled.).
WARNING OGG-02531 Inbound server OGG$REP1 error status ORA-26,808:ORA-26808: Apply process AS02 died unexpectedly.
2.原因:
This happened due to below bugs
Bug 9567897 - STREAMS APPLY ABORTS WITH ORA-07445 [KXSEPHEMERALFRAMEPUSH()+560] [SIGSEGV]
Bug 24653457 - ORA-7445 [KXSEPHEMERALFRAMEPUSH] OR HANG BY APPLY SERVER IN LOGICAL STANDBY
This bug is applicable for 11.2.0.4 and 12.1.0.2 . It is not a goldengate bug but logminor/streams bug
3.解决:
Please add this parameter in replicat parameter file and start the replicat
DBOPTIONS INTEGRATEDPARAMS (_DATA_LAYER N)
4.MOS ID:
GoldenGate Integrated Replicat Is Failing With Error “OGG-00664 OCI Error Flushing database inbound server, ‘OGG$REP1’ (status = 26804-ORA-26804: Apply “OGG$REP1” is disabled.)” (Doc ID 2343712.1)