GoldenGate configuration CLOB type synchronization

最新推荐文章于 2024-02-28 11:52:51 发布

ZhongWeicheng

最新推荐文章于 2024-02-28 11:52:51 发布

阅读量2.1k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/staricqxyz/article/details/8364440

Oracle 同时被 2 个专栏收录

165 篇文章

订阅专栏

Oracle GoldenGate

18 篇文章

订阅专栏

本文详细介绍了在GoldenGate DML同步过程中，如何正确配置参数以处理包含CLOB类型的字段。通过创建表、插入数据、验证目标端数据一致性等步骤，确保了同步过程的准确性与效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在GoldenGate的DML同步中,如果字段类型包含CLOB,必须在源端的extract参数文件中添加以下参数

TRANLOGOPTIONS CONVERTUCS2CLOBS

GGSCI (gg01) 19> VIEW params eorajj

EXTRACT EORAJJ
USERID system, PASSWORD oracle
RMTHOST gg02, MGRPORT 7809
RMTTRAIL /u01/app/oracle/goldengate/dirdat/jj

DDL INCLUDE ALL
DDLOPTIONS ADDTRANDATA,REPORT

TRANLOGOPTIONS CONVERTUCS2CLOBS

TABLE scott.*;
SEQUENCE scott.*;

源端操作

SCOTT@gg01:~>create table t_clob(tid integer primary key,c_clob clob);

Table created.

SCOTT@gg01:~>insert into t_clob values(1,'TEST');

1 row created.

SCOTT@gg01:~>commit;

Commit complete.

SCOTT@gg01:~>set linesize 200
SCOTT@gg01:~>select * from t_clob;

       TID C_CLOB
---------- --------------------------------------------------------------------------------
         1 TEST

目标端

SCOTT@gg02:~>SELECT tname FROM tab;

TNAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
T_ZWC
T_CLOB

6 ROWS selected.

SCOTT@gg02:~>SELECT * FROM t_clob;

       TID C_CLOB
---------- --------------------------------------------------------------------------------
         1 TEST

[oracle@gg02 goldengate]$ logdump 

Oracle GoldenGate Log File Dump Utility
Version 10.4.0.19 Build 002

Copyright (C) 1995, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.


 
Logdump 23 >OPEN /u01/app/oracle/goldengate/dirdat/jj000003
CURRENT LogTrail IS /u01/app/oracle/goldengate/dirdat/jj000003 
Logdump 24 >ghdr ON
Logdump 25 >headertoken ON
Logdump 26 >usertoken ON
Logdump 27 >detail ON
Logdump 28 >detail DATA
Logdump 29 >n
TokenID x46 'F' Record Header    Info xff80  LENGTH  927 
TokenID x30 '0' TrailInfo        Info x00  LENGTH  442 
TokenID x31 '1' MachineInfo      Info x00  LENGTH   85 
TokenID x32 '2' DatabaseInfo     Info x00  LENGTH  283 
TokenID x33 '3' ProducerInfo     Info x00  LENGTH   81 
TokenID x34 '4' ContinunityInfo  Info x00  LENGTH    8 
TokenID x5a 'Z' Record Trailer   Info xff80  LENGTH  927 

2012/01/15 16:58:18.278.866 FileHeader           Len   919 RBA 0 
Name: *FileHeader* 
 3000 01ba 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0...0...GG..TL..1...  
 0002 3200 0004 ffff fffd 3300 0008 02f1 dcc0 c151 | ..2.......3........Q  
 2fd2 3400 0025 0023 7572 693a 6767 3031 3a3a 7530 | /.4..%.#uri:gg01::u0  
 313a 6170 703a 6f72 6163 6c65 3a67 6f6c 6465 6e67 | 1:app:oracle:goldeng  
 6174 6536 0000 2c00 2a2f 7530 312f 6170 702f 6f72 | ate6..,.*/u01/app/OR  
 6163 6c65 2f67 6f6c 6465 6e67 6174 652f 6469 7264 | acle/goldengate/dird  
 6174 2f6a 6a30 3030 3030 3337 0000 0101 3800 0004 | at/jj0000037....8...  
 
Logdump 30 >n
TokenID x47 'G' Record Header    Info x01  LENGTH   61 
TokenID x48 'H' GHDR             Info x00  LENGTH   35 
TokenID x54 'T' GGS Tokens       Info x00  LENGTH   10 
TokenID x5a 'Z' Record Trailer   Info x01  LENGTH   61 
___________________________________________________________________ 
Hdr-Ind    :     E  (x45)     Partition  :     .  (x00)  
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)  
RecLength  :     0  (x0000)   IO TIME    : 2012/01/15 16:58:25.307.836   
IOType     :   151  (x97)     OrigNode   :     0  (x00) 
TransInd   :     .  (x03)     FormatType :     R  (x52) 
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00) 
AuditRBA   :          0       AuditPos   : 0 
Continued  :     N  (x00)     RecCount   :     0  (x00) 

2012/01/15 16:58:25.307.836 RestartOK            Len     0 RBA 927 
Name:  
After  Image:                                             Partition 0   G  s   
   
Logdump 31 >n
TokenID x47 'G' Record Header    Info x01  LENGTH  160 
TokenID x48 'H' GHDR             Info x00  LENGTH   47 
TokenID x44 'D' DATA             Info x00  LENGTH   47 
TokenID x54 'T' GGS Tokens       Info x00  LENGTH   46 
TokenID x5a 'Z' Record Trailer   Info x01  LENGTH  160 
___________________________________________________________________ 
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)  
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)  
RecLength  :    47  (x002f)   IO TIME    : 2012/01/15 17:00:30.032.862   
IOType     :     5  (x05)     OrigNode   :   255  (xff) 
TransInd   :     .  (x03)     FormatType :     R  (x52) 
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00) 
AuditRBA   :          4       AuditPos   : 10869684 
Continued  :     N  (x00)     RecCount   :     1  (x01) 

2012/01/15 17:00:30.032.862 INSERT               Len    47 RBA 988 
Name: SCOTT.T_CLOB 
After  Image:                                             Partition 4   G  s   
 0000 0005 0000 0001 3100 0100 2200 0000 1e3c 4854 | ........1..."....TEST  
 3c2f 4854 4d4c 3e                                 |   
Column     0 (x0000), Len     5 (x0005)  
 0000 0001 31                                      | ....1  
Column     1 (x0001), Len    34 (x0022)  
 0000 001e 3c48 544d 4c3e 3c42 4f44 593e 5445 5354 | ....TEST  
 3c2f 424f 4459 3e3c 2f48 544d 4c3e                |