Data consistency verification method based on Oracle database

Abstract

The invention discloses a data consistency verification method based on an Oracle database. The data consistency verification method comprises the following steps: a) pausing the Oracle database copy progress, and enabling the Oracle database to submit all affaires; b) acquiring time stamp information SCN of a source end database; c) checking a target end database and acquiring present time stamp information SCN, restarting the paused Oracle database copy progress, and recovering Oracle database synchronization; and d) under the condition that the time stamp information SCN of the source end database and the target end database is consistent, performing data consistency verification on corresponding lists. By adopting the data consistency verification method based on the Oracle database, the data consistency verification is performed after matched time stamp information is acquired, so that relatively frequent recording can be successfully processed, no any service logic or major key is depended, the verification efficiency is high, the verification speed is high, and the configuration is simple and easy to use.

Description

technical field [0001] The invention relates to a data verification method of a database, in particular to a data consistency verification method based on an Oracle database. Background technique [0002] Oracle GoldenGate software is a log (log)-based structured data replication software. It obtains data addition, deletion, and change by parsing the source database online log or archive log, and then applies these changes to the target database to realize the source database. Synchronize and active-active with the target database. Oracle GoldenGate software can realize sub-second real-time replication of large amounts of data between heterogeneous IT infrastructures (including almost all common operating system platforms and database platforms). [0003] Oracle GoldenGate is a software-based data replication method. It parses data changes from the database log, converts data changes into its own format, and transmits them directly through the TCP / IP network without relying...

AI Technical Summary

Problems solved by technology

Directly using Oracle GoldenGate Veridata for verification is an official method of Oracle. The bottleneck of this method is: 1) The cost is higher, and Oracle GoldenGate Veridata software needs to be purchased separately, and it may be necessary to purchase a new machine and build a database; 2) For inconsistent records found after the initial comparison (usually due to time delay), the method of re-verifying the consistency of a single record is used. If a single record changes multiple times during the verification period, it can only be identified as a change 3) The accuracy of the verification is relatively fine, but it costs a lot of resources and time; 4) The verification efficiency of tables without primary keys or unique keys is low, and consumes a large amount of temporary table space or file system Table of contents

[0021] It can be seen from the above that none of the existing Oracle database processing methods can completely solve the problem of data consistency

Images