单机+单机之单向OGG配置dml用友网络科技股份有限公司总部技术支持人：王安宁支持日期：2019年1月25日技术支持服务部–单机+单机的单向OGG配置报告文档控制此文档仅供用友技术支持服务部审阅，不得向与此无关的个人或机构传阅或复制。修改记录日期作者版本修改记录2019-1-25王安宁1.0创建初始版本分发者姓名职位审阅记录姓名职位相关文档技术支持服务部–单机+单机之单向OGG配置报告第2页目录文档控制.....................................................................................................................................2修改记录..............................................................................................................................2分发者..................................................................................................................................2审阅记录..............................................................................................................................2相关文档..............................................................................................................................2目录.............................................................................................................................................31.源端、目标端设计.............................................................................................................41.1IP分配：...................................................................................................................41.2软件安装路径............................................................................................................41.3源端、目标端数据库安装........................................................................................41.4源端，必须开启附加日志、归档和强制写日志....................................................41.5创建数据库用户，并授权........................................................................................62.OGG安装..............................................................................................................................82.1下载goldengate.......................................................................................................82.2Goldengate安装准备...............................................................................................82.3Goldengate安装部署.............................................................................................132.3.1mgr进程配置.......................................................................................................132.3.2extract进程配置...............................................................................................162.3.3源端配置datapump进程...................................................................................192.3.4源端测试goldengate能否抓取数据：............................................................202.3.5目标端..................................................................................................................213.单向DML同步测试............................................................................................................23技术支持服务部–单机+单机之单向OGG配置报告第3页1.源端、目标端设计1.1IP分配：操作系统内存Ip地址数据库版本ORACLE_SID磁盘大小源端Redhatlinux6.52048m192.0.2.10111.2.0.4.0ogg127g目标端Redhatlinux6.52048m192.0.2.10211.2.0.4.0ogg227g1.2软件安装路径软件安装路径oracle/u01/app/oracle/product/11.2.0.4/db_1ogg/ogg1.3源端、目标端数据库安装单机的数据库安装过程（略）1.4源端，必须开启附加日志、归档和强制写日志1.开启附加日志SYS@ogg1>selectsupplemental_log_data_minfromv$database;SUPPLEME--------NOSYS@ogg1>alterdatabaseaddsupplementallogdata;Databasealtered.SYS@ogg1>selectsupplemental_log_data_minfromv$database;SUPPLEME--------YESSYS@ogg1>2.开启归档SYS@ogg1>archiveloglistDatabaselogmodeNoArchiveModeAutomaticarchivalDisabledArchivedestinationUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence4Currentlogsequence6SYS@ogg1>altersystemsetlog_archive_dest_1='location=/arch'scope=spfile;技术支持服务部–单机+单机之单向OGG配置报告第4页Systemaltered.SYS@ogg1>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SYS@ogg1>startupmountORACLEinstancestarted.TotalSystemGlobalArea1068937216bytesFixedSize2260088bytesVariableSize864027528bytesDatabaseBuffers197132288bytesRedoBuffers5517312bytesDatabasemounted.SYS@ogg1>alterdatabasearchivelog;Databasealtered.SYS@ogg1>archiveloglistDatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/archOldestonlinelogsequence4Nextlogsequencetoarchive6Currentlogsequence6SYS@ogg1>alterdatabaseopen;Databasealtered.SYS@ogg1>3.开启强制写日志SYS@ogg1>selectforce_loggingfromv$database;FOR---NOSYS@ogg1>alterdatabaseforcelogging;Databasealtered.SYS@ogg1>selectforce_loggingfromv$database;FOR---YESSYS@ogg1>1.5创建数据库用户，并授权1.源端技术支持服务部–单机+单机之单向OGG配置报告第5页SYS@ogg1>createtablespaceoggtbsdatafile'/u01/app/oradata/OGG1/datafile/oggtbs_1.dbf'size50mautoextendonnext5mmaxsize2g;Tablespacecreated.SYS@ogg1>createuseroggidentifiedbyoggdefaulttablespaceoggtbsquotaunlimitedonoggtbs;Usercreated.SYS@ogg1>grantconnect,resource,createsession,altersessiontoogg;Grantsucceeded.SYS@ogg1>grantselectanydictionary,selectanytable,alteranytable,createanytable,flashbackanytabletoogg;Grantsucceeded.SYS@ogg1>grantexecuteondbms_flashbacktoogg;Grantsucceeded.SYS@ogg1>2.目标端SYS@ogg2>createtablespaceoggtbsdatafile'/u01/app/oracle/oradata/OGG2/datafile/oggtbs_1.dbf'size50mautoextendonnext5mmaxsize2g;Tablespacecreated.SYS@ogg2>createuseroggidentifiedbyoggdefaulttablespaceoggtbsquotaunlimitedonoggtbs;Usercreated.SYS@ogg2>grantconnect,resource,createsession,altersessiontoogg;Grantsucceeded.SYS@ogg2>grantconnecttoogg;grantalteranytabletoogg;grantaltersessiontoogg;grantcreatesessiontoogg;grantflashbackanytabletoogg;grantselectanydictionarytoogg;grantselectanytabletoogg;grantresourcetoogg;grantinsertanytabletoogg;grantupdateanytabletoogg;grantdeleteanytabletoogg;grantcreateanyindextoogg;grantselectanytransactiontoogg;同步的表为scott下所有表，所以目标端ogg用户有对scott下的表有dml权限，否则开启的同步的表在目标端应用时报权限错误。可使用下面执行的结果批量授权技术支持服务部–单机+单机之单向OGG配置报告第6页SELECT'GRANTSELECT,DELETE,UPDATE,INSERTONscott.'||table_name||'TOogg;'FROMUSER_TABLES;技术支持服务部–单机+单机之单向OGG配置报告第7页2.OGG安装2.1下载goldengate位置在：oracle官网/downloads/middleware/下：http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html2.2Goldengate安装准备1.源端1）创建/ogg目录，修改属主为oracle:oinstall[root@ogg1/]#mkdirogg[root@ogg1/]#chown-Roracle:oinstall/ogg2）解压ogg软件[root@ogg1/]#su-oracle[oracle@ogg1~]$cd/ogg[oracle@ogg1ogg]$ls-ltotal87100-rw-r--r--.1oracleoinstall89186858Feb292016ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip[oracle@ogg1ogg]$unzipogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zipArchive:ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zipinflating:fbo_ggs_Linux_x64_ora11g_64bit.tarinflating:OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdfinflating:OracleGoldenGate11.2.1.0.1README.txtinflating:OracleGoldenGate11.2.1.0.1README.doc[oracle@ogg1ogg]$ls-ltotal310632-rw-rw-r--.1oracleoinstall228556800Apr232012fbo_ggs_Linux_x64_ora11g_64bit.tar-rw-r--r--.1oracleoinstall89186858Feb292016ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip-rwxrwxrwx.1oracleoinstall220546May22012OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf-rwxrwxrwx.1oracleoinstall93696May22012OracleGoldenGate11.2.1.0.1README.doc-rwxrwxrwx.1oracleoinstall24390May22012OracleGoldenGate11.2.1.0.1README.txt[oracle@ogg1ogg]$tar-xvffbo_ggs_Linux_x64_ora11g_64bit.tar3）修改~/.bash_profile参数文件，增加$OGG_HOME参数[oracle@ogg1ogg]$vi~/.bash_profile[oracle@ogg1ogg]$cat~/.bash_profile#.bash_profile#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcfi#UserspecificenvironmentandstartupprogramsPATH=$PATH:$HOME/binexportPATHaliasa='sqlplus/assysdba'技术支持服务部–单机+单机之单向OGG配置报告第8页exportLANG=en_USexportORACLE_SID=ogg1exportOGG_HOME=/oggexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$OGG_HOME:$ORACLE_BASE/product/11.2.0.4/db_1exportPATH=$ORACLE_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/libumask022[oracle@ogg1ogg]$[oracle@ogg1ogg]$source~/.bash_profile[oracle@ogg1ogg]$ggsciOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux,x64,64bit(optimized),Oracle11gonApr23201208:32:14Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(ogg1)1>infoall;ERROR:Invalidcommand.GGSCI(ogg1)2>4）创建OGG专用目录subdirs[root@ogg1/]#su-oracle[oracle@ogg1~]$cd/ogg[oracle@ogg1ogg]$ggsciOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux,x64,64bit(optimized),Oracle11gonApr23201208:32:14Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(ogg1)1>createsubdirsCreatingsubdirectoriesundercurrentdirectory/oggParameterfiles/ogg/dirprm:alreadyexistsReportfiles/ogg/dirrpt:createdCheckpointfiles/ogg/dirchk:createdProcessstatusfiles/ogg/dirpcs:createdSQLscriptfiles/ogg/dirsql:createdDatabasedefinitionsfiles/ogg/dirdef:createdExtractdatafiles/ogg/dirdat:createdTemporaryfiles/ogg/dirtmp:createdStdoutfiles/ogg/dirout:createdGGSCI(ogg1)2>各目录用途如下表：名字用途dirprm存放OGG参数各的配置信息dirrpt存放进程报告文件dirchk存放检查点文件技术支持服务部–单机+单机之单向OGG配置报告第9页dirpcs存放进程状态文件dirsql存放SQL脚本文件dirdef存放DEFGEN工具生成的数据定义文件dirdat存放Trail文件，也就是Capture进程捕获的日志文件dirtmp当事物需要的内存超过已分配内存时，默认存储在这个目录2.目标端1）目标端创建/ogg目录，修改属主为oracle:oinstall[root@ogg2/]#mkdirogg[root@ogg2/]#chown-Roracle:oinstall/ogg2）解压OGG软件，到/ogg目录下技术支持服务部–单机+单机之单向OGG配置报告第10页[root@ogg2ogg]#su-oracle[oracle@ogg2~]$cd/ogg[oracle@ogg2ogg]$ls-l7100-rw-r--r--.1oracleoinstall8918685821616:05ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip[oracle@ogg2ogg]$unzipogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zipArchive:ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zipinflating:fbo_ggs_Linux_x64_ora11g_64bit.tarinflating:OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdfinflating:OracleGoldenGate11.2.1.0.1README.txtinflating:OracleGoldenGate11.2.1.0.1README.doc[oracle@ogg2ogg]$ls-l10632-rw-rw-r--.1oracleoinstall2285568004232012fbo_ggs_Linux_x64_ora11g_64bit.tar-rw-r--r--.1oracleoinstall8918685821616:05ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip-rwxrwxrwx.1oracleoinstall220546522012OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf-rwxrwxrwx.1oracleoinstall93696522012OracleGoldenGate11.2.1.0.1README.doc-rwxrwxrwx.1oracleoinstall24390522012OracleGoldenGate11.2.1.0.1README.txt[oracle@ogg2ogg]$tar-xvffbo_ggs_Linux_x64_ora11g_64bit.tar3）修改.bash_profile参数文件[oracle@ogg2~]$cat.bash_profile#.bash_profile#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcfi#UserspecificenvironmentandstartupprogramsPATH=$PATH:$HOME/binexportPATHaliasa='sqlplus/assysdba'exportLANG=en_USexportORACLE_SID=ogg2exportOGG_HOME=/oggexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1exportPATH=$ORACLE_HOME/bin:$PATH:$OGG_HOMEexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/libumask022[oracle@ogg2~]$4）创建OGG专用目录subdirs[oracle@ogg2ogg]$ggsciOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux,x64,64bit(optimized),Oracle11gonApr23201208:32:14Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(ogg2)1>createsubdirsCreatingsubdirectoriesundercurrentdirectory/ogg技术支持服务部–单机+单机之单向OGG配置报告第11页Parameterfiles/ogg/dirprm:alreadyexistsReportfiles/ogg/dirrpt:createdCheckpointfiles/ogg/dirchk:createdProcessstatusfiles/ogg/dirpcs:createdSQLscriptfiles/ogg/dirsql:createdDatabasedefinitionsfiles/ogg/dirdef:createdExtractdatafiles/ogg/dirdat:createdTemporaryfiles/ogg/dirtmp:createdStdoutfiles/ogg/dirout:createdGGSCI(ogg2)2>2.3Goldengate安装部署2.3.1mgr进程配置一、源端1.Mgr进程参数配置[oracle@ogg1ogg]$pwd/ogg[oracle@ogg1ogg]$ggsciOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux,x64,64bit(optimized),Oracle11gonApr23201208:32:14Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(ogg1)1>editparamsmgr技术支持服务部–单机+单机之单向OGG配置报告第12页GGSCI(ogg1)2>infomgrManagerisDOWN!GGSCI(ogg1)3>viewparamsmgrport7839dynamicportlist7840-7850autostartextract*autorestartextract*purgeoldextracts/ogg/dirdat/*,usecheckpoints,minkeepdays7lagreporthours1laginfominutes30lagcriticalminutes45GGSCI(ogg1)4>startmgrManagerstarted.GGSCI(ogg1)5>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGGGSCI(ogg1)6>infomgrManagerisrunning(IPportogg1.7839).GGSCI(ogg1)7>二、目标端1、mgr进程配置[oracle@ogg2ogg]$ggsciOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux,x64,64bit(optimized),Oracle11gonApr23201208:32:14Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(ogg2)1>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERSTOPPEDGGSCI(ogg2)2>infomgrManagerisDOWN!GGSCI(ogg2)3>editparamsmgrGGSCI(ogg2)4>viewparamsmgr技术支持服务部–单机+单机之单向OGG配置报告第13页port7839dynamicportlist7480-7850autostartreplicat*autorestartreplicat*purgeoldextracts./dirdat/*,usecheckpoints,minkeepdays7lagreporthours1laginfominutes30lagcriticalminutes45GGSCI(ogg2)10>startmgrManagerstarted.GGSCI(ogg2)11>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGGGSCI(ogg2)12>infomgrManagerisrunning(IPportogg2.7839).GGSCI(ogg2)13>MANAGER进程参数配置说明：PORT指定服务监听端口；默认端口为7809DYNAMICPORTLIST动态端口：可以制定最大256个可用端口的动态列表，当指定的端口不可用时，管理进程将会从列表中选择一个可用的端口，源端和目标段的Collector、Replicat、GGSCI进程通信也会使用这些端口；COMMENT注释行，也可以用--来代替;AUTOSTART指定在管理进程启动时自动启动哪些进程AUTORESTART自动重启参数设置：本处设置表示每3分钟尝试重新启动所有EXTRACT进程，共尝试5次；PURGEOLDEXTRACTS定期清理trail文件设置LAGREPORT、LAGINFO、LAGCRITICAL定义数据延迟的预警机制AUTORESTARTEXTRACT*,RETRIES5,WAITMINUTES3自动重新启动EXTRACT进程，每隔3分钟尝试一次，尝试5次PURGEOLDEXTRACTS./dirdat/*,usecheckpoints,minkeepdays3本处设置表示对于超过3天的trail文件进行删除。LAGREPORTHOURS1LAGINFOMINUTES30LAGCRITICALMINUTES45技术支持服务部–单机+单机之单向OGG配置报告第14页本处设置表示MGR进程每隔1小时检查EXTRACT的延迟情况，如果超过了30分钟就把延迟作为信息记录到错误日志中，如果延迟超过了45分钟，则把它作为警告写到错误日志中。2.3.2extract进程配置三、源端配置extract1、配置ogg_user用户的表级附加日志。配置登陆用户。并检查日志是否添加成功。注意：发现是disabled，还没有添加成功，继续下一步。注意：现在成功了，是enable的。GGSCI(ogg1)2>dbloginuseridogg,passwordoggSuccessfullyloggedintodatabase.GGSCI(ogg1)3>infotrandatascott.*LoggingofsupplementalredologdataisdisabledfortableSCOTT.A.LoggingofsupplementalredologdataisdisabledfortableSCOTT.AB.LoggingofsupplementalredologdataisdisabledfortableSCOTT.B.LoggingofsupplementalredologdataisdisabledfortableSCOTT.BONUS.LoggingofsupplementalredologdataisdisabledfortableSCOTT.DEPT.LoggingofsupplementalredologdataisdisabledfortableSCOTT.EMP.LoggingofsupplementalredologdataisdisabledfortableSCOTT.SALGRADE.GGSCI(ogg1)4>addtrandatascott.*2019-02-2211:17:40WARNINGOGG-00869Nouniquekeyisdefinedfortable'A'.Allviablecolumnswillbeusedtorepresentthekey,butmaynotguaranteeuniqueness.KEYCOLSmaybeusedtodefinethekey.LoggingofsupplementalredodataenabledfortableSCOTT.A.技术支持服务部–单机+单机之单向OGG配置报告第15页2019-02-2211:17:40WARNINGOGG-00869Nouniquekeyisdefinedfortable'AB'.Allviablecolumnswillbeusedtorepresentthekey,butmaynotguaranteeuniqueness.KEYCOLSmaybeusedtodefinethekey.LoggingofsupplementalredodataenabledfortableSCOTT.AB.2019-02-2211:17:40WARNINGOGG-00869Nouniquekeyisdefinedfortable'B'.Allviablecolumnswillbeusedtorepresentthekey,butmaynotguaranteeuniqueness.KEYCOLSmaybeusedtodefinethekey.LoggingofsupplementalredodataenabledfortableSCOTT.B.2019-02-2211:17:40WARNINGOGG-00869Nouniquekeyisdefinedfortable'BONUS'.Allviablecolumnswillbeusedtorepresentthekey,butmaynotguaranteeuniqueness.KEYCOLSmaybeusedtodefinethekey.LoggingofsupplementalredodataenabledfortableSCOTT.BONUS.LoggingofsupplementalredodataenabledfortableSCOTT.DEPT.LoggingofsupplementalredodataenabledfortableSCOTT.EMP.2019-02-2211:17:41WARNINGOGG-00869Nouniquekeyisdefinedfortable'SALGRADE'.Allviablecolumnswillbeusedtorepresentthekey,butmaynotguaranteeuniqueness.KEYCOLSmaybeusedtodefinethekey.LoggingofsupplementalredodataenabledfortableSCOTT.SALGRADE.GGSCI(ogg1)5>2、配置抓取进程extractGGSCI(ogg1)4>addextractext_demo,tranlog,beginnow,threads1EXTRACTadded.GGSCI(ogg1)5>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTSTOPPEDEXT_DEMO00:00:0000:00:06GGSCI(ogg1)6>tranlog：表示数据抓取的来源是数据库的redo数据。beginnow：表示我们在启动这个抓取进程的就去抓取数据。threads1：表示我们数据库有多少个redothreads。3、添加队列文件GGSCI(ogg1)6>addexttrail./dirdat/r1,extractext_demo,megabytes100EXTTRAILadded.GGSCI(ogg1)7>技术支持服务部–单机+单机之单向OGG配置报告第16页./dirdat：表示trail文件的目录r1：trail文件的前缀extractext_demo：值指定给那个进程用的（ext_demo）。megabytes100：文件大小是100m4、编辑配置的ext_demo的抓取进程的参数GGSCI(ogg1)9>editparamsext_demoGGSCI(ogg1)10>viewparamsext_demoextractext_demosetenv(ORACLE_SID=ogg1)setenv(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)useridogg,passwordoggreportcountevery1minutes,ratenumfiles5000discardfile./dirrpt/ext_demo.dsc,append,megabytes1000discardrolloverat3:00exttrail./dirdat/r1,megabytes100dynamicresolutiontranlogoptionsexcludeuseroggtranlogoptionsconvertucs2clobstablescott.*;GGSCI(ogg1)11>SETENV：配置系统环境变量USERID/PASSWORD：指定OGG连接数据库的用户名和密码;REPORTCOUNT：报告已经处理的记录条数统计数字；DISCARDFILE：定义discardfile文件位置，如果处理中油记录出错会写入到此文件中；EXTTRAIL：指定写入到本地的哪个队列；TRANLOGOPTIONS：指定在解析数据库日志时所需要的特殊参数，例如：对于裸设备，可能需要加入以下参数rawdeviceoggset05、源端启动抓取进程GGSCI(ogg1)11>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTSTOPPEDEXT_DEMO00:00:0002:41:14GGSCI(ogg1)12>startext_demoSendingSTARTrequesttoMANAGER...EXTRACTEXT_DEMOstartingGGSCI(ogg1)13>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNING技术支持服务部–单机+单机之单向OGG配置报告第17页EXTRACTRUNNINGEXT_DEMO02:39:3600:00:00GGSCI(ogg1)14>2.3.3源端配置datapump进程1.配置datapump进程，将抓取数据传到目标主机。负责TCPIP通讯。GGSCI(ogg1)13>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGEXT_DEMO02:39:3600:00:00GGSCI(ogg1)14>addextractdpe_demo,exttrailsource./dirdat/r1EXTRACTadded.2.输出：目标主机怎么写，也是定义datapumo进程的输出。GGSCI(ogg1)16>addrmttrail./dirdat/t1,extractdpe_demo,megabytes100RMTTRAILadded.GGSCI(ogg1)17>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTSTOPPEDDPE_DEMO00:00:0000:01:18EXTRACTRUNNINGEXT_DEMO00:00:0000:00:05GGSCI(ogg1)18>分析：exttrailsource：抓取进程的来源，因为这个进程不否则到数据库中取抓取，所以抓取的来源是通过抓取进程已经生成好的trail文件中的内容。3.配置datapump进程参数：GGSCI(ogg1)36>editparamsdpe_demoGGSCI(ogg1)38>viewparamsdpe_demoextractdpe_demodynamicresolutionpassthru技术支持服务部–单机+单机之单向OGG配置报告第18页rmthost192.0.2.102,mgrport7839,compressrmttrail./dirdat/t1numfiles5000tablescott.*;GGSCI(ogg1)39>GGSCI(ogg1)40>startdpe_demoSendingSTARTrequesttoMANAGER...EXTRACTDPE_DEMOstartingGGSCI(ogg1)41>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGDPE_DEMO00:00:0000:14:40EXTRACTRUNNINGEXT_DEMO00:00:0000:00:09GGSCI(ogg1)42>分析：PASSTHRU：禁止extract进程与数据库交互，适用于DataPump传输进程；RMTHOST：指定目标系统及其GoldengateManager进程的端口号，还用于定义是否使用压缩进行传输；mgrport：目标主机管理进程的端口号，我们上面已经配置了。compress：在传输的过程中启用压缩。RMTTRAIL：指定写入到目标断的哪个队列；TABLEOGG_USER.*：上面说过，哪些表的redo信息传输。启动，如果有问题，状态不能为running，可以查看相应的日志在自己安装的ogghome目录下。日志所在地：[goldengate@oggsourceogg]$viggserr.log2.3.4源端测试goldengate能否抓取数据：SQL>updateemployeessetsalary=salary+1000;107rowsupdated.SQL>commit;Commitcomplete.查看是否生成文件：[oracle@gg1ogg]$lldirdattotal16-rw-rw-rw-1oracleoinstall13721Dec1203:47r1000000查看目标端是否也生成：[oracle@gg2ogg]$ls-ldirdattotal16-rw-rw-rw-1oracleoinstall13743Dec1203:47t1000000注意：是可以的,大小是非0。技术支持服务部–单机+单机之单向OGG配置报告第19页2.3.5目标端1.为replicat进程创建checkpoint表：GGSCI(ogg2)1>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGGGSCI(ogg2)2>dbloginuseridogg,passwordoggSuccessfullyloggedintodatabase.GGSCI(ogg2)3>addcheckpointtableogg.rep_demo_ckptSuccessfullycreatedcheckpointtableogg.rep_demo_ckpt.2.配置目标端replicat进程：GGSCI(ogg2)4>addreplicatrep_demo,exttrail./dirdat/t1,checkpointtableogg.rep_demo_ckptREPLICATadded.GGSCI(ogg2)5>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATSTOPPEDREP_DEMO00:00:0000:00:04exttrail：表示这个进程获取数据的来源是什么地方，是我们源端rmttrail所设置过的。3.配置目标端replicat参数：GGSCI(ogg2)6>editparamsrep_demoGGSCI(ogg2)9>viewparamsrep_demoreplicatrep_demosetenv(ORACLE_SID=ogg2)setentv(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)useridogg,passwordoggreportcountevery30minutes,ratereperrordefault,abendnumfiles5000--handlecollisionsassumetargetdefsdiscardfile./dirrpt/rep_demo.dsc,append,megabytes1000allownoopupdatesmapscott.*,targetscott.*;GGSCI(ogg2)10>技术支持服务部–单机+单机之单向OGG配置报告第20页REPLICAT进程参数配置说明：ASSUMETARGETDEFS假定两端数据结构一致使用此参数SOURCEDEFS假定两端数据结构不一致，使用此参数指定源端的数据结构定义文件，该文件需要由GlodenGate工具产生。MAP用于指定源端与目标端表的映射关系MAPEXCLUDE用于使用在MAP中使用*匹配时排除掉指定的表REPERROR定义出错以后进程的响应，一般可以定义为两种ABEND即一旦出现错误即停止复制，此为缺省配置DISCARD出现错误后继续复制，只是把错误的数据放到discard文件中。DISCARDFILE定义discardfile文件位置，如果处理中油记录出错会写入到此文件中SQLEXEC在进程运行时首先运行一个SQL语句；GROUPTRANSOPS将小交易合并成一个大的交易进行提交，减少提交次数，降低系统IO消耗MAXTRANSOPS将大交易拆分，每XX条记录提交一次4.启动目标端replicat进程rep_demo：GGSCI(ogg2)36>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATSTOPPEDREP_DEMO00:00:0000:28:58GGSCI(ogg2)37>startrep_demoSendingSTARTrequesttoMANAGER...REPLICATREP_DEMOstartingGGSCI(ogg2)38>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATRUNNINGREP_DEMO00:00:0000:00:02GGSCI(ogg2)39>技术支持服务部–单机+单机之单向OGG配置报告第21页3.单向DML同步测试1.源端ogg1做DML操作：1)ogg进程状态：GGSCI(ogg1)2>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGDPE_DEMO00:00:0000:00:00EXTRACTRUNNINGEXT_DEMO00:00:0000:00:01GGSCI(ogg1)3>2)更新ogg1库的scott.emp表：技术支持服务部–单机+单机之单向OGG配置报告第22页2.目标端ogg2，验证DML操作是否同步：1)检查进程状态GGSCI(ogg2)6>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATRUNNINGREP_DEMO00:00:0000:00:092)验证ogg2库的scott.emp表，是否同步了ogg1上scott.emp的update至此，单向dml的ogg配置完成。技术支持服务部–单机+单机之单向OGG配置报告第23页
