51CTO下载-OGG11g-02-配置OracleGoldenGate

ForOracleemployeesandauthorizedpartnersonly.Donotdistributetothirdparties.©2009OracleCorporation–ProprietaryandConfidentialThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.SafeHarborStatementForOracleemployeesandauthorizedpartnersonly.Donotdistributetothirdparties.©2009OracleCorporation–ProprietaryandConfidentialUseofthisSite(“Site”)orMaterialsconstitutesagreementwiththefollowingtermsandconditions:1.OracleCorporation(“Oracle”)ispleasedtoallowitsbusinesspartner(“Partner”)todownloadandcopytheinformation,documents,andtheonlinetrainingcourses(collectively,“Materials)foundonthisSite.TheuseoftheMaterialsisrestrictedtothenon-commercial,internaltrainingofthePartner’semployeesonly.TheMaterialsmaynotbeusedfortraining,promotion,orsalestocustomersorotherpartnersorthirdparties.2.AlltheMaterialsaretrademarksofOracleandareproprietaryinformationofOracle.Partnerorotherthirdpartyatnotimehasanyrighttoresell,redistributeorcreatederivativeworksfromtheMaterials.3.OracledisclaimsanywarrantiesorrepresentationsastotheaccuracyorcompletenessofanyMaterials.Materialsareprovidedasiswithoutwarrantyofanykind,eitherexpressorimplied,includingwithoutlimitationwarrantiesofmerchantability,fitnessforaparticularpurpose,andnon-infringement.4.UndernocircumstancesshallOracleortheOracleAuthorizedDeliveryPartnerbeliableforanyloss,damage,liabilityorexpenseincurredorsufferedwhichisclaimedtohaveresultedfromuseofthisSiteofMaterials.AsaconditionofuseoftheMaterials,PartneragreestoindemnifyOraclefromandagainstanyandallactions,claims,losses,damages,liabilitiesandexpenses(includingreasonableattorneys'fees)arisingoutofPartner’suseoftheMaterials.5.ReferencematerialsincludingbutnotlimitedtothoseidentifiedintheBootCampmanifestcannotberedistributedinanyformatwithoutOraclewrittenconsent.OracleTrainingMaterials–UsageAgreementForOracleemployeesandauthorizedpartnersonly.Donotdistributetothirdparties.©2008OracleCorporation–ProprietaryandConfidentialInsertPictureHereTitleofPresentationPresenter’sNamePresenter’sTitle配置OracleGoldenGateForOracleemployeesandauthorizedpartnersonly.Donotdistributetothirdparties.©2009OracleCorporation–ProprietaryandConfidentialInsertPictureHereAgenda•课程•配置OracleGoldenGate•准备环境•Capture进程•InitialLoad•Delivery进程6OracleGoldenGate初始化•对源数据库启动更改数据捕获•当前源端提交序列号(CSN)为222GoldenGate初始化7CapturePumpCommitOrderedSourceTrailCommitOrderedTargetTrailSourceDatabaseTargetDatabaseCurrentCSNis222CSNs222through…•等待关闭任何打开的事务•使用备份(或者export/import)从一个一致时间点将源文件复制到目标•当前源端提交序列号(CSN)为245初始化GoldenGate8CapturePumpCommitOrderedSourceTrailCommitOrderedTargetTrailSourceDatabaseTargetDatabaseTakeBackupasofCSN245ApplyBackupasofCSN245CSNs222through…ConsistentasofCSN245CurrentCSNis245•在给出备份CSN时或之后启动delivery(在本示例中为245)•当前源端提交序列号(CSN)为356•一旦Delivery，则源与目标同步GoldenGate初始化9CaptureDeliveryPumpCommitOrderedSourceTrailCommitOrderedTargetTrailSourceDatabaseTargetDatabaseCSNs222through356DelivertransactionsafterCSN245CurrentCSNis356ConsistentasofCSN356InSync!TakeBackupasofCSN245ApplyBackupasofCSN245ForOracleemployeesandauthorizedpartnersonly.Donotdistributetothirdparties.©2009OracleCorporation–ProprietaryandConfidentialInsertPictureHereOracleGoldenGate实施与配置10配置OracleGoldenGateOracleGoldenGate可以按如下四步快速而简单的进行部署:1.准备环境2.捕获变更3.初始加载4.变更交付11配置OracleGoldenGate3.初始化加载(不同的方法)4.变更交付1.准备环境2.捕获变更TrailTargetDatabase事务日志SourceDatabaseCaptureDelivery目标跟踪12November19,2013配置OracleGoldenGate:Step1.准备环境13安装-Windows•从OracleGoldenGate软件web站点下载.zip文件到一个Windows目录，例如:C:\GGS•解压(Unzip).zip文件到Windows目录，例如:C:\GGS•在GLOBALS参数文件中为管理进程配置一个windows服务名(仅当同一服务器上存在多个管理进程时需要)•C:\GGSINSTALLADDSERVICEADDEVENTS•GGSCICREATESUBDIRS14安装–WindowsINSTALL程序•在Windows,一个INSTALL程序执行如下功能:•安装OracleGoldenGate事件消息(eventmessages)到系统注册表•安装管理器作为一个Windows服务•语法:INSTALLitem[item…]•例如:C:\GGSINSTALLADDEVENTSADDSERVICE注意:卸载命令为:INSTALLDELETESERVICEDELETEEVENTS15安装–多个管理器服务•OracleGoldenGate在windows平台支持运行multipleManagerservices•两个或更多OracleGoldenGateinstances,或者•带有一个VeridataCAgent(用了一个Manager)的OracleGoldenGate•每个Managerservice必须赋予一个唯一的名字•在安装服务之前可以通过下面方式指定一个名字•为每个manager创建一个GLOBALS参数文件•使用MGRSERVNAMEnameparameter指定一个服务名字•INSTALLADDSERVICE•通过读取GLOBALSMGRSERVNAME指定的服务名•如果没有GLOBALSsetting,使用缺省服务名GGSMGR16安装-UNIX,Linuxorz/OS•从OracleGoldenGate软件下载Web站点下载.gz文件到一个本地目录，例如:/ggs•gzip–d{filename}.tar.gz•tar-xvof{filename}.tar•GGSCICREATESUBDIRS17安装–OracleGoldenGateDirectories•Dirchk•Dirdat•Dirdef•Dirpcs•Dirprm•Dirrpt•Dirsql•DirtmpDIRECTORY•OracleGoldenGatecheckpointfiles•OracleGoldenGatetrailandextractfiles•DatadefinitionsproducedbyDEFGENandusedtotranslateheterogeneousdata•Processstatusfiles•Parameterfiles•Processreportfiles•SQLscripts•TemporarystoragefortransactionsthatexceedallocatedmemoryCONTENTS18Workshop:UsingOracleGoldenGateDocumentat