重庆思庄Oracle、Redhat认证学习论坛

标题: OGG Classic模式/integrated模式之间的切换 [打印本页]

作者: zhouwei1990 时间: 2018-1-12 17:15
标题: OGG Classic模式/integrated模式之间的切换
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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)