GoldenGate_Oracle数据分发解决方案——广播复制配置.doc

Oracle GoldenGate 数据分发解决方案广播复制的实现数据仓库数据实时更新，对源数据库影响较低。广播复制的优点连续可用，快速容灾切换。有效的提升商务智能和信息分析能力，实时可用的数据仓库。负载均衡，提高系统的整体性能。一对多数据同步（广播复制）一对多数据同步实现架构：GoldenGate对于多对一的实现方式，就是对于同一个源建立多个提取进程同步进行，也就是说，对应不同的目标端，分别配置同步进程进行同步。配置过程与前面是一样的。这里的多个目标端，有可能对应不同的数据库，也有可能是同一个库中的不同对象。如果是同步到同一个库中的不同对象，除了分别配置同步进程以外，有时候也可以在一个进程中完成。软件准备:1.Oracle10.2.0.12.ggs_Windows_x86_ora10g_32bit3.wls1033_win324.gg-director-serversetup_win_v11_1_1_1_0_0015.gg-director-clientsetup_win_v11_1_1_1_0_001=Oracle DataaBase添加用户Oracle GoldenGate Director Server11.1.1.1.0_001 专用database user: ggserver/ggserver11配置alter database add supplemental log data;alter database add supplemental log data (primary key,unique,foreign key) columns;GoldenGate专用gatedba/gatedbaOracle Database同步用户，表结构相同，数据一致生产服务器Gate1: gate01/gate01 备份服务器Gate2: gate02/gate02备份服务器Gate3: gate03/gate03=步骤：1.安装ggs_Windows_x86_ora10g_32bit2.Add GoldenGate Proccess*Gate01 服务器*dblogin userid gatedba,password gatedbastart mgredit param extgate1 /*extract extgate1 userid gatedba,password gatedbaexttrail C:ggs_Windows_x86_ora10g_32bitdirdate1tranlogoptions excludeuser gatedba dynamicresolution gettruncatesTABLE gate01.*;*/add extract extgate1,tranlog,begin nowadd exttrail C:ggs_Windows_x86_ora10g_32bitdirdate1, extract extgate1#DataPump: gate01 to gate02edit param pp1/*extract pp1userid gatedba,password gatedbarmthost 192.168.64.101,mgrport 7809,compress, COMPRESSTHRESHOLD 0rmttrail C:ggs_Windows_x86_ora10g_32bitdirdatrepe1PASSTHRU gettruncatestable gate01.*;*/add extract pp1,exttrailsource C:ggs_Windows_x86_ora10g_32bitdirdate1,begin nowadd rmttrail C:ggs_Windows_x86_ora10g_32bitdirdatrepe1, extract pp1#DataPump: gate01 to gate03edit param pp2/*extract pp2userid gatedba,password gatedbarmthost 192.168.64.102,mgrport 7809,compress, COMPRESSTHRESHOLD 0rmttrail C:ggs_Windows_x86_ora10g_32bitdirdatrepe1PASSTHRU gettruncatestable gate01.*;*/add extract pp2,exttrailsource C:ggs_Windows_x86_ora10g_32bitdirdate1,begin nowadd rmttrail C:ggs_Windows_x86_ora10g_32bitdirdatrepe1, extract pp2*Gate02 服务器*dblogin userid gatedba,password gatedbastart mgredit param repgate1/*replicat repgate1 userid gatedba,password gatedba ASSUMETARGETDEFS reperror default,discard discardfile C:ggs_Windows_x86_ora10g_32bitdirrptrepgate1.dsc,append,megabytes 200 gettruncatesHANDLECOLLISIONSMAP gate01.*, TARGET gate02.*;*/add replicat repgate1,exttrail C:ggs_Windows_x86_ora10g_32bitdirdatrepe1, nodbcheckpoint*Gate03 服务器*dblogin userid gatedba,password gatedbastart mgredit param repgate2/*replicat repgate2 userid gatedba,password gatedba ASSUMETARGETDEFS reperror default,discard discardfile C:ggs_Windows_x86_ora10g_32bitdirrptrepgate2.dsc,append,megabytes 200 gettruncatesHANDLECOLLISIONSMAP gate01.*, TARGET gate03.*;*/add replicat repgate2,exttrail C:ggs_Windows_x86_ora10g_32bitdirdatrepe1, nodbcheckpoint=3.安装Oracle Golden Gate director Serveroracle database :ggserver/ggserver114.安装Oracle Golden Gate director client一对多配置框架如下图所示：登陆帐户：username:adminpassword:adminserver: 192.168.64.100:70015.配置Oracle GDSC Admin Tool登陆帐户：username:adminpassword:admin添加DataSource : gate01为例, gate02, gate03同样配置host identity: fully qualified domain name:192.168.64.100 manager port: 7809 data source name gate01-自定义别名，用来区分数据库GoldenGate info: Host operating system:WU Database:ORA Goldengate version:11.1.1.1Default DB Credentials: DSN: -没有Host解析不填 Username: gatedba -专用 password: gatedbaAccess Control owner: admin Host is observale: yes比如，可以在复制端如此配置：/*REPLICAT rep146e1USERID coss3,PASSWORD coss3assumetargetdefsREPERROR default,discardDISCARDFILE d:ggoraclelog