Issue:
Why does GoldenGate report the Lag is unknown? The "Lag" command fails with "Timestamp Mismatch". Sometimes the "Info All" will also show the Lag is unknown.
How to troubleshoot the problem?
Add a user token to a test table.
e.g.,
table scott.emp, tokens (tkn-time = @DATENOW());
Next, do a dml on this table and commit.
Then, check with logdump (set: usertokens detail) to compare the record commit time (this is from redo log) and the token (from os time when extract processes the record). if former time