Oracle 11g replication: Proof of concept
The challenge was to design an alternative replication concept for Oracle 11g databases that are currently using Oracle advanced replication. The used solution lacked in replicating DDL changes, was difficult to maintain and the used Oracle streams became deprecated with Oracle 12c. The requirements for the new concept with Dell Shareplex included an implementation of security policies that were implemented using Oracle VPD, the detection of geometry changes, DDL replication and supporting complex multi-master-processes with advanced filtering and simple ETL-tasks. For the final presentation, a NodeJS server was set up to run automated SQL unit tests with multi-host support. This tool allowed the execution of sql commands on one Oracle, monitoring of Dell Shareplex activities and the verification based on expected results on the target Oracle.