Download Repair SQL Files in Oracle GoldenGate Veridata

May 26, 2022 | 4 minute read
Anuradha Chepuri
Consulting User Assistance Developer, Oracle
Text Size 100%:

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:

  1. From the left navigation pane, click Finished Jobs and then click the Job Name:

     

    Download Repair SQL

  2. Click the Group Name:

    Download Repair SQL

  3. Click the Out of Sync link for the Compare Pair name Case_Insensitive_Table=CASE_INSENSITIVE_TABLE:

    Download Repair SQL

  4. Click Download Repair SQL.

    Download Repair SQL

    The SQL file gets downloaded.

  5. Open a terminal to view the SQL file. Navigate to the file location:

    Download Repair SQL

  6. Extract the zip file to view the SQL file.

SQL File

 

Video Preview

Watch this short video on Download Repair SQL functionality in Oracle GoldenGate Veridata:

Repair Out-of-Sync Data

To repair out-of-sync jobs:

  1. 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.

  2. From the table under Finished Jobs, click the Job Name:

    Repair SQL

  3. Click the Group Name:

    Repair SQL

  4. Click the Out Of Sync link for the Compare Pair name Case_Insensitive_Table=CASE_INSENSITIVE_TABLE:

     

    Repair SQL

5. Click Run Repair.

 

Run Repair

The out-of-sync records for the selected job are repaired.

 

out-of-sync-repaired

 

 

 

Announcing a new Workshop!

Try out the Labs in the brand new "Column Mapping and Purging Data in Oracle GoldenGate Veridata Workshop" if you would like to create Connections, Groups, Compare Pairs, Jobs, add and remove column mappings, purge data, and delete directories  in Oracle GoldenGate Veridata:

Lab

Video Preview

You may also want to watch this short video on Oracle GoldenGate Foundation Suite:

 

 

Want to Know More?

 

Approved by Jonathan Fu, Director, Product Development & Sukin Varghese, Senior Member of Technical Staff, Oracle GoldenGate.

Anuradha Chepuri

Consulting User Assistance Developer, Oracle

As a Consulting User Assistance (UA) Developer, I'm responsible for developing all the UA Assets for Oracle Database products.


Previous Post

GoldenGate for Big Data Pluggable Formatters, JSON Formatter

Deniz Sendil | 10 min read

Next Post


GoldenGate for Big Data Pluggable Formatters, DelimitedText Formatter

Deniz Sendil | 8 min read