OGG-05798 Write LOB Column Segment Operation (token 0x23) Detected At Trail File (Doc ID 2843936.1)

0    82    2

👉 本文共约604个字,系统预计阅读时间或需3分钟。

现象

我用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.

解决

在源端添加如下参数,然后重新抽取:

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

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

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.

Reference: https://docs.oracle.com/en/middleware/goldengate/core/19.1/reference/tranlogoptions.html#GUID-B6ADFEC9-10E6-456D-9477-088513E113AF

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.

    头像

    小麦苗

    学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

    您可能还喜欢...

    发表评论

    您的电子邮箱地址不会被公开。

    14 + 2 =

     

    嘿,我是小麦,需要帮助随时找我哦
    • 18509239930
    • 个人微信

    • 麦老师QQ聊天
    • 个人邮箱
    • 点击加入QQ群
    • 个人微店

    • 回到顶部
    返回顶部