X

Welcome to All Things Data Integration: Announcements, Insights, Best Practices, Tips & Tricks, and Trend Related...

Oracle GoldenGate Veridata Repair is here!

Guest Author

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.


Join the discussion

Comments ( 5 )
  • guest Tuesday, November 4, 2014

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


  • Alexey Danchenkov Wednesday, February 11, 2015

    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


  • Irem Radzik Wednesday, February 11, 2015

    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.


  • guest Thursday, February 26, 2015

    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!


  • guest Wednesday, March 4, 2015

    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


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.