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

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验证，已经同步。