GoldenGate 指定时间点重新抽取事务变化(2)

NAME                                                                        FIRST_CHANGE# FIRST_TIME
--------------------------------------------------------------------------- ------------- -------------------
+ARCH/prod/archivelog/2014_11_03/thread_2_seq_12.295.862650053                    1484800 2014-11-02 17:41:26
+ARCH/prod/archivelog/2014_11_03/thread_1_seq_12.296.862650059                    1484803 2014-11-02 17:41:26
+ARCH/prod/archivelog/2014_11_03/thread_2_seq_13.297.862650071                    1514934 2014-11-03 09:00:52
+ARCH/prod/archivelog/2014_11_03/thread_1_seq_13.298.862650077                    1514938 2014-11-03 09:00:57
+ARCH/prod/archivelog/2014_11_03/thread_2_seq_14.299.862650079                    1514995 2014-11-03 09:01:10
+ARCH/prod/archivelog/2014_11_03/thread_1_seq_14.300.862650089                    1514999 2014-11-03 09:01:16
+ARCH/prod/archivelog/2014_11_03/thread_1_seq_15.301.862653569                    1515027 2014-11-03 09:01:28
+ARCH/prod/archivelog/2014_11_03/thread_2_seq_15.302.862653567                    1515017 2014-11-03 09:01:19
+ARCH/prod/archivelog/2014_11_03/thread_2_seq_16.303.862653581                    1526456 2014-11-03 09:59:27
+ARCH/prod/archivelog/2014_11_03/thread_1_seq_16.304.862653587                    1526452 2014-11-03 09:59:29
+ARCH/prod/archivelog/2014_11_03/thread_1_seq_17.305.862653599                    1526496 2014-11-03 09:59:47


6,删除目标端已经成功复制的100万条数据
SQL> truncate table t1;


7,抽取进程从2014-11-02 17:41:26再次抽取事务
GGSCI (node3) 2> stop ex1

GGSCI (node3) 3> ALTER EXTRACT ex1, TRANLOG, BEGIN 2014-11-02 17:41:26

GGSCI (node3) 5> start ex1

Sending START request to MANAGER ...
EXTRACT EX1 starting

GGSCI (node3) 6> info all

Program    Status      Group      Lag at Chkpt  Time Since Chkpt

MANAGER    RUNNING
EXTRACT    RUNNING    DP1        00:00:00      00:00:04  <<延时逐渐在减少
EXTRACT    RUNNING    EX1        19:41:40      00:00:03


GGSCI (node3) 8> info all

Program    Status      Group      Lag at Chkpt  Time Since Chkpt

MANAGER    RUNNING
EXTRACT    RUNNING    DP1        03:20:53      00:00:05  <<延时逐渐在减少
EXTRACT    RUNNING    EX1        03:20:52      00:00:06

GGSCI (node3) 9> info all

Program    Status      Group      Lag at Chkpt  Time Since Chkpt

MANAGER    RUNNING
EXTRACT    RUNNING    DP1        03:20:53      00:00:10  <<延时逐渐在减少
EXTRACT    RUNNING    EX1        00:00:01      00:00:00

目标端重新复制了100万条记录
SQL> select count(*) from t1;

COUNT(*)
----------
  1000000

GoldenGate单向表DML同步

Oracle GoldenGate 系列:Extract 进程的恢复原理

Oracle GoldenGate安装配置

Oracle goldengate的OGG-01004 OGG-1296错误

Oracle GoldenGate快速入门教程:基本概念和配置

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/47b383989f3ca80d841859bd0b81166c.html