The Design And Implementation Of Database Data Replication Disaster Tolerance System Based On The Relationship Of Log Data Block

Data are the core assets of an enterprise.With the attention of various industries to the application degree of data,the core business Oracle database in enterprises has higher requirements for disaster tolerance system.The deficiencies of traditional database disaster tolerance replication technology in data consistency are reflected gradually.The database data replication technology based on log block can solve above problems exactly.This thesis takes the development of database disaster tolerance system as the research background,and combines with Redo log positioning analysis technology,Redo log mining technology,parallel transmission technology,log block synthesis technology,log application technology as well as automatic switching technology to complete the design and implementation of database data replication disaster tolerance system.Firstly,from the perspective of database system architecture and Redo log parsing,this thesis elaborates the key technology of database data replication.Combined with Oracle database,this thesis analyzes the overall structure,storage structure and instance structure of database.What' s more,this thesis puts forward database Redo log parsing method,and gives the specific internal structure of Redo log.Combined with Redo log parsing technology,data replication process which is based on Redo log data block is designed.On the basis of designing the overall architecture of the system,this thesis uses the idea of component design,and from the perspective of data mining,data transmission,log synthesis as well as log application to illustrate the internal process of components and functional list of components.Combined with the data replication switching scenario,the specific process of planned switching,planned back cutting,disaster switching and disaster back cutting is designed.Combined with the concrete development and operating environment,from the perspective of functional description,input and output,calling relationship,the calling relationship of function to the database table,process logic,data structure,class definition and core code implementation,this thesis gives the realization process of core functional component,and designs to realize the database replication disaster tolerance system based on physical level.Combined with the functional points of the system,the system test cases are designed,and functional tests and performance testing processes of the system are given.The feasibility and reliability of the database disaster recovery and replication system designed in this thesis is verified.Finally,this thesis summarizes the research results of database data replication technology,and looks forward to the work emphasis of next stage.