首页 > 代码库 > veridata实验举例(4)验证veridata查找出updata、delete操作导致的不同步现象

veridata实验举例(4)验证veridata查找出updata、delete操作导致的不同步现象

 veridata实验举例(4)验证veridata查找出updata、delete操作导致的不同步现象

续接:《veridata实验举例(3)验证veridata查找出insert操作导致的不同步现象》,地址:点击打开链接

环境:

Item

Source System

Target System

Platform

Red Hat Enterprise

Linux Server release 5.4

Red Hat Enterprise

Linux Server release 5.4

Hostname

gc1

gc2

Database

Oracle 10.2.0.1

Oracle 11.2.0.1

Character Set

ZHS16GBK

ZHS16GBK

ORACLE_SID

PROD

EMREP

Listener Name/Port

LISTENER/1521

LISTENER/1521

Goldengate User

ogg

ogg



1、继续实验3环境,关闭同步进程,在gc1上进行updata、delete操作

SQL>select * from TCUSTMER;

CUST NAME                           CITY                 ST

---- -------------------------------------------------- --

HYL  HUANGDBA                      BEIJING              CN

ZX  XING                           SHIJIAZ              CN

WILL BG SOFTWARE CO.               SEATTLE              WA

JANE ROCKY FLYER INC.              DENVER               CO

ZC  ZHANCHI DBA                    BEIJING              CN

SQL>delete from tcustmer where CUST_CODE=‘ZX‘;

1 row deleted.

SQL>update tcustmer set city = ‘ZHENGZHOU‘, state = ‘CN‘where cust_code=‘ZC‘;

1 row updated.

SQL>commit;

Commit complete.

SQL>select * from TCUSTMER;

CUST NAME                           CITY                 ST

---- -------------------------------------------------- --

HYL  HUANGDBA                       BEIJING              CN

WILL BG SOFTWARE CO.                SEATTLE              WA

JANE ROCKY FLYER INC.               DENVER               CO

ZC  ZHANCHI DBA                     ZHENGZHOU            CN

2、使用veridata验证gc1、gc2同步情况


3、查看veridata生成报告




点击上图中“View”选项,查看到详细情况,如下图所示:




--通过详情信息得知,由于gc1的update、delete操作,导致了两节点上的实验表数据不同步

4、同步处理

GGSCI(gc2) 10> info all

Program    Status      Group       Lag           Time Since Chkpt

MANAGER    RUNNING                                          

EXTRACT    RUNNING     EORA_1      00:00:00      00:00:02   

EXTRACT    RUNNING     PORA_1      00:00:00      00:00:00   

REPLICAT   STOPPED     RORA_1      00:00:00      00:10:55   

GGSCI(gc2) 11> start RORA_1

Sending START request to MANAGER ...

REPLICAT RORA_1 starting

GGSCI(gc2) 12> info all

Program    Status      Group       Lag           Time Since Chkpt

MANAGER    RUNNING                                          

EXTRACT    RUNNING     EORA_1      00:00:00      00:00:01   

EXTRACT    RUNNING     PORA_1      00:00:00      00:00:00   

REPLICAT   RUNNING     RORA_1      00:10:34      00:00:02   

gc2:

SQL>select * from TCUSTMER;

CUST NAME                           CITY                 ST

---- -------------------------------------------------- --

HYL  HUANGDBA                      BEIJING              CN

ZC  ZHANCHI DBA                    ZHENGZHOU            CN

WILL BG SOFTWARE CO.               SEATTLE              WA

JANE ROCKY FLYER INC.              DENVER               CO

gc1:

SQL>select * from TCUSTMER;

CUST NAME                           CITY                 ST

---- -------------------------------------------------- --

HYL  HUANGDBA                      BEIJING              CN

WILL BG SOFTWARE CO.               SEATTLE              WA

JANE ROCKY FLYER INC.              DENVER               CO

ZC  ZHANCHI DBA                    ZHENGZHOU            CN

--完成同步

再次使用veridata验证,已经同步。




********************未完待续**************************

声明:
         原创作品,出自 “深蓝的blog” 博客,允许转载,转载时请务必注明出处(http://blog.csdn.net/huangyanlong)。

         关于涉及版权事宜,作者有权追究法律责任。