ogg单机同步复制操作手册

概要信息1.1文档介绍该文档重要用于指导运用OGG来进行数据的同时复制，其中源数据库为单机，目的数据库为单机。OGG有关安装软件版本为12c，重要涉及以下：OGG，重要用于源库与目的库的数据同时OGGVeridata，重要用于同时数据校验温馨提示：请认真阅读该文档注意事项！1.2机器环境1.2.1源机器信息操作系统版本Redhat6.4数据库版本11.2.0.4.0主机名oggsrcIP地址192.168.1.1861.2.2目的机器信息操作系统版本Redhat6.4集群数据库版本11.2.0.4.0主机名oggtgtIP地址192.168.1.1871.3软件环境软件名称软件版本布署节点备注OracleGoldenGate12.2.0.1.1oggsrc（源库）

oggtgt（目的库）OracleADR12.2.1.0.0oggsrc（源库）

oggtgt（目的库）JDK1.8oggsrc（源库）

oggtgt（目的库）1.4软件包信息软件名称软件包名称OracleGoldenGate12fbo_ggs_Linux_x64_shiphome.zipOracleApplicationDevelopmentRuntimeInfrastructure（ADR）fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zipJDKjdk-8u112-linux-x64.rpm1.5注意事项--软件安装：对于RAC的OGG，有三种方式选择:1.oracle推荐直接安装在共享文献系统上（共享存储/OCFS/AFS）；2.也能够安装在RAC全部节点的本地目录，但必需确保全部节点的安装途径一致；3.还能够只安装其中一种节点，但必需确保安装OGG的节点能够访问其它节点的归档目录(本文档使用)--有关归档本文档中，源库归档目录为本地目录--有关IP配备：RAC上的VIP必需为固定IP且与管理IP是同一网段，不能够是DHCP获取--有关主机hosts表安装过程中涉及到的主机名及IP对应关系都配备到每台主机的hosts表中--有关时间同时：全部节点必需配有时间同时功效确保全部节点的操作系统时间一致，由于OGG的EXTRACT进程是通过对比commit时间（即操作系统时间）来决定与否传输有关的数据--有关COMPATIBLE：确保全部节点的数据库COMPATIBLE参数已经设立--OGG数据寄存途径将OGG数据寄存途径mount在单边，避免相似的进程在其它节点启动引发进程冲突--源库数据对象与否支持OGG对数据对象支持有一定的限制，能够通过脚本提前检查--有关数据迁移方式本文档推荐使用数据泵方式进行数据迁移，因此需要提前将目的数据库建好OGG搭建环境准备2.1源库操作2.1.1启动归档--归档目录为全部节点共享目录--节点SQL>altersystemsetlog_archive_dest_1='location=/arch'scope=spfilesid='*';Systemaltered.SQL>altersystemsetrecyclebin=offscope=spfile;--ForanOracle10gsource,thesystemrecyclebinmustbedisabled.ForOracle11gandlater,itcanbeenabled.Systemaltered.SQL>shutdownimmediateOGGSRC:/home/oracle$exportORACLE_SID=oggsrcOGGSRC:/home/oracle$sqlplus/assysdbaSQL*Plus:Release11.2.0.1.0-ProductiononMonSep1916:29:11Copyright(c)1982,,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupmount;ORACLEinstancestarted.TotalSystemGlobalAreabytesFixedSize2160600bytesVariableSizebytesDatabaseBuffersbytesRedoBuffers12206080bytesDatabasemounted.SQL>alterdatabasearchivelog;Databasealtered.SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/archOldestonlinelogsequence4Nextlogsequencetoarchive7Currentlogsequence7SQL>alterdatabaseopen;Databasealtered.SQL>altersystemarchivelogcurrent;Systemaltered.2.1.2启动附加日志功效和force_logging--节点SQL>SELECTsupplemental_log_data_min,force_loggingFROMv$database;SUPPLEMEFOR-----------NONOSQL>ALTERDATABASEADDSUPPLEMENTALLOGDATA;Databasealtered.SQL>alterdatabaseforcelogging;Databasealtered.SQL>SELECTsupplemental_log_data_min,force_loggingFROMv$database;SUPPLEMEFOR-----------YESYESSQL>ALTERSYSTEMSETENABLE_GOLDENGATE_REPLICATION=TRUESCOPE=BOTH;Systemaltered.2.2目的库操作2.2.1启动归档（可不必打开）--节点，归档目录/arch非共享SQL>altersystemsetlog_archive_dest_1='location=/arch'scope=spfilesid='*';Systemaltered.$exportORACLE_SID=oggtgt$sqlplus/assysdbaSQL>startupmount;ORACLEinstancestarted.TotalSystemGlobalAreabytesFixedSize2160600bytesVariableSizebytesDatabaseBuffersbytesRedoBuffers12206080bytesDatabasemounted.SQL>alterdatabasearchivelog;Databasealtered.SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/archOldestonlinelogsequence4Nextlogsequencetoarchive7Currentlogsequence7SQL>alterdatabaseopen;Databasealtered.SQL>altersystemarchivelogcurrent;Systemaltered.2.2.2启动参数ENABLE_GOLDENGATE_REPLICATION//11.2.0.4版本的必须设立该参数为trueSQL>ALTERSYSTEMSETENABLE_GOLDENGATE_REPLICATION=TRUESCOPE=BOTH;Systemaltered.OGG搭建3.1OGG软件安装--此处只在源库节点xxxx和目的库节点xxxx上操作，其它节点不操作！此处只以xxx为例！3.1.1创立OGG目录--节点[root@oggsrcmedia]#mkdir-p/u01/ogg/dirdat[root@oggsrcmedia]#chown-Roracle:oinstall/u01/ogg[root@oggsrcmedia]#chmod-R775/u01/ogg[root@oggsrcmedia]#su-oracle3.1.2配备OGG顾客环境变量--此处用oracle顾客安装OGG添加或修改oracle顾客环境变量exportOGG_HOME=/u01/oggexportPATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$OGG_HOMEexportLIBPATH=$ORACLE_HOME/lib:$OGG_HOME3.1.3安装OGG软件[oracle@oggsrc~]$cd/u01/media/[oracle@oggsrcmedia]$ls-lrttotal4616920drwxr-xr-x7oracleoinstall4096Aug26database-rw-r--r--.1oracleoinstallJul1820:43p13390677_112040_Linux-x86-64_2of7.zip-rw-r--r--.1oracleoinstallJul1820:44p13390677_112040_Linux-x86-64_1of7.zip-rw-r--r--1oracleoinstallJul1823:55fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip-rw-r--r--1oracleoinstallJul1900:00fbo_ggs_Linux_x64_shiphome.zip-rw-r--r--1oracleoinstallJul1900:04jdk-8u112-linux-x64.rpm-rw-r--r--1oracleoinstall210877Jul1905:55pdksh-5.2.14-37.el5_8.1.x86_64.rpm-rw-------1oracleoinstall4194304Jul1906:10core[oracle@oggsrcmedia]$unzip-qfbo_ggs_Linux_x64_shiphome.zip[oracle@oggsrcmedia]$cdfbo_ggs_Linux_x64_shiphome$cdDisk1$lsinstallresponserunInstallerstageOGGSRC:/u01/media/fbo_ggs_AIX_ppc_shiphome/Disk1$./runInstaller3.2源库OGG配备--配备OGG全部用oracle顾客去操作！3.2.1创立OGG应用子目录OGGSRC:/home/oracle$cd/u01/oggOGGSRC:/u01/ogg$ggsciOracleGoldenGateCommandInterpreterforOracleVersion12.2.0.1.1OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBOAIX6,ppc,64bit(optimized),Oracle11gonJan2109:52:07OperatingsystemcharactersetidentifiedasISO-8859-1.Copyright(C)1995,,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(OGGSRC)1>createsubdirsCreatingsubdirectoriesundercurrentdirectory/u01/oggParameterfiles/u01/ogg/dirprm:alreadyexistsReportfiles/u01/ogg/dirrpt:createdCheckpointfiles/u01/ogg/dirchk:createdProcessstatusfiles/u01/ogg/dirpcs:createdSQLscriptfiles/u01/ogg/dirsql:createdDatabasedefinitionsfiles/u01/ogg/dirdef:createdExtractdatafiles/u01/ogg/dirdat:createdTemporaryfiles/u01/ogg/dirtmp:createdStdoutfiles/u01/ogg/dirout:createdGGSCI(OGGSRC)2>exit3.2.2创立OGG顾客OGGSRC:/u01/ogg$sqlplus/assysdbaSQL>createtablespaceoggdatafile'/oradata/oggsrc/ogg01.dbf'size2G;Tablespacecreated.SQL>createuseroggidentifiedbyoggdefaulttablespaceoggtemporarytablespacetempaccountunlock;Usercreated.SQL>grantdbatoogg;Grantsucceeded.3.2.3授权OGG顾客OGGSRC:/u01/ogg$sqlplus/assysdbaSQL>grantexecuteonutl_filetoogg;Grantsucceeded.==SQL>@/u01/ogg/marker_setup.sqlEnterOracleGoldenGateschemaname:oggScriptcomplete.==SQL>@/u01/ogg/ddl_setup.sqlEnterOracleGoldenGateschemaname:oggSTATUSOFDDLREPLICATION------------------------------------------------------------------------------------------------------------------------SUCCESSFULinstallationofDDLReplicationsoftwarecomponentsScriptcomplete.==SQL>@/u01/ogg/role_setup.sqlEnterGoldenGateschemaname:oggRolesetupscriptcompleteGRANTGGS_GGSUSER_ROLETO<loggedUser>==SQL>grantggs_ggsuser_roletooggtgt;Grantsucceeded.==SQL>@/u01/ogg/ddl_enable.sqlTriggeraltered.==SQL>@/u01/ogg/marker_status.sqlPleaseenterthenameofaschemafortheGoldenGatedatabaseobjects:oggSettingschemanametoOGGMARKERTABLE-------------------------------OKMARKERSEQUENCE-------------------------------OK==SQL>@?/rdbms/admin/dbmspoolPackagecreated.Grantsucceeded.==SQL>@/u01/ogg/ddl_pin.sqloggPL/SQLproceduresuccessfullycompleted.PL/SQLproceduresuccessfullycompleted.PL/SQLproceduresuccessfullycompleted.==SQL>@/u01/ogg/sequence.sqlPleaseenterthenameofaschemafortheGoldenGatedatabaseobjects:SettingschemanametoOGGSTATUSOFSEQUENCESUPPORT--------------------------------------------------------------SUCCESSFULinstallationofOracleSequenceReplicationsupport==SQL>grantexecuteonoggtgt.updatesequencetooggtgt;Grantsucceeded.3.2.4创立GLOBALS文献OGGSRC:/u01/ogg/dirdat$cd$OGG_HOMEOGGSRC:/u01/ogg$ggsciOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230AIX5L,ppc,64bit(optimized),Oracle11gonApr2305:03:51Copyright(C)1995,,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(OGGSRC)20>editparams./GLOBALS##输入以下内容##GGSCHEMAogg3.2.5创立Manager配备文献##编辑MGR配备文献，GGSCI(OGGSRC)1>editparamsmgr##输入以下内容##PORT7809DYNAMICPORTLIST7810-7820,7830AUTOSTARTEXTRACT*AUTORESTARTEXTRACT*,RETRIES4,WAITMINUTES2STARTUPVALIDATIONDELAY5PURGEOLDEXTRACTS/u01/ogg/dirdat/*,USECHECKPOINTS,minkeepdays73.2.6创立primaryExtract配备文献GGSCI(OGGSRC)9>editparamsexee##输入以下内容##EXTRACTexeeSETENV(ORACLE_SID="oggsrc")SETENV(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)SETENV(NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")USERIDogg,PASSWORDoggWARNLONGTRANS2h,CHECKINTERVAL300sFETCHOPTIONSNOUSESNAPSHOTexttrail/u01/ogg/dirdat/ltdiscardfile/u01/ogg/dirrpt/ee.dsc,append,megabytes500gettruncatesddl&includeobjnameMESIF.*&includeobjnameAHBIUSR.*&includeobjtype'USER'ddloptionsaddtrandatatableMESIF.*;sequenceMESIF.*;tableAHBIUSR.*;sequenceAHBIUSR.*;##检查确认EXEE配备文献内容无误OGGSRC:/u01/ogg$/u01/ogg/checkprm/u01/ogg/dirprm/exee.prm-Cextract-mClassic-V3.2.7创立datapump配备文献GGSCI(OGGSRC)9>editparamsdpee##输入以下内容##EXTRACTdpeeSETENV(ORACLE_SID="oggsrc")SETENV(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)SETENV(NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")RMTHOST192.168.1.187,MGRPORT7809,compressRMTTRAIL/u01/ogg/dirdat/rtgettruncatestableMESIF.*;sequenceMESIF.*;tableAHBIUSR.*;sequenceAHBIUSR.*;##检查确认DPEE配备文献内容无误OGGSRC:/u01/ogg/checkprm/u01/ogg/dirprm/dpee.prm-Cextract-mClassic-V3.2.8为需要抽取数据的schema增加trandata##此步根据对象表数量的多少需要对应的时间，GGSCI(OGGSRC)13>dbloginuseridoggpasswordoggSuccessfullyloggedintodatabase.GGSCI(OGGSRC)14>addtrandataMESIF.*GGSCI(OGGSRC)14>addtrandataAHBIUSR.*3.2.9配备extract进程GGSCI(OGGSRC)15>addextexee,tranlog,beginnowEXTRACTadded.GGSCI(OGGSRC)16>addexttrail/u01/ogg/dirdat/lt,extexee,megabytes50EXTTRAILadded.3.2.10配备datapump进程GGSCI(OGGSRC)17>addextdpee,exttrailsource/u01/ogg/dirdat/ltEXTRACTadded.GGSCI(OGGSRC)19>addrmttrail/u01/ogg/dirdat/rt,extdpee,megabytes50RMTTRAILadded.3.3目的库OGG配备--配备OGG全部用oracle顾客去操作！3.3.1创立OGG应用子目录oggtgt:/home/oracle$cd/u01/oggoggtgt:/u01/ogg$ggsciOracleGoldenGateCommandInterpreterforOracleVersion12.2.0.1.1OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBOAIX6,ppc,64bit(optimized),Oracle11gonJan2109:52:07OperatingsystemcharactersetidentifiedasISO-8859-1.Copyright(C)1995,,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(oggtgt)1>createsubdirsCreatingsubdirectoriesundercurrentdirectory/u01/oggParameterfiles/u01/ogg/dirprm:alreadyexistsReportfiles/u01/ogg/dirrpt:createdCheckpointfiles/u01/ogg/dirchk:createdProcessstatusfiles/u01/ogg/dirpcs:createdSQLscriptfiles/u01/ogg/dirsql:createdDatabasedefinitionsfiles/u01/ogg/dirdef:createdExtractdatafiles/u01/ogg/dirdat:createdTemporaryfiles/u01/ogg/dirtmp:createdStdoutfiles/u01/ogg/dirout:createdGGSCI(oggtgt)2>3.3.2创立OGG顾客oggtgt:/home/oracle$sqlplus/assysdbaSQL>createtablespaceoggtgtdatafile'/oradata/oggtgt/ogg01.dbf'size2G;Tablespacecreated.SQL>createuseroggidentifiedbyoggdefaulttablespaceoggtemporarytablespacetempaccountunlock;Usercreated.SQL>grantdbatoogg;Grantsucceeded.3.3.3授权OGG顾客oggtgt:/u01/ogg$sqlplus/assysdba==SQL>@/u01/ogg/sequence.sqlPleaseenterthenameofaschemafortheGoldenGatedatabaseobjects:SettingschemanametoOGGSTATUSOFSEQUENCESUPPORT--------------------------------------------------------------SUCCESSFULinstallationofOracleSequenceReplicationsupport==SQL>grantexecuteonogg.replicatesequencetoogg;Grantsucceeded.3.3.4创立GLOBALS配备文献oggtgt:/u01/ogg/dirdat$cd$OGG_HOMEoggtgt:/u01/ogg$ggsciGGSCI(oggtgt)2>editparams./GLOBALS##输入以下内容##GGSCHEMAoggCHECKPOINTTABLEogg.ckpttable3.3.5创立Manager配备文献##编辑MGR配备文献GGSCI(oggtgt)3>editparamsmgr##输入以下内容##PORT7809DYNAMICPORTLIST7810-7820,7830AUTOSTARTREPLICAT*AUTORESTARTREPLICAT*,RETRIES4,WAITMINUTES2STARTUPVALIDATIONDELAY5PURGEOLDEXTRACTS/u01/ogg/dirdat/*,USECHECKPOINTS,minkeepdays73.3.6添加checkpointtableGGSCI(oggtgt)5>DBLOGINUSERIDogg,PASSWORDoggSuccessfullyloggedintodatabase.GGSCI(oggtgt)6>ADDCHECKPOINTTABLEogg.ckpttableSuccessfullycreatedcheckpointtableogg.ckpttable.3.3.7创立replicat配备文献GGSCI(oggtgt)8>editparamsrpee##输入以下内容##REPLICATrpeeSETENV(ORACLE_SID="oggtgt")SETENV(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)SETENV(NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")USERIDogg,PASSWORDogg--handlecollisionsassumetargetdefsallownoopupdatesdiscardfile/u01/ogg/dirrpt/ee.dsc,append,megabytes500gettruncatesddl&includeobjnameMESIF.*&includeobjnameAHBIUSR.*&includeobjtype'USER'DBOPTIONSDEFERREFCONSTmapMESIF.*,targetMESIF.*;mapAHBIUSR.*,targetAHBIUSR.*;##确认RPEE配备文献内容oggtgt:/u01/ogg$/u01/ogg/checkprm/u01/ogg/dirprm/rpee.prm-Creplicat-mClassic-V3.3.8配备replicat进程GGSCI(oggtgt)9>addreprpee,exttrail/u01/ogg/dirdat/rtCHECKPOINTTABLEogg.ckpttableREPLICATadded.3.4测试启动OGG--配备OGG全部用oracle顾客去操作！3.4.1目的库启动OGGGGSCI(oggtgt)9>startmgrManagerstarted.GGSCI(oggtgt)11>startreplicatrpeeREPLICATRPEEisalreadyrunning.GGSCI(oggtgt)12>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATRUNNINGRPEE00:00:0000:00:06--等待章节3.4.2的DPEE进程启动正常后，关闭REPLICATrpeeGGSCI(oggtgt)13>stopreplicatrpee3.4.2源库启动OGGGGSCI(OGGSRC)17>startmgrManagerstarted.GGSCI(OGGSRC)18>infomgrManagerisrunning(IPportOGGSRC.7809).GGSCI(OGGSRC)68>startEXTRACTexeeSendingSTARTrequesttoMANAGER...EXTRACTEXEEstartingGGSCI(OGGSRC)69>startEXTRACTdpeeSendingSTARTrequesttoMANAGER...EXTRACTDPEEstartingGGSCI(OGGSRC)1>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGDPEE00:00:0000:00:03EXTRACTRUNNINGEXEE00:00:0000:00:10此处不要关闭EXEE进程！迁移数据4.1数据泵方式4.1.1源库创立数据泵目录OGGSRC:/home/oracle$exportORACLE_SID=oggsrcOGGSRC:/home/oracle$sqlplus/assysdbaSQL>createorreplacedirectoryexpdpas'/u01/expdp';Directorycreated.SQL>grantread,writeondirectoryexpdptopublic;Grantsucceeded.SQL>colownerfora15SQL>coldirectory_namefora15SQL>coldirectory_pathfora25SQL>select*fromdba_directorieswheredirectory_name='EXPDP';OWNERDIRECTORY_NAMEDIRECTORY_PATH-------------------------------------------------------SYSEXPDP/u01/expdp4.1.2源库获取数据库现在SCNSQL>selectdbms_flashback.get_system_change_numberfromdual;GET_SYSTEM_CHANGE_NUMBER------------------------3867034.1.3源库基于SCN号导出数据nohupexpdpMESPRD/MESPRDdirectory=expdirschemas=AHBIUSR,MESERP,MESBIGDATA,MESDMZTMP,MONITORUSER,MESPTS,MESWMS,MESIFdumpfile=mes%U.dmpjob_name=expdpmesparallel=4filesize=7Gflashback_scn=386703COMPRESSION=alllogfile=expdpmes.log&4.1.4目的库创立数据泵目录oggtgt:/home/oracle$sqlplus/assysdbaSQL>createorreplacedirectoryimpdpas'/u01/impdir';Directorycreated.SQL>grantread,writeondirectoryimpdptopublic;Grantsucceeded.SQL>select*fromdba_directorieswheredirectory_name='IMPDP';SQL>colownerfora15SQL>coldirectory_namefora15SQL>coldirectory_pathfora25SQL>select*fromdba_directorieswheredirectory_name='EXPDP';OWNERDIRECTORY_NAMEDIRECTORY_PATH-------------------------------------------------------SYSEXPDP/u01/expdp4.1.5目的库导入数据把有关的dmp文献，导出日志文献从源库拷贝至目的库机器oggtgt上,导入脚本以下：exportORACLE_SID=oggtgtexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1exportPATH=$ORACLE_HOME/bin:$PATHnohupimpdpsystem/oracleoradirectory=expdpdumpfile=mes%U.dmpschemas=AHBIUSR,MESERP,MESBIGDATA,MESDMZTMP,MONITORUSER,MESPTS,MESWMS,MESIFlogfile=impdpmes.logparallel=4job_name=impdpmescluster=N&4.1.6目的库匹配导入导出数据行数oggtgt:/u01/expdp$grep"rows"expdpmes.log|sort-n|awk'{print$4,$7,$8}'>/tmp/exp.aoggtgt:/u01/expdp$grep"rows"impdpmes.log|sort-n|awk'{print$4,$7,$8}'>/tmp/imp.boggtgt:/u01/expdp$diff/tmp/exp.a/tmp/imp.b#此时没有成果输出阐明导入导出数据行数一致目的库启动OGG同时5.1禁用目的库触发器#参数owner_list里面的顾客名请根据实际状况修改#禁用约束脚本以下：oggtgt:/home/oracle/ogg$catdisable_cascade.sqlsetserveroutputonsize1000000spool/home/oracle/disable_cascade.logdefineowner_list="in('AHBIUSR','MESIF')"declarecursorcisSELECTA.OWNER,A.TABLE_NAME,A.CONSTRAINT_NAME,C.COLUMN_NAME,A.STATUS,A.DELETE_RULE,B.TABLE_NAMEREFER_TABLEFROMdba_CONSTRAINTSA,dba_CONSTRAINTSB,dba_CONS_COLUMNSCWHEREA.R_CONSTRAINT_NAME=B.CONSTRAINT_NAMEANDA.CONSTRAINT_NAME=C.CONSTRAINT_NAMEANDA.status='ENABLED'ANDA.delete_rulelike'%CASCADE%'andA.owner&owner_list;tempvarchar2(512);begindbms_output.put_line('--BEGINALTERTABLEDISABBLECASCADE--');dbms_output.put_line('--WAITFORAMONENT--');dbms_output.put_line('--...................--');forxinclooptemp:='ALTERTABLE"'||x.OWNER||'"."'||x.TABLE_NAME||'"DISABLECONSTRAINT"'||x.CONSTRAINT_NAME||'"';executeimmediatetemp;dbms_output.put_line('--DISABLECONSTRAINT'||x.OWNER||'.'||x.CONSTRAINT_NAME||'SUCCESSFUL--');endloop;dbms_output.put_line('--ENDALTERTABLEDISABBLECASCADE--');end;/spooloff5.2禁用目的库约束#参数owner_list里面的顾客名请根据实际状况修改#禁用触发器脚本以下：setserveroutputonsize1000000spool/home/oracle/disable_trigger.logdefineowner_list="in('AHBIUSR','MESIF')"declarecursorcisSELECTOWNER,TRIGGER_NAMEFROMdba_triggersWHEREstatus='ENABLED'andowner&owner_list;tempvarchar2(512);begindbms_output.put_line('--BEGINDISABBLETRIGGERS--');dbms_output.put_line('--WAITFORAMONENT--');dbms_output.put_line('--...................--');forxinclooptemp:='ALTERTRIGGER"'||x.OWNER||'"."'||x.TRIGGER_NAME||'"DISABLE';executeimmediatetemp;dbms_output.put_line('--DISABLETRIGGER'||x.OWNER||'.'||x.TRIGGER_NAME||'SUCCESSFUL--');endloop;dbms_output.put_line('--ENDALTERTABLEDISABBLETRIGGERS--');end;/spooloff5.3启动同时GGSCI(oggtgt)16>startrpee,aftercsn386703SendingSTARTrequesttoMANAGER...REPLICATRPEEstarting5.4测试同时状况--此处在AHBIUSR顾客下单独创立了一张测试表throldSQL>createtableahbiusr.throld(idintprimarykey,namevarchar(15)notnull);SQL>insertintoahbiusr.throldvalues(1,'A');1rowcreated.SQL>insertintoahbiusr.throldvalues(2,'B');1rowcreated.SQL>insertintoahbiusr.throldvalues(3,'C');1rowcreated.SQL>commit;--节点OGGSRCSQL>select*fromahbiusr.throld; IDNAME----------------------------------- 1A 2B 3C--节点oggtgtSQL>select*fromahbiusr.throld; IDNAME------------------------------------------------------- 1A 2B 3C--节点oggsrcSQL>updateahbiusr.throldsetname='G'whereid=1;--节点oggtgtSQL>select*fromahbiusr.throldwhereid=1; IDNAME------------------------------------------------------- 1G--节点OGGSRCSQL>truncatetableahbiusr.throld;Tabletruncated.SQL>select*fromahbiusr.throld;norowsselected--节点oggtgtSQL>select*fromahbiusr.throld;norowsselectedOGG同时测试6.1测试环境账号信息原始数据源数据库信息192.168.1.186:1521/oggsrcOracle服务器顾客账号/密码oracle/oracleoraOracle数据库管理员账号/密码MESDMZTMP/mesdmztmp#VNC端口/密码192.168.1.186:2/Ht1234目的数据源数据库信息192.168.1.187:1521/oggsrcOracle服务器顾客账号/密码oracle/oracleoraOracle数据库管理员账号/密码MESDMZTMP/mesdmztmp#VNC端口/密码192.168.1.186:2/Ht1234注：log日志途径：/u01/ogg/ggserr.log6.2测试场景6.2.1基本同时功效:建表、增删改原始库建表：createtableahbiusr.throld(idintprimarykey,namevarchar(15)notnull);2）插入数据： insertintoahbiusr.throldvalues(1,'A');insertintoahbiusr.throldvalues(2,'B');commit;3）原始库数据： select*fromahbiusr.throld; 4）目的库数据查询： select*fromahbiusr.throld; 5）原始库修改数据： updateahbiusr.throldsetname='C'; commit;6)原始库数据查询： select*fromahbiusr.throld; 7)目的库数据查询： select*fromahbiusr.throld; 8）原始库删除数据： truncatetableahbiusr.throld;9）原始库数据查询： select*fromahbiusr.throld;10）目的库数据查询： select*fromahbiusr.throld;6.2.2原始库(one)与目的库(more)表构造不同测试原始数据库建表createtableahbiusr.one(IDINTEGERnotnull,NAMEVARCHAR2(15)notnu