OracleGoldenGateConfig源端安装及配置：...........................................................................................................................................................11、安装GoldenGate及初始配置............................................................................................................................12、为源端的GoldenGate管理用户额外授权........................................................................................................43、源端添加表级的transdata.................................................................................................................................44、关于DDL复制.....................................................................................................................................................5配置源端GoldenGate进程组..........................................................................................................................................51、配置源端mgr进程.............................................................................................................................................52、配置源端extract抽取进程组............................................................................................................................62.1源端创建extract进程组............................................................................................................................62.2添加etract进程：......................................................................................................................................62.3用GGSCI命令来管理exract.....................................................................................................................63、配置pump投递进程组......................................................................................................................................63.1创建、编辑pump进程配置文件.............................................................................................................63.2添加pump进程.........................................................................................................................................73.3管理pump进程..........................................................................................................................................7目标端配置.....................................................................................................................................................................101、目标端安装及增加用户...................................................................................................................................102、配置目标端mgr进程组...................................................................................................................................123、配置replicat复制进程组.................................................................................................................................134、进行测试并调整：...........................................................................................................................................15测试复制.........................................................................................................................................................................171、重建GoldGate进行Extract+Datapump+Replicat测试.................................................................................172、进行Extract+Replicat测试..............................................................................................................................203、使用DirectLoad方法初始化数据同步...........................................................................................................214、利用exp备份初始化数据实现NC双引擎查询.............................................................................................22源端安装及配置：1、安装GoldenGate及初始配置GGSC(GoldenGateSoftwareCommandInterface)E:\haosj\ogg>ggsci-v可以查看版本E:\haosj\ogg>ggsciOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230Windowsx64(optimized),Oracle10gonApr23201204:55:04Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(NCJSZC)1>createsubdirsCreatingsubdirectoriesundercurrentdirectoryE:\haosj\oggParameterfilesE:\haosj\ogg\dirprm:alreadyexistsReportfilesE:\haosj\ogg\dirrpt:createdCheckpointfilesE:\haosj\ogg\dirchk:createdProcessstatusfilesE:\haosj\ogg\dirpcs:createdSQLscriptfilesE:\haosj\ogg\dirsql:createdDatabasedefinitionsfilesE:\haosj\ogg\dirdef:createdExtractdatafilesE:\haosj\ogg\dirdat:createdTemporaryfilesE:\haosj\ogg\dirtmp:createdStdoutfilesE:\haosj\ogg\dirout:createdGGSCI(NCJSZC)2>E:\haosj\ogg>installaddserviceService'GGMGR'created.Installprogramterminatednormally.GLOBALS文件中存的参数对全局起作用（注意GLOBALS总是大写），参数可以有mgrservname、checkpointtable、ggshema、ddltable、markertable、outputfileumask；GGSCI帮助命令GGSCI(NCJSZC)1>helpGGSCICommandSummary:Object:Command:SUBDIRSCREATEERINFO,KILL,LAG,SEND,STATUS,START,STATS,STOPEXTRACTADD,ALTER,CLEANUP,DELETE,INFO,KILL,LAG,REGISTER,SEND,START,STATS,STATUS,STOPUNREGISTEREXTTRAILADD,ALTER,DELETE,INFOGGSEVTVIEWMANAGERINFO,SEND,START,STOP,STATUSMARKERINFOPARAMSEDIT,VIEWREPLICATADD,ALTER,CLEANUP,DELETE,INFO,KILL,LAG,SEND,START,STATS,STATUS,STOPREPORTVIEWRMTTRAILADD,ALTER,DELETE,INFOTRACETABLEADD,DELETE,INFOTRANDATAADD,DELETE,INFOSCHEMATRANDATAADD,DELETE,INFOCHECKPOINTTABLEADD,DELETE,CLEANUP,INFOCommandswithoutanobject:(Database)DBLOGIN,LISTTABLES,ENCRYPTPASSWORD,FLUSHSEQUENCEMININGDBLOGIN(DDL)DUMPDDL(Miscellaneous)FC,HELP,HISTORY,INFOALL,OBEY,SETEDITOR,SHELL,SHOW,VERSIONS,!(note:youmusttypethewordCOMMANDafterthe!todisplaythe!helptopic.)i.e.:GGSCI(sys1)>help!commandForhelponaspecificcommand,typeHELP<command><object>.SQL>archiveloglist数据库日志模式非存档模式自动存档禁用存档终点D:\app\product\10.2.0\db_1\RDBMS最早的联机日志序列1461当前日志序列1463SQL>shutdownimmediate数据库已经关闭。已经卸载数据库。ORACLE例程已经关闭。SQL>startupmountORACLE例程已经启动。TotalSystemGlobalArea1258291200bytesFixedSize2003944bytesVariableSize201329688bytesDatabaseBuffers1040187392bytesRedoBuffers14770176bytes数据库装载完毕。SQL>alterdatabasearchivelog;数据库已更改。SQL>alterdatabaseopen;数据库已更改。SQL>selectsupplemental_log_data_minfromv$database;SUPPLEME--------IMPLICITSQL>SQL>alterdatabaseaddsupplementallogdata;若果上面的查询结果返回为yes或implicit则说明已经开启最小补全日志，另外如果使用ALL，PRIMARY,UNIQUE或FOREIGN补全日志时，最小补全日志会默认开启（即结果为IMPLICIT）为源端和目标端的GoldenGate管理用户授权SQL>createuserggsidentifiedbyoracledefaulttablespaceuserstemporarytablespacetemp;用户已创建。SQL>grantconnect,resource,unlimitedtablespacetoggs;授权成功。SQL>grantexecuteonutl_filetoggs;授权成功。2、为源端的GoldenGate管理用户额外授权SQL>grantconnect,resourcetoggs;授权成功。SQL>grantselectanydictionary,selectanytabletoggs;授权成功。SQL>grantalteranytabletoggs;授权成功。SQL>grantflashbackanytabletoggs;授权成功。SQL>grantexecuteondbms_flashbacktoggs;授权成功。如果对权限要求不那么严格，最简单的办法就是直接手语GoldGate管理用户dba权限：SQL>grantdbatoggs;3、源端添加表级的transdata这里表级的trandata就是指表级的supplementallog；表级的supplementallog需要在数据库级别最小supplementallog打开的情况下才起作用，如果数据库没有开启minimalsupplementallog，即使指定了表级的supplementallog，实际在redolog输出的过程中描述的记录仍只记录rowid和相关列值；同时我们现在要开启表级的trandata。添加表级的trandata可以理解为将源端的哪些schmea下的哪些表传输到目标库中，那么就需要你手动添加这些trandata。SQL>connscott/oracle已连接。SQL>createtabledemo(idnumberprimarykey,enamevarchar2(10));表已创建。GGSCI(NCJSZC)2>dbloginuseridggs,passwordoracleSuccessfullyloggedintodatabase.GGSCI(NCJSZC)3>addtrandatascott.demoLoggingofsupplementalredodataenabledfortableSCOTT.DEMO.注意：在对表添加trandata的时候，表名可以使用通配符，例如可以添加scott用户下的所有表，则语句可以这样写：GGSCI(NCJSZC)2>addtrandatascott.*4、关于DDL复制在GoldenGate10中如果使用DDL复制，则必须关闭回收站；recyclebin在10.1和10.2关闭方式稍微不同；而在最新的GoldenGate11G中使用DDL复制功能是不需要关闭recyclebin的。SQL>showparameterrecyclebinNAMETYPEVALUE----------------------------------------------------recyclebinstringon10.1中关闭时：altersystemset“_recyclebin”=false;10.2中关闭时：altersystemsetrecyclebin=off;GGSCI(haohao)7>showallParametersettings:SETSUBDIRSONSETDEBUGOFFCurrentdirectory:F:\oggUsingsubdirectoriesforallprocessfilesEditor:notepadReports(.rpt)F:\ogg\dirrptParameters(.prm)F:\ogg\dirprmReplicatCheckpoints(.cpr)F:\ogg\dirchkExtractCheckpoints(.cpe)F:\ogg\dirchkProcessStatus(.pcs)F:\ogg\dirpcsSQLScripts(.sql)F:\ogg\dirsqlDatabaseDefinitions(.def)F:\ogg\dirdef配置源端GoldenGate进程组1、配置源端mgr进程管理进程在源端、目标端都是必须有的，他负责启动GoldenGate进程，以及相关的动态进程，trail文件的管理，以及错误信息报告等等。可以在GGSCI下运行seteditor把编辑器设置为熟悉的编辑器（linux平台可以在环境变量里设置EDITOR参数来选择熟悉的编辑器）源端配置参数文件GGSCI(NCJSZC)8>editparamsmgrGGSCI(NCJSZC)9>viewparamsmgrport7500dynamicportlist7501-7505autorestartextract*,waitminutes2,retries5GGSCI(NCJSZC)10>startmgrStartingManagerasservice('GGMGR')...Servicestarted.port表示mgr进程通信的端口号（这个参数是必须的），dynamicportlist参数表示mgr进程可以为源端和目标端动态地址端口，autorestartextract表示自动重启exract进程组（每次间隔为5秒，最多尝试5此，如果没有成功则放弃）2、配置源端extract抽取进程组2.1源端创建extract进程组GGSCI(NCJSZC)7>editparamseoraGGSCI(NCJSZC)7>viewparamseoraextracteoradynamicresolutionuseridggs,passwordoraclesetenv(ORACLE_SID=ORCL)exttraile:\haosj\ogg\dirdat\ettablescott.*;extracteora表示这是个exract进程，名字为eora；dynamicresolution指的是GoldenGate动态解析源端的表名，与非动态相对应，默认GoldenGate会在一个进程启动的时候，它会到数据库查询表的属性，然后创建一个对象记录，这条记录在内存以及磁盘中维护，如果需要复制的表很多，那么创建的过程非常耗时；setenv用来设置GoldenGate操作系统的环境变量；2.2添加etract进程：在源端用addextract命令创建一个extract进程GGSCI(NCJSZC)12>addextracteora,tranlog,beginnowEXTRACTadded.用addextract命令创建本地trail文件，extract组负责写这部分文件，pump进程负责读他GGSCI(NCJSZC)13>addexttraile:\haosj\ogg\dirdat\et,extracteoraEXTTRAILadded.2.3用GGSCI命令来管理exract可以使用start、stop、add、alter、cleanup、delete、info、kill命令来管理extract进程；使用帮助查看用法，如helpaddextract3、配置pump投递进程组在源端一个数据pump进程是secondaryextract进程组；如果没有pump进程则extract进程负责把抽取来的数据投递到目标端；但是配置pump进程的好处在于保证当网络有故障的时候，能稳定没有差错的把数据投递到目标端；3.1创建、编辑pump进程配置文件配置一个名为pump_so的pump进程GGSCI(NCJSZC)14>editparamspump_soGGSCI(NCJSZC)15>viewparamspump_sopumpeoradynamicresolutionuseridggs,passwordoraclesetenv(ORACLE_SID=ORCL)exttraile:\haosj\ogg\dirdat\ettablescott.*;注意这里的useid3.2添加pump进程GGSCI(NCJSZC)16>addextractpump_so,exttrailsourcee:\haosj\ogg\dirdat\etEXTRACTadded.GGSCI(NCJSZC)17>addrmttrailf:\ogg\dirdat\pt,extractpump_soRMTTRAILadded.3.3管理pump进程GGSCI(NCJSZC)18>startpump_soGGSCI(NCJSZC)18>infoallGGSCI(NCJSZC)18>startpump_soSendingSTARTrequesttoMANAGER('GGMGR')...ERROR:openingportforMGRMGR(WSATCP/IPerror10060occurred).telnet7500是可以通的；查看日志如下异常：源端启动eora异常GGSCI(NCJSZC)5>starteoraSendingSTARTrequesttoMANAGER('GGMGR')...ERROR:openingportforMGRMGR(WSATCP/IPerror10060occurred).GGSCI(NCJSZC)6>stopmgrManagerprocessisrequiredbyotherGGSprocesses.Areyousureyouwanttostopit(y/n)?ySendingSTOPrequesttoMANAGER('GGMGR')...ERROR:openingportforMGRMGR(WSATCP/IPerror10060occurred).目标机器停止没问题GGSCI(haohao)2>stopmgrManagerprocessisrequiredbyotherGGSprocesses.Areyousureyouwanttostopit(y/n)?ySendingSTOPrequesttoMANAGER('GGMGR')...Requestprocessed.Managerstopped.在源端停止趋势杀毒后还是不行，后检查host文件映射主机名-IP关系不正确，修改后，停止正常，重启也正常。GGSCI(NCJSZC)9>stopmgrManagerprocessisrequiredbyotherGGSprocessAreyousureyouwanttostopit(y/n)?ySendingSTOPrequesttoMANAGER('GGMGR')...Requestprocessed.Managerstopped.GGSCI(NCJSZC)10>infomgrManagerisDOWN!重新启动mgr后，启动eora也正常GGSCI(NCJSZC)12>starteoraSendingSTARTrequesttoMANAGER('GGMGR')...EXTRACTEORAstartingGGSCI(NCJSZC)14>startpump_soSendingSTARTrequesttoMANAGER('GGMGR')...EXTRACTPUMP_SOstartingGGSCI(NCJSZC)15>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGEORA00:00:0000:00:04EXTRACTSTOPPEDPUMP_SO00:00:0032:41:47查看日志ggserr.log2012-11-1522:37:47INFOOGG-00992OracleGoldenGateCaptureforOracle,PUMP_SO.prm:EXTRACTPUMP_SOstarting.2012-11-1522:37:47INFOOGG-03035OracleGoldenGateCaptureforOracle,PUMP_SO.prm:OperatingsystemcharactersetidentifiedasGBK.Locale:zh_Hans_CN,LC_ALL:.2012-11-1522:37:47ERROROGG-00303OracleGoldenGateCaptureforOracle,PUMP_SO.prm:Unrecognizedparameter(pump).2012-11-1522:37:47ERROROGG-01668OracleGoldenGateCaptureforOracle,PUMP_SO.prm:PROCESSABENDING.GGSCI(NCJSZC)31>viewparamspump_sopumpeoradynamicresolutionuseridggs,passwordoraclermthost10.11.82.187500这里参数有问题修改为rmthost10.11.82.18,mgrport7500setenv(ORACLE_SID=ORCL)exttraile:\haosj\ogg\dirdat\ettablescott.*;还是无法启动pump进程修改pump_so参数为如下GGSCI(NCJSZC)47>viewparamspump_soextractpump_sodynamicresolutionuseridggs,passwordoraclermthost10.11.82.18,mgrport7500setenv(ORACLE_SID=ORCL)exttraile:\haosj\ogg\dirdat\ettablescott.*;2012-11-1522:52:33INFOOGG-03035OracleGoldenGateCaptureforOracle,PUMP_SO.prm:OperatingsystemcharactersetidentifiedasGBK.Locale:zh_Hans_CN,LC_ALL:.2012-11-1522:52:33INFOOGG-03500OracleGoldenGateCaptureforOracle,PUMP_SO.prm:WARNING:NLS_LANGenvironmentvariabledoesnotmatchdatabasecharacterset,ornotset.UsingdatabasecharactersetvalueofZHS16GBK.2012-11-1522:52:33INFOOGG-01815OracleGoldenGateCaptureforOracle,PUMP_SO.prm:VirtualMemoryFacilitiesfor:COManonalloc:MapViewOfFileanonfree:UnmapViewOfFilefilealloc:MapViewOfFilefilefree:UnmapViewOfFiletargetdirectories:E:\haosj\ogg\dirtmp.2012-11-1522:52:33WARNINGOGG-01842OracleGoldenGateCaptureforOracle,PUMP_SO.prm:CACHESIZEPERDYNAMICDETERMINATION(4G)LESSTHANRECOMMENDED:64G(64bitsystem)vmfound:4.44GCheckswapspace.Recommendedswap/extract:128G(64bitsystem).2012-11-1522:52:33ERROROGG-01044OracleGoldenGateCaptureforOracle,PUMP_SO.prm:Thetrail'e:\haosj\ogg\dirdat\et'isnotassignedtoextract'PUMP_SO'.Assignthetrailtotheextractwiththecommand"ADDEXTTRAIL/RMTTRAILe:\haosj\ogg\dirdat\et,EXTRACTPUMP_SO".2012-11-1522:52:33ERROROGG-01668OracleGoldenGateCaptureforOracle,PUMP_SO.prm:PROCESSABENDING.GGSCI(NCJSZC)4>ADDEXTTRAILe:\haosj\ogg\dirdat\et,EXTRACTPUMP_SOEXTTRAILadded.GGSCI(NCJSZC)6>startpump_soSendingSTARTrequesttoMANAGER('GGMGR')...EXTRACTPUMP_SOstartingGGSCI(NCJSZC)7>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGEORA00:00:0000:00:03EXTRACTRUNNINGPUMP_SO00:00:0000:00:01ggserr日志如下2012-11-1523:01:41INFOOGG-00993OracleGoldenGateCaptureforOracle,PUMP_SO.prm:EXTRACTPUMP_SOstarted.2012-11-1523:01:41INFOOGG-01055OracleGoldenGateCaptureforOracle,PUMP_SO.prm:Recoveryinitializationcompletedfortargetfilee:\haosj\ogg\dirdat\et000001,atRBA1062.2012-11-1523:01:41INFOOGG-01478OracleGoldenGateCaptureforOracle,PUMP_SO.prm:Outputfilee:\haosj\ogg\dirdat\etisusingformatRELEASE11.2.2012-11-1523:01:41INFOOGG-01026OracleGoldenGateCaptureforOracle,PUMP_SO.prm:Rollingoverremotefilee:\haosj\ogg\dirdat\et000001.2012-11-1523:01:41INFOOGG-01053OracleGoldenGateCaptureforOracle,PUMP_SO.prm:Recoverycompletedfortargetfilee:\haosj\ogg\dirdat\et000002,atRBA1103.2012-11-1523:01:41INFOOGG-01057OracleGoldenGateCaptureforOracle,PUMP_SO.prm:Recoverycompletedforalltargets.目标端配置1、目标端安装及增加用户F:\ogg>ggsci-vOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230Windows(optimized),Oracle10gonApr23201204:52:15GGSCI(haohao)1>createsubdirsCreatingsubdirectoriesundercurrentdirectoryF:\oggParameterfilesF:\ogg\dirprm:alreadyexistsReportfilesF:\ogg\dirrpt:createdCheckpointfilesF:\ogg\dirchk:createdProcessstatusfilesF:\ogg\dirpcs:createdSQLscriptfilesF:\ogg\dirsql:createdDatabasedefinitionsfilesF:\ogg\dirdef:createdExtractdatafilesF:\ogg\dirdat:createdTemporaryfilesF:\ogg\dirtmp:createdStdoutfilesF:\ogg\dirout:createdGGSCI(haohao)1>editparams./GLOBALSMGRSERVNAMEGGMGRGGSCHEMAggsCHECKPOINTTABLEggs.checkpointGGSCI(haohao)2>EXITF:\ogg>installaddserviceService'GGMGR'created.Installprogramterminatednormally.开启归档设置最小补全日志SQL>selectsupplemental_log_data_minfromv$database;SUPPLEMENTAL_LOG----------------NOSQL>alterdatabaseaddsupplementallogdata;数据库已更改。SQL>selectsupplemental_log_data_minfromv$database;SUPPLEMENTAL_LOG----------------YES为目标端用户授权SQL>createuserggsidentifiedbyoracledefaulttablespaceuserstemporarytablespacetemp;用户已创建。SQL>grantconnect,resource,unlimitedtablespacetoggs;授权成功。SQL>grantexecuteonutl_filetoggs;授权成功。SQL>grantinsertanytabletoggs;授权成功。SQL>grantdeleteanytabletoggs;授权成功。SQL>grantupdateanytabletoggs;授权成功。SQL>GRANTALTERANYTABLETOggs;授权成功。SQL>GRANTALTERSESSIONTOggs;授权成功。SQL>GRANTCREATESESSIONTOggs;授权成功。SQL>GRANTSELECTANYDICTIONARYTOggs;授权成功。SQL>GRANTSELECTANYTABLETOggs;授权成功。SQL>GRANTdropANYTABLETOggs;为目标端数据库添加checkpoint表GGSCI(haohao)3>dbloginuseridggs,passwordoracleSuccessfullyloggedintodatabase.GGSCI(haohao)4>addcheckpointtableggs.checkpointSuccessfullycreatedcheckpointtableggs.checkpoint.2、配置目标端mgr进程组目标端配置参数文件GGSCI(haohao)13>editparamsmgrGGSCI(haohao)14>viewparamsmgrport7500dynamicportlist7501-7505autostarter*autorestartextract*,waitminutes2,retries5lagreporthours1laginfominutes3lagcriticalminutes5purgeoldextractsf:\ogg\dirdat\rt*,usecheckpoints,minkeepdays3GGSCI(haohao)15>startmgrStartingManagerasservice('GGMGR')...Servicestarted.GGSCI(haohao)16>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNING3、配置replicat复制进程组replicat进程在目标端运行，他负责读源端抽取进程抽取的文件，然后把变化应用到目标端；GGSCI(haohao)17>editparamsreplGGSCI(haohao)18>viewparamsreplreplicatrepluseridggs,passwordoracleassumetargetdefsreperrordefault,discarddiscardfile./dirrpt/repl.dsc,append,megabytes50dynamicresolutionmapscott.*,targetscott.*;添加replicat并管理GGSCI(haohao)20>addreplicatrepl,exttrailf:\ogg\dirdat\ptERROR:NocheckpointtablespecifiedforADDREPLICAT.尝试如下操作：GGSCI(haohao)23>addcheckpointtableggs.checkpoint查看日志：ERROR:OCIErrorORA-00955:nameisalreadyusedbyanexistingobject(status=955).Creatingcheckpointtableggs.checkpoint,SQL<CREATETABLEggs.checkpoint(group_nameVARCHAR2(8)NOTNULL,group_keyNUMBER(19)NOTNULL,seqnoNUMBER(10),rbaNUMBER(19)NOTNULL,audit_tsVARCHAR2(29),create_tsDATENOTNULL,last_update_tsDATENOTNULL,current_dirVARCHAR2(255)NOTNULL,log_csnVARCHAR2(129),log_xidVARCHAR2(129),log_cmplt_csnVARCHAR2(129),log_cmplt_xidsVARCHAR2(2000),versionNUMBER(3),PRIMARYKEY(group_name,group_key))>.然后再试添加replict问题依旧，后查明添加完checkpoint后要退出一下ggsci，再进入重新添加replicat才生效。GGSCI(haohao)22>dbloginuseridggs,passwordoracleSuccessfullyloggedintodatabase.GGSCI(haohao)2>startreplSendingSTARTrequesttoMANAGER('GGMGR')...REPLICATREPLstartingGGSCI(haohao)4>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATSTOPPEDREPL00:00:0000:10:58查看日志F:\ogg\ggserr.log2012-11-1523:05:27INFOOGG-00987OracleGoldenGateCommandInterpreterforOracle:GGSCIcommand(Administrator):startrepl.2012-11-1523:05:27INFOOGG-00963OracleGoldenGateManagerforOracle,mgr.prm:CommandreceivedfromGGSCIonhosthaohao.ufida.com.cn(STARTREPLICATREPL).2012-11-1523:05:30INFOOGG-00975OracleGoldenGateManagerforOracle,mgr.prm:REPLICATREPLstarting.2012-11-1523:05:32INFOOGG-00995OracleGoldenGateDeliveryforOracle,REPL.prm:REPLICATREPLstarting.2012-11-1523:05:33INFOOGG-03035OracleGoldenGateDeliveryforOracle,REPL.prm:OperatingsystemcharactersetidentifiedasGBK.Locale:zh_Hans_CN,LC_ALL:.2012-11-1523:05:35INFOOGG-03501OracleGoldenGateDeliveryforOracle,REPL.prm:WARNING:NLS_LANGenvironmentvariableisinvalidornotset.UsingoperatingsystemcharactersetvalueofUS7ASCII.2012-11-1523:05:35ERROROGG-00665OracleGoldenGateDeliveryforOracle,REPL.prm:OCIErrordescribeforquery(status=942-ORA-00942:tableorviewdoesnotexist),SQL<SELECTdb.name,i.instance_name,i.versionFROMv$databasedb,v$instancei>.2012-11-1523:05:35ERROROGG-01668OracleGoldenGateDeliveryforOracle,REPL.prm:PROCESSABENDING.SQL>GRANTALTERANYTABLETOggs;授权成功。SQL>GRANTALTERSESSIONTOggs;授权成功。SQL>GRANTCREATESESSIONTOggs;授权成功。SQL>GRANTupdateanytableTOggs;授权成功。SQL>GRANTSELECTANYDICTIONARYTOggs;授权成功。SQL>GRANTSELECTANYTABLETOggs;授权成功。SQL>GRANTdropANYTABLETOggs;再启动repl进程，成功GGSCI(haohao)15>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATRUNNINGREPL00:00:0000:00:07再查看日志：2012-11-1523:22:52INFOOGG-00963OracleGoldenGateManagerforOracle,mgr.prm:CommandreceivedfromGGSCIonhosthaohao.ufida.com.cn(STARTREPLICATREPL).2012-11-1523:22:54INFOOGG-00975OracleGoldenGateManagerforOracle,mgr.prm:REPLICATREPLstarting.2012-11-1523:22:56INFOOGG-00995OracleGoldenGateDeliveryforOracle,REPL.prm:REPLICATREPLstarting.2012-11-1523:22:57INFOOGG-03035OracleGoldenGateDeliveryforOracle,REPL.prm:OperatingsystemcharactersetidentifiedasGBK.Locale:zh_Hans_CN,LC_ALL:.2012-11-1523:22:59INFOOGG-03501OracleGoldenGateDeliveryforOracle,REPL.prm:WARNING:NLS_LANGenvironmentvariableisinvalidornotset.UsingoperatingsystemcharactersetvalueofUS7ASCII.2012-11-1523:22:59INFOOGG-01815OracleGoldenGateDeliveryforOracle,REPL.prm:VirtualMemoryFacilitiesfor:COManonalloc:MapViewOfFileanonfree:UnmapViewOfFilefilealloc:MapViewOfFilefilefree:UnmapViewOfFiletargetdirectories:F:\ogg\dirtmp.2012-11-1523:23:00INFOOGG-00996OracleGoldenGateDeliveryforOracle,REPL.prm:REPLICATREPLstarted.4、进行测试并调整：SQL>createtabledemo(idnumberprimarykey,enamevarchar2(10));SQL>selectcount(*)fromuser_tables;COUNT(*)----------5源端SQL>insertintodemovalues(10,'hello');已创建1行。SQL>commit;提交完成。SQL>select*fromdemo;IDENAME--------------------10helloGGSCI(NCJSZC)25>viewreporteoraBoundedRecoveryParameter:BRINTERVAL=4HOURSBRDIR=E:\haosj\ogg2012-11-2321:28:49INFOOGG-01815VirtualMemoryFacilitiesfor:COManonalloc:MapViewOfFileanonfree:UnmapViewOfFilefilealloc:MapViewOfFilefilefree:UnmapViewOfFiletargetdirectories:E:\haosj\ogg\dirtmp.CACHEMGRvirtualmemoryvalues(mayhavebeenadjusted)CACHESIZE:4GCACHEPAGEOUTSIZE(normal):8MPROCESSVMAVAILFROMOS(min):4.75GCACHESIZEMAX(strictforcetodisk):4.47G2012-11-2321:28:53INFOOGG-01517PositionoffirstrecordprocessedSequence1472,RBA9979920,SCN0.16219879,2012-11-16下午09:12:19.2012-11-2321:28:53INFOOGG-00732Foundcrashrecoverymarkerfromthread#1onsequence1473atRBA1040.Abortinguncommittedtransactions.2012-11-2321:29:04INFOOGG-00732Foundcrashrecoverymarkerfromthread#1onsequence1480atRBA1040.Abortinguncommittedtransactions.2012-11-2321:29:20INFOOGG-00732Foundcrashrecoverymarkerfromthread#1onsequence1487atRBA43686928.Abortinguncommittedtransactions.2012-11-2321:28:58INFOOGG-01053Recoverycompletedfortargetfilee:\haosj\ogg\dirdat\et000005,atRBA1103.2012-11-2321:28:58INFOOGG-01057Recoverycompletedforalltargets.*************************************************************************RunTimeMessages*************************************************************************Openedtrailfilee:\haosj\ogg\dirdat\et000003at2012-11-2321:28:58Switchingtonexttrailfilee:\haosj\ogg\dirdat\et000004at2012-11-2321:28:58duetoEOF,withcurrentRBA8507464Openedtrailfilee:\haosj\ogg\dirdat\et000004at2012-11-2321:28:58Switchingtonexttrailfilee:\haosj\ogg\dirdat\et000005at2012-11-2321:28:58duetoEOF,withcurrentRBA1062Openedtrailfilee:\haosj\ogg\dirdat\et000005at2012-11-2321:28:58GGSCI(NCJSZC)36>editparamspump_soGGSCI(NCJSZC)37>viewparamspump_soextractpump_sodynamicresolutionuseridggs,passwordoraclermthost10.11.82.18,mgrport7500setenv(ORACLE_SID=ORCL)rmttrailf:\ogg\dirdat\ettablescott.*;查看日志：vmfound:4.69GCheckswapspace.Recommendedswap/extract:128G(64bitsystem).2012-11-2322:29:25ERROROGG-01044OracleGoldenGateCaptureforOracle,PUMP_SO.prm:Thetrail'f:\ogg\dirdat\et'isnotassignedtoextract'PUMP_SO'.Assignthetrailtotheextractwiththecommand"ADDEXTTRAIL/RMTTRAILf:\ogg\dirdat\et,EXTRACTPUMP_SO".2012-11-2322:29:25ERROROGG-01668OracleGoldenGateCaptureforOracle,PUMP_SO.prm:PROCESSABENDING.GGSCI(NCJSZC)42>ADDRMTTRAILf:\ogg\dirdat\et,EXTRACTPUMP_SORMTTRAILadded.GGSCI(NCJSZC)44>startpump_soSendingSTARTrequesttoMANAGER('GGMGR')...EXTRACTPUMP_SOstartingGGSCI(NCJSZC)45>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGEORA00:00:0000:00:03EXTRACTRUNNINGPUMP_SO00:00:0000:07:57目标端日志：2012-11-2316:24:19INFOOGG-00996OracleGoldenGateDeliveryforOracle,REPL.prm:REPLICATREPLstarted.2012-11-2322:32:14INFOOGG-00963OracleGoldenGateManagerforOracle,mgr.prm:CommandreceivedfromEXTRACTonhost10.11.82.27(STARTSERVERCPU-1PRI-1TIMEOUT300PARAMS).2012-11-2322:32:16INFOOGG-01677OracleGoldenGateCollectorforOracle:Waitingforconnection(starteddynamically).2012-11-2322:32:16INFOOGG-00963OracleGoldenGateManagerforOracle,mgr.prm:CommandreceivedfromSERVERonhostlocalhost(REPORT79527501).2012-11-2322:32:16INFOOGG-00974OracleGoldenGateManagerforOracle,mgr.prm:Managerstartedcollectorprocess(Port7501).2012-11-2322:32:16INFOOGG-01228OracleGoldenGateCollectorforOracle:Timeoutin300seconds.2012-11-2322:32:21INFOOGG-01229OracleGoldenGateCollectorforOracle:Connectedto:3297.2012-11-2322:32:21INFOOGG-01669OracleGoldenGateCollectorforOracle:Openingf:\ogg\dirdat\et000000(byte-1,currentEOF0).测试复制1、重建GoldGate进行Extract+Datapump+Replicat测试1-1）删除进程pump日志报错无法正常提取文件2012-12-1519:51:15ERROROGG-01496Failedtoopentargettrailfilef:\ogg\dirdat\et000008,atRBA1462.2012-12-1519:51:15ERROROGG-01668PROCESSABENDING.ext日志2012-12-1519:49:55ERROROGG-01496Failedtoopentargettrailfilee:\haosj\ogg\dirdat\et000011,atRBA1062.2012-12-1519:49:55ERROROGG-01668PROCESSABENDING.删除源端原有的进程：--先登录goldengate，否则删除的时候会有下面的权限提示GGSCI(NCJSZC)121>dbloginuseridggs,passwordoracleSuccessfullyloggedintodatabase.GGSCI(NCJSZC)117>deleteextracteora2012-12-1520:06:09WARNINGOGG-01753CannotunregisterEXTRACTEORAfromdatabasebecausenodatabaseloginwasprovided.YoucanmanuallyunregouplaterwiththeUNREGISTEREXTRACTcommandwithLOGRETENTION.IssueDBLOGINfirst.DeletedEXTRACTEORA.GGSCI(NCJSZC)118>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTABENDEDPUMP_SO00:00:0000:22:37GGSCI(NCJSZC)119>deleteextractpump_so2012-12-1520:06:22WARNINGOGG-01753CannotunregisterEXTRACTPUMP_SOfromdatabasebecausenodatabaseloginwasprovided.YoucanmanuallyungrouplaterwiththeUNREGISTEREXTRACTcommandwithLOGRETENTION.IssueDBLOGINfirst.DeletedEXTRACTPUMP_SO.GGSCI(NCJSZC)120>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGGGSCI(UF20O9O1071)67>infoallPr...
