Oracle GoldenGate+DXP技术实现关键业务系统容灾的解决方案  

Oracle GoldenGate+DXP Technology to Achieve Disaster Recovery Solutionsfor Critical Business Systems

作　　者：宰旭昕 康凯 许广文 ZAI Xu-xin;KANG Kai;XU Guang-wen(Administration Residency Research Center,the Ministry of Public Security PRC,Beijing 100070,China)

机构地区：[1]公安部户政管理研究中心,北京100070

出　　处：《通信技术》2020年第10期2501-2509,共9页Communications Technology

摘　　要：GoldenGate是Oracle的一种实现主备数据库之间数据同步复制的软件,能够实现大量数据的实时捕获、路由、转换和交付,主要应用于容灾系统之间的数据同步。DXP数据传输运行平台是对OGG在数据对账和补偿方面的补充,支持多种数据源和多种比对方式,适用于各种网络,具有多样化调度方式,可以对关系型数据库和列存储数据库中的数据进行高效对账和补偿,实现主备系统、主备数据库和其他类型的冗余数据系统中的数据一致性,满足业务方面的需求。因此,介绍当前某关键业务系统容灾建设现状和数据同步机制,以及在数据同步中出现的差异数据问题,提出Oracle GoldenGate+DXP技术相结合的实时数据集成和持续可用性解决方案,实现主备数据库数据同步、对账、补偿和维护,确保数据一致性。GoldenGate is a software of Oracle to realize the data synchronous replication between the main and backup databases.It can realize the real-time capture,routing,conversion and delivery of a large amounts of data,and is mainly used in the data synchronization between disaster recovery systems.DXP data transfer operation platform is a supplement to OGG in data reconciliation and compensation,supports multiple data sources and multiple comparison methods,is suitable for a variety of networks,and has a variety of scheduling methods.It can effectively check and compensate the data in relational database and column storage database,and realize the data consistency in the main and standby systems,the main and standby databases and other types of redundant data systems,and meet the needs of business.Therefore,this paper introduces the current situation of disaster recovery construction and data synchronization mechanism of a key business system,as well as the problem of differential data in data synchronization.It puts forward a solution of real-time data integration and continuous availability based on Oracle GoldenGate+DXP technology to realize data synchronization,reconciliation,compensation and maintenance of main and backup databases,and ensure data consistency.

关 键 词：容灾 Oracle GoldenGate DXP数据传输运行平台 数据 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]