Oracle GoldenGate Veridata Repair is here!

By Joe deBuzna, Director, Oracle Data Integration Product Management

Fix your out of sync data with a single click using the new Oracle GoldenGate Veridata 12.3 heterogeneous data repair feature!

I am so happy to finally be typing that sentence because I get asked about the Veridata Repair feature all the time. So YES, it’s really here! Call me biased, but this is one of the most highly sought after, killer features in the Oracle Data Integration product line, if not all of Oracle Fusion Middleware. And while it’s part of the Oracle GoldenGate product suite, it can compare and fix data between any two databases regardless of how you’re moving the data around: Oracle GoldenGate, Oracle Data Integrator, Oracle Streams, Logical Data Guard, Oracle Advanced Replication, SQL scripts, custom batch jobs, SQL*Loader – it does not matter! As long as Veridata has the right database connection permissions and supports the platform, you’re good to go.

And why does data go out of sync? Let me count the main ones, so we can keep this post short and sweet. The big ones we see include bad source data (e.g. out of bounds characters from wrong NLS settings and bad dates) got inserted or updated, no logging source operations caused data gaps in logical replication products, and bulk data loads/copies into target systems were timed incorrectly (improperly “instantiated” for replication). And here’s the one we don’t like to talk about: we work in extremely complicated IT environments and sometimes people just make mistakes. Sometimes we inherit those mistakes. And it’s ok to have mistakes. But far better if you can quickly identify them and it is absolutely crucial to fix them as soon as possible to avoid domino effects of inconsistent data.

So don’t just hope your data is in sync, prove it and have confidence knowing it. Have confidence when you’re about to pull the switch on your cloud migration or failover; have confidence looking your CEO in the eye telling him that his “single source of truth” still is; have confidence that complex, multi-master conflict detection and resolution setup you designed, or inherited, is actually keeping everything in sync.

You can learn more about the repair feature via a few new resources we have for you below. Take a look and see how you can pick and chose only which tables and specific rows you want to repair; what we did to make this feature fast and secure; how we can suppress target triggers; and more:

You can also watch a half hour video of me talking about and giving a demo of both Oracle GoldenGate Veridata and Monitor 12.1.3 here:

Oracle University Learning Stream video for Oracle GoldenGate Monitor and Oracle GoldenGate Veridata.

For Oracle GoldenGate Veridata 12.1.3 we now include in a single download Oracle GoldenGate Veridata Server, Veridata Java agents, Oracle GoldenGate Monitor Server, and Oracle GoldenGate Monitor agents. This single download can be found on eDelivery.oracle.com and on our Oracle Technology Network page.

And since we’re now based on Oracle Weblogic Server 12.1.3, you’ll need to also download the Oracle Application Development Runtime Infrastructure.

To see which platforms are supported, you can click on the Certifications tab in My Oracle Support, or download the spreadsheet “System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.1.3)”.

Finally, please feel free to leave comments and feedback below. For those willing to share, I’m always looking for interesting stories on how you’ve seen data going out of sync and how you ended up fixing it.


Comments:

It's long awaited feature... Happy to finally see if rolling out.

Posted by guest on November 04, 2014 at 08:54 AM PST #

hi,

we are testing Oracle VeriData in test environment and trying to use repair feature. We have two similar tables where target table has some different data. After successful comparison using veriData we can see out of sync rows in the target table. However, when I click "Repair" button in the veriData GUI, I get always error like :

OGGV-00199: Repair is not supported by connection "source_connection"

what could be the reason of this error?

Thanks

Posted by Alexey Danchenkov on February 11, 2015 at 05:18 AM PST #

Hi Alexey,
This error usually occurs when trying to use a Veridata 11.2 agent with Veridata 12.1.3. Repair is only supported with the 12.1.3 agent. If using the 12.1.3 agent and receiving this error please open an SR with Oracle Support.

Posted by Irem Radzik on February 11, 2015 at 01:25 PM PST #

Hi Irem,
I have some problems with this functionality in the replicat with the HANDLECOLLISIONS enabled. When I run repair for the pair of tables, report shows the following warnings and no rows are repaired:
Missing update. Row 0, Warning: OGGV-60022: 0 rows updated
Missing update. Row 1, Warning: OGGV-60022: 0 rows updated
...
** Summarizing Rows Repaired With Warning ***

inserts : 0
updates : 48
deletes : 0

Is this a bug or not?
Thank you!

Posted by guest on February 26, 2015 at 02:58 AM PST #

Answer from Joe DeBuzna:

If Veridata Repair works for inserts and deletes but warns updates are missing. The report log may show something like:
Example: Row 0, Warning: OGGV-60022: 0 rows updated Missing update.

The reason: Most likely updates did not succeed because the out-of-sync column value changed between the out-of-sync confirmation step and update attempt. By default Veridata adds the before image for all out-of-sync columns to the SQL WHERE.

Veridata lets you recheck just those columns that were reported out of sync from any previous comparison by using the "Review Previous Out-Of-Sync Results" Run override option. Make sure those data are still out of sync by doing this targeted comparison and if so attempt the repair based on the new results.

There is the option turn off the out-of-sync before image check by unchecking "Check Changed Values" in the Profile settings: Profile Configuration > (profile name) > Profile Settings > Repair > Check Changed Values

Posted by guest on March 04, 2015 at 03:08 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« July 2015
SunMonTueWedThuFriSat
   
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today