配置了一套OGG,进程都在正常运行,但是测试新插入的数据无法同步到目标端。未发现有lag延时,日志里也无任何报错,trandata也是有的。rba也在一直变化,stats也有数据显示。检查时发现抽取进程的Recovery Checkpoint跟Current Checkpoint的时间不一致,但是我在数据库里并未查到长事务。请问这种要怎么处理。
Read Checkpoint #1
Oracle Threaded Redo Log
Startup Checkpoint (starting position in the data source):
Timestamp: 2019-07-03 23:53:56.000000
SCN: 3088.1555212182 (13264414222230)
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Timestamp: 2019-07-04 01:53:25.000000
SCN: 3088.1573595104 (13264432605152)
Current Checkpoint (position of last record read in the data source):
Timestamp: 2019-07-04 10:16:54.000000
SCN: 3088.1664330436 (13264523340484)
BR Previous Recovery Checkpoint:
Timestamp: 2019-07-04 00:25:20.853910
SCN: 0.0 (0)
BR Begin Recovery Checkpoint:
Timestamp: 2019-07-04 06:18:18.000000
SCN: 3088.1613129930 (13264472139978)
BR End Recovery Checkpoint:
Timestamp: 2019-07-04 08:25:21.000000
SCN: 3088.1631166624 (13264490176672)