With Goldengate Veridata 12.3, it is now possible to repair inconsistent data after data replication with just one click.
By comparing data, Veridata can repair data between two databases. The range of Veridata fixes includes goldengate, Oracle Data Integrator, Oracle Streams, Logical data Guard, Oracle Advanced Replication, SQL scripts, batch jobs, SQL *loader and other tools synchronize data, in fact veridata repaired data is not related to these synchronization tools, as long as allow veridata to connect to the DB, and is veridata supported platform.
Why is data synchronization inconsistent? The main reason is that the source data may be wrong, such as the wrong date time, the data will not be generated in the log, not captured by Ogg, the source and target character set is different, resulting in the target table end insertion is lost, or when the data is loaded, the target library table structure and the source table is different, resulting in data loss. It can also be human error, resulting in different data on both sides. In either case, the data should not be repaired as quickly as possible, so that inconsistent data does not cause a worse impact.
Therefore, it is important to try to ensure that the data on both sides is consistent when synchronizing data, and it is best to prove that they are consistent. Once you have a primary and standby switch for the source and target libraries, the consistent confidence in the data allows you to confidently tell the CEO that even though there are multiple replication links, there is always only one copy of the data.
is the Veridata repair interface:
You can learn about these new features by learning Veridata's latest documentation. Document Address: http://docs.oracle.com/goldengate/1213/gg-veridata/index.html
You can also learn by video: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=724&get_params= Streamid:22,p_searchwords:dipm,p_pagenumber:1
Now Veridata 12.1.3 has been integrated with Goldengate monitor and so on in one installation package, which can be downloaded from here: http://www.oracle.com/technetwork/middleware/goldengate/ Downloads/index.html
It contains: Veridata Sever, Veridata Agents, monitor Server, monitor Agents.
Because this version is based on WebLogic 12.1.3, you also need to download the operating environment: Oracle Application Development Runtime Infrastructure, address: http://www.oracle.com/ Technetwork/developer-tools/adf/downloads/index.html
Other new features:
In addition to repairing inconsistent data, Veridata also added script support Tools to help developers batch add comparison tables instead of previous manual additions to the interface, as well as support for IPV6, SSO, support for SSL-based and veridata agent communication, The output-supported comparison report has an encryption mechanism to prevent unwanted people from viewing it.