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’sTitleOracleGoldenGateOverviewForOracleemployeesandauthorizedpartnersonly.Donotdistributetothirdparties.©2009OracleCorporation–ProprietaryandConfidentialInsertPictureHereAgenda•课程•OracleGoldenGate概述•产品定位•产品介绍•适用场景•技术概述6GoldenGate产品定位GoldenGate成为Oracle的战略性产品7•包括“财富”500强企业在内的超过400个客户、4000+实施案例,行业跨越金融服务,通信,医疗保健,公共部门,零售和公用事业等•前3名的5大商业银行•前3名3个最繁忙的ATM网络•前7位的10家金融数据服务公司•5个电信运营商前4•前35最大的食品及药品店•最好的实时数据解决方案•与Oracle产品互补•支持异构系统•支持实时数据报告•支持BI,EPM,Exadata的实时数据获取•“零宕机”迁移/升级到Oracle数据库和应用程序GoldenGate金融行业8GoldenGate政府/电信行业9GoldenGate其它行业1011OracleGoldenGate针对企业级的实时数据需求的解决方案实时信息Databaseandapplications,Mixedsources,distributedsystems,legacy,OLTP,OLAPMissionCriticalApplications&Data,BusinessIntelligence,ReportingforCustomers,Partners&Employees传统数据仓库是战略层面的,对实时数据要求低12OracleGoldenGate针对企业级的实时数据需求的解决方案实时信息OracleGoldenGate提供实时信息的实时访问,使企业能显著提高其IT系统关键数据的可用性,可靠性,性能。MissionCriticalApplications&Data,BusinessIntelligence,ReportingforCustomers,Partners&Employees实时访问Databaseandapplications,Mixedsources,distributedsystems,legacy,OLTP,OLAPOracleGoldenGate技术优势实时、跨异构和支持交易/事务完整性的复制1313OracleGoldenGate可以在异构环境中,实现对数据库事务的实时、高性能的捕获、路由、转换和传递。性能灵活扩展性可靠性关键优势:非侵入式,影响小,亚秒级延迟开放、模块化的结构-支持异构的源端、目标端维护事务完整性-弹性应对异常中断、故障异构性的技术基础•核心架构•核心产品组件支持所有数据库•标准trail文件格式•规范的元数据定义•常见的数据类型的自动映射•Capture•日志获取(直接文件访问)•数据库内置日志接口(日志API)•exit•供应商提供的接入模块•Delivery•使用本地数据库接口14•事务边界•记录在GoldenGatetrail文件中•事务按commit顺序排列•事务边界按过滤条件或trail文件划分自动调整•事务完整性•Checkpointing机制和recovery机制基于事务边界实现•Delivery进程工作时保持原commit顺序15事务完整性的保证•松耦合架构•单个进程可以自动重新启动•网络中断(可配置)容错性•恢复机制•恢复机制确保了任何操作在任何失败的情况下,都不会被跳过或重复操作•RecoveryoftheCaptureprocessismoreinvolvedthanrecoverytheDeliveryprocess•虽然GoldenGate的进程是完全解耦的,但是Delivery进程一定会知道Capture进程或pump进行的恢复16可靠性架构OLTPOLTPOLTPODSODSEDW查询/报表OLTPOldOLTPNew分析型操作型OLTPStageOLTP大规模可扩展性配置灵活单向查询分流双向主用/备用或主动-主动,实现高可用性集成/整合实时数据仓库广播数据分发级联式分布式业务合并实时BIOLTPOLTPOLTPOLTPOLTP对等负载平衡/多主分布式17ForOracleemployeesandauthorizedpartnersonly.Donotdistributetothirdparties.©2009OracleCorporation–ProprietaryandConfidentialInsertPictureHereOracleGoldenGate产品介绍18OracleGoldenGate产品、服务——Windows,UNIX&Linux主要产品•OracleGoldenGateTransactionalDataManagement(TDM)•OracleGoldenGateDirector(TDM的GUI,适用于管理、配置)•OracleGoldenGateVeridata(在线检查复制结果)服务•ProfessionalServices•EducationalServices19OracleGoldenGateVeridata“OracleGoldenGateVeridata是一种高速,低影响的数据比较方案。可以识别和报告两个数据库之间的数据差异,而不中断系统、业务流程。”单独作用不依赖GoldenGateTDM20为什么需要Veridata?数据不一致时常发生用户错误输入错误非预期使用;恶意破坏架构错误系统故障磁盘损坏网络中断迁移确认数据库升级数据库迁移操作系统升级应用程序的升级实时数据集成验证数据仓库查询减负营销数据库应用错误-错误的逻辑-升级失败-潜在bug配置错误应用复制网络21Veridata3.0组件概述•veridata是一个repository为基础的产品。•Veridataserver与装在数据库上的Veridataagent通信。•各种信息存在repository,在那里他们可以由VeridataWeb客户端访问和显示的结果。•Javaagent支持异构跨数据库的比较。•Çagent支持NSK,并可以支持oraclelike-to-like比较。Veridat