OGG Extract进程从经典模式（Classic mode）调整为集成模式（(integrated mode）

原创王维云和恩墨交付战队 2022-06-14

1971

目标：Oracle Golden Gate（for Oracle） extract进程从经典模式调整成集成模式。

1、停止extract进程

$./ggsci

GGSCI > stop irdcb

Sending STOP request to EXTRACT IRDCB ...
Request processed.

GGSCI > info irdcb

EXTRACT IRDCB Last Started 2019-11-26 16:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:01:17 ago)
Log Read Checkpoint Oracle Redo Logs
2019-11-27 07:02:27 Seqno 1396, RBA 643568640
SCN 0.75154190 (75154190)复制

2、设置extract进程为集成模式

GGSCI > register extract irdcb database

2019-11-27 14:59:01 INFO OGG-02003 Extract IRDCB successfully registered with database at SCN 75154232.

注册完成后暂时不能执行转换集成模式的步骤，原因是由于OGG的recovery SCN在注册的SCN之前，需要先启动下抽取进程，等待进程抽取SCN超过注册的SCN后，进行切换集成模式
GGSCI > info irdcb upgrade
ERROR: Extract IRDCB is not ready to be upgraded because recovery SCN 75154129 has not reached SCN 75154232.
在经典模式下启动抽取
GGSCI > start irdcb

Sending START request to MANAGER ...
EXTRACT IRDCB starting


GGSCI > info irdcb

EXTRACT IRDCB Last Started 2019-11-26 16:20 Status STARTING
Checkpoint Lag 00:00:00 (updated 00:03:44 ago)
Process ID 7333
Log Read Checkpoint Oracle Redo Logs
2019-11-27 07:02:27 Seqno 1396, RBA 643568640
SCN 0.75154190 (75154190)
观察SCN超过注册SCN后可以停止抽取
GGSCI > stop irdcb

Sending STOP request to EXTRACT IRDCB ...
STOP request pending end-of-transaction (5 records so far).

此时抽取的SCN已经超过注册时的SCN
GGSCI > info irdcb

EXTRACT IRDCB Last Started 2019-11-27 15:02 Status STOPPED
Checkpoint Lag 07:59:17 (updated 00:00:00 ago)
Log Read Checkpoint Oracle Redo Logs
2019-11-27 07:03:14 Seqno 1399, RBA 30402904
SCN 0.75165941 (75165941)
切换抽取进程到集成模式
GGSCI > alter extract irdcb, upgrade integrated tranlog
Extract IRDCB successfully upgraded to integrated capture.


GGSCI > info irdcb

EXTRACT IRDCB Initialized 2019-11-27 15:02 Status STOPPED
Checkpoint Lag 07:59:17 (updated 00:00:21 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2019-11-27 07:03:14
SCN 0.75165941
复制

3、启动extract进程

GGSCI > start irdcb

Sending START request to MANAGER ...
EXTRACT IRDCB starting


GGSCI > info irdcb

EXTRACT IRDCB Initialized 2019-11-27 15:02 Status RUNNING
Checkpoint Lag 07:59:17 (updated 00:03:36 ago)
Process ID 8771
Log Read Checkpoint Oracle Integrated Redo Logs
2019-11-27 07:03:14
SCN 0.75165941 (75165941)复制

至此OGG Extract进程模式切换完毕！