Research And Development Of Oracle Incremental Data Synchronization System Based On Logminer

With the development of enterprise business system,in order to provide higher customer service and ensure user data security and business continuity,some important systems are not satisfied with simple local dual machine hot backup and fault-tolerant switching.More and more customers put forward higher requirements for system availability,so as to realize the real protection of remote application level disaster recovery system.A comprehensive application level disaster recovery protection solution means that in addition to the better protection of local data fault tolerance required by the business system,it is more important to realize the real-time remote replication of local data and the local real-time remote remote switch of real-time business application management system(including data base and local application management software).Now there are many versions of database products and management software.Local and remote databases may be isomorphic or heterogeneous,so data synchronization between different databases should also be realized.Local and remote environments may only be isomorphic local environments,or they may be considered as heterogeneous local environments.Therefore,for traditional production management systems and large disaster recovery management systems,the Hardware platform and architecture can belong to different software manufacturers,different models,different operating systems,etc.In recent decades,Oracle database has developed rapidly in the commercial market,and the data for Oracle database is of high economic value for heterogeneous disaster recovery.In the process of design and development,the system adopts logminer log mining tool provided by Oracle and SQL parsing module in Druid,an open source project of Alibaba company.Using the object-oriented method,this paper analyzes the functional requirements of data mining and data backup in the actual business of Oracle database incremental synchronization system,divides the whole system into four modules: read module,write module,management module and transmission module,and further subdivides each module into small modules,designs each module specifically,and solves the technology in each module Difficulties.