oracle-golden-gate

ORACLE Golden Gate Classic Installation location relative to Source DB


From reading the docs, which are not to the point imho, when wanting to extract from a Source Oracle DB:

That is not clear to me from the docs.

Looking at this from licensing cost issues on big db server. Sure, we can shareplex to another machine.

Picture provided:

enter image description here


Solution

  • All three scenarios are supported. Migrating log files from one machine to another is referred to as Downstream Capture and using GoldenGate on one machine to capture from the DBMS over the network is referred to as Remote Capture.

    In addition, with Oracle GoldenGate 19.1 for Oracle, you can capture across operating systems. This means you can run GoldenGate on a Linux machine to capture data from your AIX DBMS environment.