veridata实验举例（5）修改主键上的列值，update操作会被拆分成两条语句

1、模拟实验环境，使gc1、gc2数据不同步，对gc2上主键列作update操作

GGSCI(gc1) 7> stop RORA_1

Sending STOP request to REPLICAT RORA_1 ...

Request processed.

GGSCI(gc1) 8> 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:05   

REPLICAT   STOPPED     RORA_1      00:00:00      00:00:01   

gc2：

SQL>update TCUSTMER set CUST_CODE=‘NEW‘ WHERENAME=‘ROCKY FLYER INC.‘; --gc2上updata操作

SQL>commit;

SQL>select * from TCUSTMER where CUST_CODE=‘NEW‘;

CUST_CODE NAME                          CITY                 ST

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

NEW       ROCKY FLYER INC.              SHANGHAI             CO

gc1：

SQL>select * from TCUSTMER where CUST_CODE=‘NEW‘; --gc1查询，没有同步更改，查询不到

no rows selected

SQL>select * from TCUSTMER where CUST_CODE=‘JANE‘;--gc1上保留的依然是原数据

CUST_CODE NAME                          CITY                 ST

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

JANE      ROCKY FLYER INC.              SHANGHAI             CO

2、运行veridata显示结果，如下：

--veridata捕捉到的不是update操作，而是将其拆分成了insert操作、delete操作

小结：

    由上可知，当update主键所在的列时，veridata无法捕获出这是update操作，而是通过对比两张表，将update操作拆分成insert操作、delete操作。

3、处理同步

GGSCI(gc1) 10> start RORA_1

Sending START request to MANAGER ...

REPLICAT RORA_1 starting

GGSCI(gc1) 11> 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   RUNNING     RORA_1      00:12:48      00:00:02   

SQL> select * from TCUSTMER where CUST_CODE=‘NEW‘;

CUST_CODE NAME                          CITY                 ST

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

NEW       ROCKY FLYER INC.              SHANGHAI             CO