Oracle GoldenGate Veridata performs comparisons on tables to identify data discrepancies. The Repair functionality allows you to eliminate these descrepancies and makes the data identical.
Oracle GoldenGate Veridata provides the Download Repair SQL functionality which downloads SQL files for target tables associated with the out-of-sync jobs.
You can download repair SQL files only for Jobs that have been configured for datasource connections with the Oracle datatype. Make sure that you have a connection, group, and compare pairs already created and executed a Job.
To download repair SQL files:
From the left navigation pane, click Finished Jobs and then click the Job Name:
Click the Group Name:
Click the Out of Sync link for the Compare Pair name Case_Insensitive_Table=CASE_INSENSITIVE_TABLE:
Click Download Repair SQL.
The SQL file gets downloaded.
Open a terminal to view the SQL file. Navigate to the file location:
Extract the zip file to view the SQL file.
Watch this short video on Download Repair SQL functionality in Oracle GoldenGate Veridata:
To repair out-of-sync jobs:
From the left navigation pane, click Finished Jobs to view the page containing details of all the finished jobs. You can select Jobs, groups, and compare pairs for repairing out-of-sync records.
From the table under Finished Jobs, click the Job Name:
Click the Group Name:
Click the Out Of Sync link for the Compare Pair name Case_Insensitive_Table=CASE_INSENSITIVE_TABLE:
5. Click Run Repair.
The out-of-sync records for the selected job are repaired.
You may also want to watch this short video on Oracle GoldenGate Foundation Suite:
Approved by Jonathan Fu, Director, Product Development & Sukin Varghese, Senior Member of Technical Staff, Oracle GoldenGate.
As a Consulting User Assistance (UA) Developer, I'm responsible for developing all the UA Assets for Oracle Database products.
Previous Post
Next Post