19.1版本OGG应用进程报错：ORA-26804, ORA-26808，ORA-26857

启动复制进程abend，日志如下：

# OGG报错：
ERROR   OGG-00664 r_DB42.prm:  OCI Error ORA-26804: Apply "OGG$R_DB42" is disabled. (status = 26804-Flushing database inbound server, 'OGG$R_DB42').
WARNING OGG-02531 r_DB42.prm:  Inbound server OGG$R_DB42 error status ORA-26,808:ORA-26808: Apply process AS0T died unexpectedly.
INFO    OGG-02333 r_DB42.prm:  Reading /data/ogg19c/dirdat/x2000000000, current RBA 126,107,111, 294,770 records, m_file_seqno = 0, m_file_rba = 126,107,507.
ERROR   OGG-01668 r_DB42.prm:  PROCESS ABENDING.
# RDBMS 告警日志报错
Sat Mar 12 15:34:20 2022   Errors in file /oracle/app/oracle/base/diag/rdbms/DB/orcldb/trace/orcldb_as17_154265.trc:
Sat Mar 12 15:34:20 2022   ORA-26857: LCR position cannot be null (XID=).

# MOS 1680582.1 : 12.1之前的OGG版本需要打补丁，但是使用的OGG版本是19.1
OGG 12c - Integrated Apply Abends With Error OGG-00664 OCI Error Flushing Database Inbound Server (Doc ID 1680582.1)
Bug : 17362306 - OGG: IR ABENDS/APPLY FATAL ERROR 'ORA-26857: LCR POSITION CANNOT BE NULL
SOLUTION
This bug is fixed in GoldenGate version 12.1.2.1.x or higher
Please download and apply one of the latest patchsets/bundle patches that contains this fix.

# MOS 2343712.1 : 受2个BUG影响，需要配置DBOPTIONS INTEGRATEDPARAMS 配置之后无效
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)
CAUSE
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
SOLUTION
Please add this parameter in replicat parameter file and start the replicat
DBOPTIONS INTEGRATEDPARAMS (_DATA_LAYER N)

最终解决办法

# 这个队列文件的其它应用进程是OK的，只是在执行某个表的事务的时候报错过不去，
# 最终解决办法：跳过该报错事务位置，使用logdump查找下一个事务的位置，从下一个事务位置开始同步