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.