Unlock instant, AI-driven research and patent intelligence for your innovation.

Data synchronization verification method based on goldengate

A verification method and data synchronization technology, applied in database indexing, database updating, structured data retrieval, etc., can solve the problems of high resource consumption, long time consumption, and inability to fully guarantee data consistency, and achieve accurate data verification, Shorten time-consuming effects

Active Publication Date: 2020-08-11
SHANGHAI SNC NET INFORMATION TECH CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] 1. The existing technical solutions 1 to 3 are not rigorous and cannot fully guarantee the consistency of data;
[0007] 2. Existing technical solutions 4-5 take too long
What is even more unacceptable is that the data verification script needs to be executed separately in the environment before and after the migration. This operation consumes too much resources, and the target environment of the migration basically cannot perform other operations

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data synchronization verification method based on goldengate

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0016] figure 1 It is a schematic diagram of the data synchronization verification process based on GoldenGate in the present invention.

[0017] See figure 1 , the GoldenGate-based data synchronization verification method provided by the present invention deploys GoldenGate software at the source end and the target end respectively, and the specific deployment steps are as follows: authorize the ogguser user to allow connection and access to the database, open the minimum additional log of the database, and create a management process mgr , this process is used to manage the extraction, delivery, and replication processes created subsequently; configure the extraction process, delivery process, and replication process. The data synchronization checking method comprises the steps of:

[0018] S1. For the source of Oracle GoldenGate, make the followin...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a synchronous verification method of data based on GoldenGate. The method comprises the following steps: S1: recording complete before-image information at the source end of the Oracle GoldenGate; S2: creating a GoldenGate change table on the target end, respectively recording a table name , increment of record counts, increment of Hash value, and SCN value of data submitted by the source end. S3: performing a verification of full amount of the data before official migration, recording the source end SCN corresponding to the verification of full amount of the data, recording information to GoldenGate full amount Hash table; S4: during the official migration, initiating the verification of full amount of the data at the source end, recording the current SCN value estimated according to the GoldenGate full amount Hash table, the GoldenGate change table, and the current SCN value. The synchronous verification method of the data based on GoldenGate greatly shortensthe shortens the time consumption required for the migration to a target environment on the premise of ensuring accurate data verification.

Description

technical field [0001] The invention relates to a data synchronization verification method, in particular to a GoldenGate-based data synchronization verification method. Background technique [0002] Oracle GoldenGate software can support real-time data synchronization between Oracle Databases. However, during large-scale system cutover, it often takes a lot of time to implement data consistency checks in order to ensure data consistency. [0003] At present, the common practices in the industry are as follows: 1. No verification; 2. Spot check data based on business logic; [0004] 3. Only check the number of records; 4. Realize full data verification based on Oracle GoldenGate Veridata; 5. Realize hash value verification based on the entire table. [0005] The shortcoming of prior art is as follows: [0006] 1. The existing technical solutions 1 to 3 are not rigorous and cannot fully guarantee the consistency of data; [0007] Two, the existing technical schemes 4 to 5 ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/27G06F16/21G06F16/22G06F16/23
Inventor 程永新林小勇黎君原
Owner SHANGHAI SNC NET INFORMATION TECH CO LTD