ogg mysql表结构不一致_ogg同步表结构不同的对象

源端执行以下操作

manager的参数

GGSCI (l3rac1) 9> view params mgr

port 7809

DYNAMICPORTLIST 7820-7830

DYNAMICPORTREASSIGNDELAY       10

AUTORESTART EXTRACT *, RETRIES 3, WAITMINUTES 1, RESETMINUTES 60

PURGEOLDEXTRACTS /prod_data/goldengate/dirdat/e*, USECHECKPOINTS, MINKEEPHOURS 2

抽取参数：

GGSCI (l3rac1) 10> view params extorcl

EXTRACT extorcl

USERID gg, PASSWORD gg

EXTTRAIL        /prod_data/goldengate/dirdat/et

TRANLOGOPTIONS ALTARCHIVELOGDEST PRIMARY /prod_data/flash_recovery_area/ORAL3/archivelog/2012_07_11

TABLE scott.WIREMERESULT;

TABLE scott.PP_RK_GXJLSQDB1;

TABLE scott.SD_FORMSTORAGEISSUE;

TABLE scott.CARMERESULT;

TABLE scott.test;

数据泵参数：

GGSCI (l3rac1) 11> view params extpump

EXTRACT extpump

USERID gg, PASSWORD gg

TARGETDEFS ./dirdef/deftest

RMTHOST standby, MGRPORT        7809

RMTTRAIL        /u02/dirdat/rt

PASSTHRU

TABLE scott.WIREMERESULT;

TABLE scott.PP_RK_GXJLSQDB1;

TABLE scott.SD_FORMSTORAGEISSUE;

TABLE scott.CARMERESULT;

NOPASSTHRU

TABLE scott.test, TARGET scott.test, TARGETDEF deftest,

COLMAP (USEDEFAULTS,

PASSWORD_VERSIONS = @GETENV ("GGHEADER", "OPTYPE"),

EDITIONS_ENABLED = "Y",

AUTHENTICATION_TYPE = @GETENV ("GGENVIRONMENT" , "HOSTNAME")

);

初始化同步参数：

GGSCI (l3rac1) 12> view params extini

EXTRACT extini

USERID gg, PASSWORD gg

RMTHOST standby, MGRPORT 7809

rmttask replicat, group repini;

TABLE scott.WIREMERESULT;

TABLE scott.PP_RK_GXJLSQDB1;

TABLE scott.SD_FORMSTORAGEISSUE;

TABLE scott.CARMERESULT;

ADD EXTRACT extorcl, tranlog, begin now

ADD EXTRACT extpump, EXTTRAILSOURCE /prod_data/goldengate/dirdat/et

ADD EXTTRAIL /prod_data/goldengate/dirdat/et, EXTRACT extorcl, MEGABYTES 50

ADD RMTTRAIL /u02/dirdat/rt, EXTRACT extpump, MEGABYTES 50

ADD EXTRACT extini, SOURCEISTABLE

目标端：

GGSCI (standby) 6> view params mgr

port 7809

autorestart replicat *, waitminutes 1, retries 60

PURGEOLDEXTRACTS /u02/dirdat/r*, USECHECKPOINTS, MINKEEPHOURS 2

LAGREPORTHOURS 1

LAGINFOMINUTES 30

LAGCRITICALMINUTES 45

GGSCI (standby) 8> view params reporcl

REPLICAT reporcl

ASSUMETARGETDEFS

REPERROR (1, DISCARD)

DISCARDFILE     /home/oracle/goldengate/discard,APPEND, MEGABYTES 20

DISCARDROLLOVER AT 20:00

USERID gg, PASSWORD gg

MAP scott.WIREMERESULT          TARGET scott.WIREMERESULT;

MAP scott.PP_RK_GXJLSQDB1        TARGET scott.PP_RK_GXJLSQDB1;

MAP scott.SD_FORMSTORAGEISSUE    TARGET scott.SD_FORMSTORAGEISSUE;

MAP scott.CARMERESULT            TARGET scott.CARMERESULT;

MAP scott.test, TARGET scott.test,

where (username = "SYS");

GGSCI (standby) 9> view params repini

REPLICAT repini

USERID gg, PASSWORD gg

BULKLOAD

ASSUMETARGETDEFS

MAP scott.WIREMERESULT          TARGET scott.WIREMERESULT;

MAP scott.PP_RK_GXJLSQDB1        TARGET scott.PP_RK_GXJLSQDB1;

MAP scott.SD_FORMSTORAGEISSUE    TARGET scott.SD_FORMSTORAGEISSUE;

MAP scott.CARMERESULT            TARGET scott.CARMERESULT;

ADD REPLICAT reporcl, EXTTRAIL /u02/dirdat/rt

ADD REPLICAT repini, SPECIALRUN