The update operation nodes of GoldenGate are not synchronized -- Solution

The update operation nodes of GoldenGate are not synchronized.

Fault description: synchronization cannot be implemented after update is performed on node 1 and node 2.
Solution Process:
1. Regular inspection: Check the Process status: normal
GGSCI (gc1) 7> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
Extract running EORA_1 00:00:00 00:00:04
Extract running PORA_1 00:00:00 00:00:08
Replicat running RORA_1 00:00:00 00:00:05
Re-authorization:
SQL> grant INSERT, UPDATE, DELETE on scott. tcustmer to ogg;
-- Authorize the DML operation for table synchronization to ogg
SQL> grant INSERT, UPDATE, DELETE on scott. tcustord to ogg;
-- Authorize the DML operation for table synchronization to ogg
The fault persists.

2. perform the following operations: GGSCI (gc1) 8> add trandata scott .*
Note: first shut down the rora_1 process, add it, And then restart.
-- Two node operations: add trandata scott. New table. After setting, ogg will capture the log information of the new table.
To solve the fault, you can synchronize the update operation at two nodes.


3. Conclusion: If the newly created table is synchronized, the update operation may fail. perform the following operations,
In this way, ogg will capture the log information of the new table:
Operation Command: add trandata scott. new_tab

But note: first shut down the rora_1 process, add it, And then restart.

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.