关键词: 在线日志挖掘, 数据加密传输, 日志合成, 日志应用, 数据一致性, 复制延时

Abstract:  In view of the problems existing in the current logic level database replication technology, this paper presents a model of database data replication based on physical level. The model uses a database replication group to establish its reference relationship. By analyzing the Oracle log data in the file system format, the raw device and the redo log based on the database, the data fragments are synchronized to the end of the data segment. By end of log fragment reorganization, the log head sign is modified a synthetic log file and source side validation are registered to disaster libraries, and synthetic log is automatically or manually written to disaster libraries, so as to realize the physical database replication. By comparing and analyzing the test data, the model can not only ensure the data consistency, but also reduce the time delay of data replication.

Key words:  , redo mining； encrypted transmission； redo synthesis； redo application； consistency； delay