goldengate(ogg)日常维护

 

1.修改源端抽取进程从某个位置开始抽取(待验证)

GGSCI (rac01) 29> info extep

EXTRACT    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 Logs
                     2025-10-28 16:31:47  Thread 1, Seqno 219, RBA 40890880
                     SCN 0.17748557 (17748557)
Log Read Checkpoint  Oracle Redo Logs
                     2025-10-28 16:31:46  Thread 2, Seqno 170, RBA 2645504
                     SCN 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

 

会有scn不一样的情况

GGSCI (rac01) 44> info EP01

EXTRACT    EP01      Last Started 2025-10-28 16:33   Status STOPPED
Checkpoint Lag       00:00:02 (updated 00:00:02 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2025-10-28 16:44:40  Thread 1, Seqno 219, RBA 41773584
                     SCN 0.17750969 (17750969)
Log Read Checkpoint  Oracle Redo Logs
                     2025-10-28 16:44:39  Thread 2, Seqno 170, RBA 3094016
                     SCN 0.17750972 (17750972)