ogg mysql表结构不一致_OGG配置案例一(源表与目标表结构不一致)

源库: 192.168.31.16 TNS=orcl

目标库:192.168.31.113 TNS=vmsys---------------------------------------------表结构:

SQL> desc jack.t10 --源表

Name Null?Type----------------------------------------- -------- ----------------------------ID NUMBER

NAME VARCHAR2(800)

AGE NUMBER

SQL> desc jack.t10 --目标表

Name Null?Type----------------------------------------- -------- ----------------------------TID NUMBER

TNAME VARCHAR2(800)

TAGE NUMBER

SQL>源库OGG配置1. extract进程配置:

GGSCI (rac01)2>view param lxt10

EXTRACT lxt10------------------------------------------

-- local extract forjack.t10------------------------------------------SETENV (NLS_LANG=american_america.AL32UTF8)

SETENV (ORACLE_SID=orcl)

USERID ogg@orcl,PASSWORD ogg

TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD oracle

EXTTRAIL/goldengate/