Data synchronization method based on oracle database

Abstract

The invention belongs to the technical field of the database, and particularly relates to a data synchronization method. The data synchronization method based on an oracle database comprises the following steps of: exporting business related data by a host, and sending the business related data to a standby machine importing database; scanning a database log on the host; recording data variation to a local log file; compressing and sending the local log file to the standby machine; and after the standby machine receives synchronized data, analyzing into the local log file which is consistent with the host data. When the host fails, the logic states of the host and the standby machine are revised by a control program, and the standby machine replaces the host to continue to work. If the host fails to cause host communication faults, the standby machine is directly operated by the control program to be forcedly switched into the host, so as to continuously support the system to operate. According to the data synchronization method based on the oracle database, which is disclosed by the invention, data synchronization service is independent from a service program, the service program design complexity is lowered, a transmission channel is uniformly managed, and the data synchronization method based on the oracle database is suitable for special requirements, such as the encryption and decryption processing of the data channel.

Description

technical field [0001] The invention belongs to the technical field of databases, in particular to a data synchronization method. Background technique [0002] In high-reliability application systems, dual-machine backup is usually used for servers. When the master server of the two backup servers fails, the backup server will continue to work instead of the original master server. During the running of dual-server backup, the service program needs to synchronize data between the two servers to ensure that the backup server can take over the work of the primary server. When the service program processes synchronous data, it needs to coordinate the relationship with the business data processing and affect the business processing logic, and the service program needs to maintain the transmission channel resources and manage the transmission and processing of the synchronous data, which leads to the service program design The complexity of implementation is not conducive to the...

AI Technical Summary

Problems solved by technology

When the service program processes synchronous data, it needs to coordinate the relationship with the business data processing and affect the business processing logic, and the service program needs to maintain the transmission channel resources and manage the transmission and processing of the synchronous data, which leads to the service program design The complexity of implementation is not conducive to the business processing of service programs