日常维护)
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