当Oracle GoldenGate报告Lag未知或时间戳不匹配时，可能是由于时间戳差异导致的。本文介绍了如何通过添加用户令牌到测试表并使用logdump进行记录时间对比来排查问题，以及展示了Lag命令、'Info All'命令和'Checkpoint Lag'显示的可能情况。解决方案涉及检查时区差异可能导致的不预期Lag现象。
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
最低0.47元/天 解锁文章
749
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
