For non-Oracle DB, SQL Server is a sample description:
My train of thought
A:oracle DB production B:oracle DB Intermediate machine C:sqlserver db destination
a-> b->c Note: B on both the rep process also has the EXT process, at this time. There is also a need to establish a rep process for B.
A->b can complete the online initialization synchronization (EXPDP based on SCN number)
After the initialization of A->b, stop the rep process of B, at this time the B library is a static database, at this time B->c synchronization (using ETL Tools or SQL Server DTS, etc.)
When the initialization of the B->C is complete, the rep on B is turned on. Open the rep on C to form a-> b->c The three DB Ogg process is working.
Business Low Peak (in the dead of Night). When the ext lag on a is zero, ext on stop a waits for the DP on a. Rep on the B. Rep (from B) on Ext,c B has finished working---lag process name
Record the EXT read checkpoint on a and write the checkpoint.
Record the DP read checkpoint on a. --info DP Showch
On a, a new transport process dpatoc from A to C is established. Changes the read checkpoint of the Dpatoc.
Create a new repfroma on C to apply the trail file that Dpatoc sent over.
Oracle Goldengate initialization data synchronization from Oracle DB to non-Oracle DB
