關於整合抽取程式重啟後的現象分析

margiex發表於2017-12-18

當執行一個大的事務或資料量比較大時,停止整合抽取程式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文件,有看到如下一段說明

clip_image002

發現即使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

Ref: https://community.oracle.com/thread/3490542

相關文章