2023年7月21日发(作者：)

oggmysql配置_配置ogg异构oracle-mysql（3）⽬的端配置⽬的端配置⼤致分为如下三个步骤：配置mgr，配置checkpoint table，配置应⽤进程在⽬的端先创建⼀张表，记得带主键：mysql> create database hr;Query OK, 1 row affected (0.00 sec)mysql> use hrDatabase changedmysql> create table ah4(id int ,name varchar(10),primary key(id));Query OK, 0 rows affected (0.00 sec)mysql> show tables;+--------------+| Tables_in_hr |+--------------+| ah4 |+--------------+1 row in set (0.00 sec)mysql>1.配置mgrGGSCI (nosql2) 2> edit params mgrPORT7809DYNAMICPORTLIST7810-7909--AUTOSTART ER *AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays3LAGREPORTHOURS1LAGINFOMINUTES30LAGCRITICALMINUTES45GGSCI (nosql2)3> start mgrManager (nosql2)4> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING2.配置checkpoint tableGGSCI (nosql2) 7> edit params ./GLOBALSCHECKPOINTTABLE oint添加：GGSCI (nosql2) 8> add checkpointtable ointtabSuccessfully created checkpoint table (nosql2)9> info checkpointtable ointtabCheckpoint table ointtab created2014-04-02 16:11: (nosql2)10>在相应的mysql数据库中，也可以看到相应的表被添加了：mysql> show tables;+---------------+| Tables_in_hr |+---------------+| ah4 || checkpointtab |+---------------+2 rows in set (0.00 sec)3.配置应⽤进程：GGSCI (nosql2) 10> edit params rep3replicat rep3sourcedefs /u01/ogg/11.2/dirdef/RCEDB hr,userid root,password 123456reperror default,discarddiscardfile /u01/ogg/11.2/dirrpt/,append,megabytes 50map 4, target 4;GGSCI (nosql2) 13> add replicat rep3,exttrail /u01/ogg/11.2/dirdat/xs,checkpointtable ointtabREPLICAT :REPLICAT进程参数配置说明：ASSUMETARGETDEFS：假定两端数据结构⼀致使⽤此参数；SOURCEDEFS：假定两端数据结构不⼀致，使⽤此参数指定源端的数据结构定义⽂件，该⽂件需要由GlodenGate⼯具产⽣。MAP:⽤于指定源端与⽬标端表的映射关系；MAPEXCLUDE：⽤于使⽤在MAP中使⽤*匹配时排除掉指定的表；REPERROR：定义出错以后进程的响应，⼀般可以定义为两种：ABEND，即⼀旦出现错误即停⽌复制，此为缺省配置；DISCARD，出现错误后继续复制，只是把错误的数据放到discard⽂件中。DISCARDFILE：定义discardfile⽂件位置，如果处理中油记录出错会写⼊到此⽂件中；SQLEXEC：在进程运⾏时⾸先运⾏⼀个SQL语句；GROUPTRANSOPS：将⼩交易合并成⼀个⼤的交易进⾏提交，减少提交次数，降低系统IO消耗。MAXTRANSOPS：将⼤交易拆分，每XX条记录提交⼀次。4.测试在⽬的端启动rep3进程，在源端启动ext3和push3进程。在源端的ah4表中插⼊⼀条数据，看是否在⽬的端的ah4表中能看到。源端进程：GGSCI (ora11g) 30> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EXT100:00:00 00:00:03EXTRACT RUNNING EXT200:00:00 00:00:07EXTRACT RUNNINGEXT300:44:09 00:00:06EXTRACT RUNNING PUSH100:00:00 00:00:03EXTRACT RUNNING PUSH200:00:0000:00:03EXTRACT RUNNING PUSH300:00:00 00:37:40GGSCI (ora11g)31>源端插⼊数据：SQL> insert into ah4 values(1,'aaaccc');1row > commit;Commit complete.源端的ogg⽇志：2014-04-02 16:19:26 INFO OGG-00993 Oracle GoldenGate Capture for Oracle,: EXTRACT EXT3 started.2014-04-02 16:19:26 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, : No recovery is required for target file/u01/ogg/11.2/dirdat/xs000000, at RBA 0(file not opened).2014-04-02 16:19:26 INFO OGG-01478 Oracle GoldenGateCapture for Oracle, : Output file /u01/ogg/11.2/dirdat/xs is using format RELEASE 11.2.2014-04-02 16:19:26INFO OGG-01517 Oracle GoldenGate Capture for Oracle, : Position of first record processed Sequence 1122, RBA14423056, SCN 0.20548956, Apr 2, 2014 3:35:22PM.2014-04-02 16:19:29 INFO OGG-00987Oracle GoldenGateCommand Interpreter for Oracle: GGSCI command (oracle): start push3.2014-04-02 16:19:29 INFO OGG-00963 OracleGoldenGate Manager for Oracle, : Command received from GGSCI on host ora11g:52177(START EXTRACTPUSH3 ).2014-04-02 16:19:29 INFO OGG-00975 Oracle GoldenGate Manager for Oracle,: EXTRACT PUSH3starting.2014-04-02 16:19:29 INFO OGG-00992 Oracle GoldenGate Capture for Oracle,: EXTRACT PUSH3starting.2014-04-02 16:19:29 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, : Operating systemcharacter set identified as UTF-8. Locale: en_US,LC_ALL:.2014-04-02 16:19:29 INFO OGG-01815 Oracle GoldenGateCapture for Oracle,: Virtual Memory Facilities for: COManon alloc: mmap(MAP_ANON) anon free: munmapfile alloc: mmap(MAP_SHARED) file free: munmaptarget directories:/u01/ogg/11.2/dirtmp.2014-04-02 16:19:29 INFO OGG-00993 Oracle GoldenGate Capture for Oracle,:EXTRACT PUSH3 started.2014-04-02 16:19:34 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, :Socket buffer size set to 27985 (flush size 27985).2014-04-02 16:19:34 INFO OGG-01052 Oracle GoldenGate Capturefor Oracle, : No recovery is required for target file /u01/ogg/11.2/dirdat/xs000000, at RBA 0(file notopened).2014-04-02 16:19:34 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, : Output file/u01/ogg/11.2/dirdat/xs is using format RELEASE 11.2.⽬的端进程：GGSCI (nosql2) 21> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGREPLICAT RUNNING REP300:00:00 00:00:02GGSCI (nosql2)22>⽬的端数据库：mysql> select * from ah4;+----+--------+| id | name |+----+--------+|1| aaaccc |+----+--------+1 row in set (0.00sec)mysql>⽬的端的ogg⽇志：2014-04-02 16:21:55 INFO OGG-00975 Oracle GoldenGate Manager for MySQL,: REPLICAT REP3 starting.2014-04-02 16:21:55 INFO OGG-00995 Oracle GoldenGate Delivery for MySQL,: REPLICAT REP3 starting.2014-04-0216:21:55 INFO OGG-03035 Oracle GoldenGate Delivery for MySQL, : Operating system character set identified asUTF-8. Locale: en_US,LC_ALL:.2014-04-02 16:21:55 INFO OGG-01815 Oracle GoldenGate Delivery for MySQL,:Virtual Memory Facilities for: COManon alloc: mmap(MAP_ANON) anon free: munmapfile alloc: mmap(MAP_SHARED) file free: munmaptarget directories:/u01/ogg/11.2/dirtmp.2014-04-02 16:21:55 INFO OGG-00996 Oracle GoldenGate Delivery for MySQL,:REPLICAT REP3 started.2014-04-02 16:22:17 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, :Command received from EXTRACT on host ::ffff:192.168.0.164 (START SERVER CPU -1 PRI -1 TIMEOUT 300PARAMS).2014-04-02 16:22:17 INFO OGG-01677Oracle GoldenGate Collector for MySQL: Waiting for connection (starteddynamically).2014-04-02 16:22:17 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, : Commandreceived from SERVER on host omain (REPORT 30868 7810).2014-04-02 16:22:17 INFO OGG-00974Oracle GoldenGate Manager for MySQL, : Manager started collector process (Port 7810).2014-04-02 16:22:17INFO OGG-01228 Oracle GoldenGate Collector for MySQL: Timeout in 300seconds.2014-04-02 16:22:22 INFO OGG-01229 Oracle GoldenGate Collector for MySQL: Connected to ::ffff:192.168.0.164:61104.2014-04-02 16:22:22 INFOOGG-01669 Oracle GoldenGate Collector for MySQL: Opening /u01/ogg/11.2/dirdat/xs000000 (byte -1, current EOF0).2014-04-02 16:22:53 INFO OGG-03010 Oracle GoldenGate Delivery for MySQL, : Performing implicitconversion of column data from character set windows-936 to ISO-8859-1.