How to initialize data synchronization between Oracle GoldenGate and non-oracle db, goldengateoracle
SQL Server is used as an example for non-oracle databases:
My ideas
A: oracle db production B: oracle db intermediate machine C: sqlserver db target end
A-> B-> C note: There are both rep and ext processes on B. At this time, C also needs to establish rep processes for B.
A-> B can complete initialization and synchronization online (expdp Based on scn)
After initialization of A-> B, stop the rep process of B. Database B is A static database, and B-> C is synchronized at this time (etl tools or sqlserver dts are used)
After the initialization and synchronization of B-> C are complete, enable rep on B and rep on C, the formation of A-> B-> C, the three db ogg processes are working. When rep lag on B is set to zero and ext lag on B is set to zero, and rep lag on C is set to zero, after ext lag on a is set to zero, stop ext on A and dp on. Record the ext reading checkpoint on A at this time, and record the dp reading checkpoint on A at this time.
Create A new transmission process dpatoc from A to C on A and modify the reading checkpoint of dpatoc. Create a repfromA on C to apply the trail file transmitted by dpatoc.
Synchronization of GoldenGate and sequence in oracle
It may be because the sequence parameters on the target and the source are different. The source is nocache, the target is cache, or the cache_size settings are different.
Does your goldengate support DDL? We recommend that you pay attention to the DSG Realsync ORACLE data synchronization software.
Recently, in the test of GoldenGate data synchronization, it was found that the latency in sub-seconds could not reach the level of oracle, which basically fluctuated between 10-4 seconds.
What is the normal read/write transmission between hard disk I/O and network on key two servers? This is the bottleneck