OGG-05798 Write LOB Column Segment Operation (token 0x23) Detected At Trail File (Doc ID 2843936.1)
现象
我用ogg21.3同步Oracle 12c到MySQL 8.0时，同步blob对象报错：
ERROR OGG-05798 Write LOB column segment operation (token 0x23) detected at trail file /oggoracle/dirdat/eo000000000, RBA 2759, for table LHR.IMAGE_LOB, column T_IMAGE. Write LOB column segment operation is not supported for this target.
解决
在源端添加如下参数，然后重新抽取：
1 | TRANLOGOPTIONS FETCHPARTIALLOB |
mos文档
OGG-05798 Write LOB Column Segment Operation (token 0x23) Detected At Trail File (Doc ID 2843936.1)
APPLIES TO:
Oracle GoldenGate Big Data and Application Adapters - Version 21.3.0.0.0 and later
Information in this document applies to any platform.
GOAL
OGG-05798 Write LOB column segment operation (token 0x23) detected at trail file
SOLUTION
This is seems to be an Oracle Only trail file. Also will be giving an error for any non-oracle replicat process.
In our case it is OGGBD, eventually this will error out. So the answer is to re-extract the data from using the following parameter.
TRANLOGOPTIONS FETCHPARTIALLOB
Valid for Extract in integrated capture mode for Oracle.
Use this option when replicating to a heterogeneous target or in other conditions where the full LOB image is required. It causes Extract to fetch the full LOB object, instead of using the partial change object from the redo record. By default, the database logmining server sends Extract a whole or partial LOB, depending on whether all or part of the source LOB was updated. To ensure the correct snapshot of the LOB, the Oracle Flashback feature must be enabled for the table and Extract must be configured to use it. The Extract FETCHOPTIONS parameter controls fetching and must be set to USESNAPSHOT (the default in the absence of NOUSESNAPSHOT). Without a Flashback snapshot, Extract fetches the LOB from the table, which may be a different image from the point in time when the redo record was generated.
