How to initialize Data Synchronization from OracleGoldenGate to non-oracledb
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.
