goldengate(ogg)日常维护

 

1.修改源端抽取进程从某个位置开始抽取

GGSCI (rac01) 29> info extepEXTRACT    EXTEP     Last Started 2025-10-28 16:24   Status STOPPED
Checkpoint Lag       00:00:03 (updated 00:00:36 ago)
Log Read Checkpoint  Oracle Redo Logs2025-10-28 16:31:47  Thread 1, Seqno 219, RBA 40890880SCN 0.17748557 (17748557)
Log Read Checkpoint  Oracle Redo Logs2025-10-28 16:31:46  Thread 2, Seqno 170, RBA 2645504SCN 0.17748557 (17748557)SQL> SELECT to_char(SCN_TO_TIMESTAMP(17748557),'YYYY-MM-DD HH24:MI:SS') FROM DUAL;TO_CHAR(SCN_TO_TIME
-------------------
2025-10-28 16:31:47某个位置开始抽取
ALTER EXTRACT extep, SCN 17748557