OGG配置案例一(源表与目标表结构一致)
SQL> desc jack.t9 --源表 Name Null? Type ----------------------------------------- -------- ---------------------------- ID NUMBER NAME VARCHAR2(200) FID NUMBER SQL> desc jack.t9 --目标表 Name Null? Type ----------------------------------------- -------- ---------------------------- ID NUMBER NAME VARCHAR2(200) FID NUMBER AB NUMBER OWNER VARCHAR2(200) <<源OGG配置>> 1. extract进程参数 GGSCI (rac01) 4> view param lxjackt9 EXTRACT lxjackt9 ------------------------------------------ -- local extract for jack.t9 ------------------------------------------ SETENV (NLS_LANG=american_america.AL32UTF8) SETENV (ORACLE_SID=orcl) USERID ogg@orcl,PASSWORD ogg TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD oracle EXTTRAIL /goldengate/dirdat/orcl/t9 TABLE jack.t9; #RAC源需要配置 ,threads 2表示有2个节点,单节点不用加threads 2 GGSCI(HOSTname) 1> add extract lxjackt9,threads 2,tranlog,begin now #添加抽取源文件位置和大小 GGSCI(Hostname) 2> add exttrail /goldengate/dirdat/t9,extract lxjackt9,megabytes 100 2. DataPump进程参数 GGSCI (rac01) 5> view param lpjackt9 EXTRACT lpjackt9 ---------------------------------------------- -- DataPump extract lpjack for jack.t9 ---------------------------------------------- USERID ogg@orcl,PASSWORD ogg NOPASSTHRU RMTHOST 192.168.31.113 MGRPORT 7809 RMTTRAIL /goldengate/dirdat/orcl/t9 TABLE jack.t9; #定义DataPump进程名,以及需要抽取的源trail文件位置/goldengate/dirdat/t9 GGSCI(Host) 1> add extract lpjack,exttrailsource /goldengate/dirdat/t9 #定义增加远程trail文件位置和远程trail文件大小 GGSCI(Host) 2> add rmttrail /goldengate/dirdat/t9,extract lpjack,megabytes 100 <<目标OGG配置>> 1. replicat进程参数 GGSCI (class113) 2> view param rejackt9 replicat rejackt9 ----------------------------- -- replicat for jack.t9 ----------------------------- USERID ogg@vmsys,password ogg HandleCollisions AssumeTargetDefs --此参数表示目标表与源表结构一致 Map jack.t9,Target jack.t9,colmap(USEDEFAULTS,owner="jack",ab=); 注意: 目标表中ab列为空,必须写在colmap最末尾后面 GGSCI(Hostname) 1> add replicat rejackt9,exttrail /goldengate/dirdat/t9