安装环境：
Source:OS:redhat 6.3IP:192.168.56.60DB:Oracle 11.2.0.4Target:OS:redhat 6.3IP:192.168.56.13DB:Mysql 5.6.14Goldengate for mysql：https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=14841438
安装配置source端Goldengate：
useradd ogg -g oinstallAdd Environment Variblevi /home/oracle/.bash_profileexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/oggConfigure Databasealter database archivelog;alter database force logging;alter database add supplemental log data;select SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI from v$database;ALTER SYSTEM SET recyclebin = OFF scope=spfile; for Oracle 11g ,need to be restartCreate OGG User:sqlplus / as sysdbacreate user ogg identified by ogg;grant dba to ogg;GGSCI (zbdba1) 1> edit params ./GLOBALGGSCHEMA oggCHECKPOINTTABLE ogg.checkpoint
注意goldengate for mysql 不支持ddl
MANAGERGGSCI (zbdba1) 1> create subdirsGGSCI (zbdba1) 22> view param mgrport 7839DYNAMICPORTLIST 7840-7914USERID OGG,PASSWORD oggAUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 3PURGEOLDEXTRACTS ./DIRDAT/*,MINKEEPDAYS 3PURGEDDLHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10,FREQUENCYMINUTES 30PURGEMARKERHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10LAGREPORTHOURS 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45 EXTRACTGGSCI (zbdba1) 1> dblogin userid ogg,password oggGGSCI (zbdba1) 1> add trandata zbdba.*add extract ext1,tranlog, begin nowadd exttrail /ogg/dirdat/sa extract ext1add rmttrail ./dirdat/sa,extract ext1GGSCI (zbdba1) 9> view param ext1EXTRACT EXT1setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )USERID ogg,PASSWORD oggDDL &INCLUDE MAPPED OBJTYPE 'TABLE' &INCLUDE MAPPED OBJTYPE 'IDNEX' &INCLUDE MAPPED OBJTYPE 'SEQUENCE' &INCLUDE MAPPED OBJTYPE 'VIEW' &INCLUDE MAPPED OBJTYPE 'PROCEDURE' &INCLUDE MAPPED OBJTYPE 'FUNCTION' &INCLUDE MAPPED OBJTYPE 'PACKAGE' &INCLUDE MAPPED OBJTYPE 'MATERIALIZED VIEW' &EXCLUDE OPTYPE COMMENTDDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORTREPORTCOUNT EVERY 1 MINUTES,RATEDISCARDFILE ./dirrpt/EXTSA.DSC,APPEND,MEGABYTES 1024THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000 IOLATENCY 60000DBOPTIONS ALLOWUNUSEDCOLUMNWARNLONGTRANS 2H,CHECKINTERVAL 3Mexttrail ./dirdat/saFETCHOPTIONS NOUSESNAPSHOT,FETCHPKUPDATECOLS,MISSINGROW REPORTtable zbdba.*;datapumpadd extract ext2,exttrailsource /ogg/dirdat/saADD EXTTRAIL ./dirdat/sa, EXTRACT EXT2add rmttrail /ogg/dirdat/sa, extract ext2GGSCI (zbdba1) 2> view param ext2EXTRACT EXT2passthruRMTHOST 192.168.56.61,MGRPORT 7839,COMPRESSRMTTRAIL ./dirdat/satable zbdba.*;Target端安装配置ogg:useradd ogg -g mysqlGGSCI (zbdba2) 1> create subdirsGGSCI (zbdba2) 52> view param ./GLOBALCHECKPOINTTABLE zbdba.checkpointGGSCI (zbdba2) 53> view param mgrport 7839DYNAMICPORTLIST 7840-7914AUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 3PURGEOLDEXTRACTS ./DIRDAT/*,MINKEEPDAYS 3PURGEDDLHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10,FREQUENCYMINUTES 30PURGEMARKERHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10LAGREPORTHOURS 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45vi /etc/my.cnfsocket =/tmp/mysql.sockGGSCI (zbdba2) 1> dblogin sourcedb zbdba userid rootGGSCI (zbdba2) 2> add checkpointtable zbdba.checkpointSuccessfully created checkpoint table ZBDBA.CHECKPOINT.GGSCI (zbdba2) 2> add replicat rep1,exttrail /ogg/dirdat/sa, checkpointtable ogg.checkpointREPLICAT added.GGSCI (zbdba2) 2> add checkpointtable zbdba.checkpointSuccessfully created checkpoint table OGG.CHECKPOINT.GGSCI (zbdba2) 2> add replicat rep1,exttrail /ogg/dirdat/sa, checkpointtable ogg.checkpointREPLICAT added.GGSCI (zbdba) 55> view param rep1REPLICAT rep1sourcedefs /ogg/dirdef/ext2mysql.defASSUMETARGETDEFSSOURCEDB zbdba,userid root,password mysqldiscardfile ./dirdat/rep1_discard.txt,append,megabytes 5DDL INCLUDE MAPPEDHANDLECOLLISIONSDDLERROR DEFAULT DISCARD RETRYOP MAXRETRIES 5 RETRYDELAY 20–grouptransops 1–maxtransops 1APPLYNOOPUPDATESMAP zbdba.*, TARGET zbdba.*;进行初始化：Source：ADD EXTRACT initload, SOURCEISTABLEview param initloadEXTRACT initloaduserid ogg, password oggRMTHOST 192.168.56.13, MGRPORT 7839, COMPRESSRMTTASK REPLICAT, GROUP reploadTABLE ZBDBA.*;创建数据定义文件：edit param defgendefsfile /ogg/dirdef/ext2mysql.defuserid ogg,password oggtable zbdba.*;[ogg@zbdba1 ogg]$ ./defgen paramfile dirprm/defgen.prm***********************************************************************Oracle GoldenGate Table Definition Generator for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230 Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 05:08:19Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.Starting at 2015-03-02 03:21:52***********************************************************************Operating System Version:LinuxVersion #1 SMP Wed Jun 13 18:24:36 EDT 2012, Release 2.6.32-279.el6.x86_64Node: zbdba1Machine: x86_64soft limit hard limitAddress Space Size : unlimited unlimitedHeap Size: unlimited unlimitedFile Size: unlimited unlimitedCPU Time: unlimited unlimitedProcess id: 3935*************************************************************************Running with the following parameters*************************************************************************defsfile /ogg/dirdef/ext2mysql.defuserid ogg,password ***table zbdba.*;Expanding wildcard zbdba.*:Retrieving definition for ZBDBA.ZBDBA2015-03-02 03:21:56 WARNING OGG-00869 No unique key is defined for table 'ZBDBA'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.Definitions generated for 1 table in /ogg/dirdef/ext2mysql.defscp ext2mysql.def 192.168.56.13:/ogg/dirdef/一直有记日记的习惯，可是，旅行回来，
