Data replication and backup method based on goldengate

Abstract

The invention discloses a GoldenGate-based data replication and backup method, comprising: deploying GoldenGate software on two node hosts at the source end and the disaster recovery target end respectively, and connecting them through a disaster recovery / emergency link; the first node at the target end Configure the data file checkpoint table on the host. Backup data from the first node of the source end to the first node of the target end, and copy the data in the GoldenGate directory of the first node to the second node at the source end and the target end respectively; when the source end is switched from the host of the first node to the second node In the case of a two-node host, the source end obtains the SCN number last applied by the disaster recovery target end, and queries the time point corresponding to the SCN number, and the second node at the source end continues to back up data to the second node at the disaster recovery target end from this time point. The present invention not only guarantees fast duplication and backup of data, but also ensures integrity and consistency of data at the target end after emergency switching.

Description

technical field [0001] The invention relates to a data duplication and backup method, in particular to a GoldenGate-based data duplication and backup method. Background technique [0002] As informatization gradually occupies the leading role in social life, people's lives are gradually surrounded by increasingly infiltrating information control. The changes in the international security situation characterized by 9 / 11 and the unexpected encounters of various large-scale or sudden disasters have made people see that the centralization of information has not only brought social progress and changed life, but also brought heightened risk concentration. Under the threat of various risks, the core carrier information system of the business, its robustness and ability to resist risks directly determine the viability of the enterprise and even the industry, and become the basic guarantee of the service level. [0003] This leads to the construction of a popular vocabulary disast...

AI Technical Summary

Problems solved by technology

[0012] 2) High risk of data loss

This time point is later than the node 1 failure time, which will cause some data loss

This time point is earlier than the node 1 failure time, which will cause some data to be modified repeatedly

[0013] 3) High dependence on people

However, the current storage system is still very expensive, ranging from hundreds of thousands to millions

[0018] 2), low resource utilization

After the GoldenGate software is equipped with separate storage, the high-speed read and write capabilities of the upper storage are not fully utilized, which reduces the utilization of resources

Images