當執行一個大的事務或資料量比較大時,停止整合抽取程式ex1,發現不能停止,然後直接kill,此時,再start ex1,發現ex1是running狀態,但checkpoint lag一直在增加,也獲取不到SCN。然後再
kill ex1,
alter ex1, begin now,
start ex1,
info ex1
檢視之後,仍然是相同的情況。
GGSCI (WIN7ora as src_ogg@orcl) 407> info ex1 EXTRACT EX1 Last Started 2017-11-29 09:23 Status RUNNING Checkpoint Lag 00:00:10 (updated 00:00:08 ago) Process ID 3854 Log Read Checkpoint Oracle Integrated Redo Logs 2017-11-29 09:24:02 SCN 0. (0) |
經分析,應該是整合抽取的讀取點有記錄在DB的某個系統表裡,造成,即使修改begin now,也不起作用。經查詢ogg reference文件,有看到如下一段說明
發現即使alter ex1, begin now之後,上面的first scn也未變化,所以此引數無法調整抽取程式的讀取點,即不能跳過某些日誌或事務。
簡單的delete程式之後,重新add extract,結果相同。
最終,將程式unregister extract ex1 database之後,再重新register,first scn有發生變化。
GGSCI (WIN7ora as src_ogg@orcl) 407> info ex1 EXTRACT EX1 Last Started 2017-11-29 10:23 Status RUNNING Checkpoint Lag 00:00:10 (updated 00:00:08 ago) Process ID 3856 Log Read Checkpoint Oracle Integrated Redo Logs 2017-11-29 14:58:42 SCN 0.6794325 (6794325) |
停止程式提示處於recovery狀態
GGSCI (WIN7ora as src_ogg@orcl) 408> stop ex1 Sending STOP request to EXTRACT EX1 ... STOP request pending. Recovery is not complete. This normal stop will wait and checkpoint recovery's work when recovery has finished. To force Extract to stop now, use the SEND EXTRACT EX1, FORCESTOP command.. |
GGSCI (WIN7ora as src_ogg@orcl) 409> info ex1 EXTRACT EX1 Last Started 2017-11-29 10:23 Status RUNNING Checkpoint Lag 00:00:09 (updated 00:00:01 ago) Process ID 3856 Log Read Checkpoint Oracle Integrated Redo Logs 2017-11-29 14:59:04 SCN 0.6794344 (6794344) |
GGSCI (WIN7ora as src_ogg@orcl) 406> send ex1, status Sending STATUS request to EXTRACT EX1 ... EXTRACT EX1 (PID 3856) Current status: In recovery[1]: Processing data Current read position: Redo thread #: 1 Sequence #: 0 RBA: 0 Timestamp: 2017-11-29 09:50:36.000000 SCN: 0.0 (0) Current write position: Sequence #: 0 RBA: 0 Timestamp: 2017-11-29 10:23:14.560000 Extract Trail: ./dirdat/ea |
GGSCI (WIN7ora as src_ogg@orcl) 432> send ex1, status Sending STATUS request to EXTRACT EX1 ... EXTRACT EX1 (PID 1304) Current status: In recovery[1]: Processing data Current read position: Redo thread #: 1 Sequence #: 3221 RBA: 7516312 Timestamp: 2017-11-29 14:59:13.000000 SCN: 0.6794348 (6794348) Current write position: Sequence #: 0 RBA: 0 Timestamp: 2017-11-29 10:23:14.560000 Extract Trail: ./dirdat/ea |
GGSCI (WIN7ora as src_ogg@orcl) 439> send ex1, status Sending STATUS request to EXTRACT EX1 ... EXTRACT EX1 (PID 2528) Current status: Recovery complete: Processing data Current read position: Redo thread #: 1 Sequence #: 3221 RBA: 9566584 Timestamp: 2017-11-29 15:01:06.000000 SCN: 0.6794877 (6794877) Current write position: Sequence #: 45 RBA: 3074 Timestamp: 2017-11-29 15:01:05.188000 Extract Trail: ./dirdat/ea |