Hi All,
What are the different causes for out-of-sync records in golden gate and how do I trouble shoot them. Below are the Out of sync scenarios which I understood, do we have anything else apart from that.
Causes of out-of-sync data
Some causes beyond your control:
● user input errors
● application bugs
● system failures
● disk corruption
Some factors within your control:
● DML on target tables (other than replication)
● tables without keys
● character sets
● differences between source and target structure or primary keys
We do not find any of the scenarios in our environment. We ran the veridata report and we got the out of sync. We checked database side also no long running sessions, blocking sessions, and did not find any lag also. Please suggest where to start for the troubleshooting.