Example of an external data experiment (2) Verify the synchronization between two nodes in Table bonus and table salgrade
The following articles are continued:
1. One-way replication configuration address for goldengate configuration (1): Click the open link
2. Configure goldengate (2) bidirectional replication configuration address: Click the open link.
3. DDL replication configuration address of goldengate configuration (3): Click to open the link.
4. Configure goldengate (4) configure the ingress data address: Click the open link.
5. Example of an external data experiment (1) Verify the synchronization between tcustmer and tcustord. Address: Click to open the link.
1. Execute job verification Synchronization
View the result. It is displayed that bonus and salgrade cannot be synchronized at two nodes, for example:
2. Check the report and find the following:
Table has no keys defined.-- Pre-prediction error because the primary key constraint is missing
Comparison terminated with errors.
3. Add a primary key for bonus and salgrade
SQL>Select constraint_name, index_name, table_name fromuser_constraints;
-- Check constraints. No primary key information is added for bonus and salgrade.
Constraint_name index_name table_name
-------------------------------------------------------------------------------
Fk_deptno EMP
Pk_dept Dept
Pk_emp EMP
Sys_c002941 sys_c002941 tcustmer
Sys_c002942 sys_c002942 tcustord
SQL>Alter table bonus add constraint pk_ename primarykey (ename); -- add a primary key for bonus
Table altered.
SQL>Alter table salgrade add constraint pk_grade primarykey (grade); -- add a primary key for salgrade
Table altered.
4. Execute job verification Synchronization
As shown in, the synchronization check is successful:
****************** ********
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.