Example of an external data experiment (3) Verify that the insert operation caused by external data is different.

Example of the external data experiment (3) Verify that external data finds out the non-synchronization caused by the insert operation. Continue: Example of the external data experiment (2) Verify the two-node synchronization between the table BONUS and table SALGRADE. Address: click to open the link environment: ItemSourceSystemTargetSystemPlatformRedHatEnterpriseLinuxServerrel

Example of the external data experiment (3) Verify that external data finds out the non-synchronization caused by the insert operation. Continue: Example of the external data experiment (2) Verify the two-node synchronization between the table BONUS and table SALGRADE. Address: click to open the link environment: Item Source System Target System Platform Red Hat Enterprise Linux Server rel

Example of an external data experiment (3) Verify that external data finds out the non-synchronization caused by the insert operation

Extension: Example of the external data experiment (2) synchronization between the BONUS table and the SALGRADE table. Address: Click to open the link.

Environment:

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. Disable the REPLICAT process of gc2

GGSCI (gc2) 2>Stop RORA_1

Sending STOP request to REPLICAT RORA_1...

Request processed.

GGSCI (gc2) 3>Info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

Extract running EORA_1 00:00:00 00:00:06

Extract running PORA_1 00:00:00 00:00:05

Replicat stopped RORA_1 00:00:00 00:00:06

2. gc1 inserts a row of data

SQL>Insert into tcustmerVALUES ('zx', 'x', 'shijiaz', 'cn ');

1 row created.

SQL>COMMIT;

Commit complete.

3. Use external data to verify gc1 and gc2 synchronization 4. view external data generation report

View By Compare Pair shows the overall change chart:

View the job of the experiment, for example:

Click View To View Details:

5. synchronous processing

GGSCI (gc2) 6>Start RORA_1

Sending START request to MANAGER...

REPLICAT RORA_1 starting

GGSCI (gc2) 7>Info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

Extract running EORA_1 00:00:00 00:00:05

Extract running PORA_1 00:00:00 00:00:03

Replicat running RORA_1 00:00:00 00:00:01

Verify that gc1 and gc2 have been synchronized as follows:

Gc1:

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

Gc2:

CUST NAME CITY ST

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

HYL HUANGDBA BEIJING CN

ZC ZHANCHI DBA BEIJING CN

ZX XING SHIJIAZ CN

Will bg software co. SEATTLE WA

Jane rocky flyer inc. DENVER CO

Verify with external data again and the data has been synchronized.

****************** ********

Statement:
Original works, from "Deep Blue blog" blog, allow reprint, reprint please be sure to indicate the source (http://blog.csdn.net/huangyanlong ).

The author has the right to pursue legal liability for copyright issues.