Example (6) verify whether the agent startup sequence affects the capture update operation

Example of an external data experiment (6)Verify whether the agent startup sequence affects the capture update operation.

Next to the external data experiment series: "Example of the external data experiment (5) modify the column value on the primary key, and the update operation will be split into two statements", 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

Case 1: when the agent is disabled and gc1 and gc2 do not synchronize data, enable agent1, gc1, and gc2 to disable the agent.

GGSCI (gc1) 6>Info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

GGSCI (gc1) 7>Stop mgr

Manager process is required by other GGSprocesses.

Are you sure you want to stop it (y/n )?Y

Sending STOP request to MANAGER...

Request processed.

Manager stopped.

GGSCI (gc1) 8>Info all

Program Status Group Lag Time Since Chkpt

MANAGER STOPPED

2. gc1 completes the update operation

SQL>Update TCUSTMER set city = 'Ha 'where cust_code = 'JJ ';

3. Start the agent and view the published data report.

Legend:

-- Upload data captures the update operation on gc1.

-- Similarly, in the gc2 experiment, the update operation information is also captured by the upload data, which is the same as that in gc1.

 

Case 2: The agent is enabled normally. If data is not synchronized between gc1 and gc2, enable agent2 and gc1 to complete the update operation.

SQL>Update TCUSTMER set city = 'beijing' where cust_code = 'zc ';

3. view the external data report

Legend:

-- Upload data captures the update operation on gc1.

-- Similarly, in the gc2 experiment, the update operation information is also captured by the upload data, which is the same as that in gc1.

 

Summary:

Compared with Database Synchronization,Start agentWill not affect the capture update of secondary data.

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.