ogg 查看某条更新_OGG抽取进程异常问题排查一例

GGSCI (xxxdb) 7> alter extract EXT1 ,tranlog ,begin 2018-05-07 23:13:49EXTRACT altered.

GGSCI (xxxdb)8>start EXT1

Sending START request to MANAGER ...

EXTRACT EXT1 starting

GGSCI (xxxdb)9> infoEXT1

EXTRACT EXT1 Initialized2018-05-28 17:28Status RUNNING

Checkpoint Lag498:14:13 (updated 00:00:10ago)

Log Read Checkpoint Oracle Redo Logs2018-05-07 23:13:49 Seqno 0, RBA 0SCN0.0 (0)

GGSCI (xxxdb)12> infoEXT1

EXTRACT EXT1 Last Started2018-05-28 17:28Status RUNNING

Checkpoint Lag498:13:54 (updated 00:00:09ago)

Log Read Checkpoint Oracle Redo Logs2018-05-07 23:14:31 Seqno 5331, RBA 834580564SCN3439.4180220954 (14774572751898)

GGSCI (xxxdb)13> infoall

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EXT1498:09:51 00:00:03EXTRACT RUNNING PUMP1498:10:04 00:00:04GGSCI (xxxdb)14> i