OGG Classic模式/integrated模式 之间的切换

zhouwei1990

1.Classic模式到integrated模式
GGSCI (ogg@ogg-test) 1> stop extnd
GGSCI (ogg@ogg-test) 2> register extract extnd database  
GGSCI (ogg@ogg-test) 3> alter extract EXTND, upgrade integrated tranlog, begin now
GGSCI (ogg@ogg-test) 4> start extnd

GGSCI (ogg@ogg-test) 5> info extnd

EXTRACT    EXTND     Last Started 2018-01-05 23:41   Status RUNNING
Checkpoint Lag       00:00:02 (updated 00:00:05 ago)
Process ID           2826
Log Read Checkpoint  Oracle Integrated Redo Logs
                     20168-01-05 23:42:31
                     SCN 0.481435 (481435)



2. integrated模式到Classic模式
GGSCI (ogg@ogg-test) 12> stop extnd
GGSCI (ogg@ogg-test) 13> alter extract extnd, downgrade tranlog
GGSCI (ogg@ogg-test) 14>  unregister extract extnd database
GGSCI (ogg@ogg-test) 15> start extnd
GGSCI (ogg@ogg-test) 16> info extnd

EXTRACT    EXTND   Last Started 2018-01-05 23:46   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:01 ago)
Process ID           2859
Log Read Checkpoint  Oracle Redo Logs
                     First Record         Seqno 56, RBA 28277264
                     SCN 0.481558 (481558)


总结：
UPGRADE INTEGRATED TRANLOG  实现从classic capture mode 到 integrated capture mode
            ALTER EXTRACT finance, UPGRADE INTEGRATED TRANLOG
DOWNGRADE INTEGRATED TRANLOG 实现从integrated capture mode 到 classic capture mode
            ALTER EXTRACT finance, DOWNGRADE INTEGRATED TRANLOG