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

Source: Internet
Author: User
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.


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.