Oracle Standard Edition and GoldenGate for replication?
The Question:
Can GoldenGate run in a Standard Edition RAC ==> Enterprise Edition standalone environment and perform the required rule-based replication without requiring an upgrade of our RAC Standard Edition to RAC Enterprise Edition?
The environment:
Source System: 2-node RAC running Standard Edition 10.2.0.5 (RHEL5 x86-64)
Target System: 1-node running Enterprise Edition 11.2.0.1 (RHEL5 x86-64)
The requirement:
Lossless one-way replication in "real time" of selected schema while excluding selected DDL/DML based on multiple rules.
Present solution:
LogMiner, but there is a known LogMiner bug (p8977287) that causes data loss when one RAC node goes down or is evicted from the cluster. The bug is reportedly patched in 11.2.0.2 and is slated to be fixed in 12.x.
Thx.