Oracle Dataguard Broker 12c with password file in ASM

Configure 12c dataguard broker using the below command onPrimary database server primeprd - > tnsnames for primary database primedr-> tnsnames for standby database /home/oracle::11g-->dgmgrl DGMGRL> connect sys/******** DGMGRL> create configuration dg_primeprd as primary database is primeprd connect identifier is primeprd; DGMGRL> add database primedr as connect identifier is primedr maintained as physical; Configuration "dg_primeprd" created … Continue reading Oracle Dataguard Broker 12c with password file in ASM

Active – Active (Bi-Directional) Replication using Oracle Golden Gate 12c

Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The adoption of GoldenGate over Streams has been quite Rapid. The complexity of Streams has intimidated many adopters, specially for Multi-Master or Peer-to-Peer Replication. GoldenGate not only makes MultiMaster Replication easy but is so full of … Continue reading Active – Active (Bi-Directional) Replication using Oracle Golden Gate 12c

Schema Replication using Oracle Goldengate 11g (Installation & Configuration)

GoldenGate is touted by Oracle as its future for data replication. It will slowly phase out Oracle Streams and will be more closely coupled with Oracle products. Golden Gate is relatively simpler to use and monitor than Oracle streams. Below I will demonstrate how to configure ASYNC Schema Replication one side using Oracle GoldenGate 11g … Continue reading Schema Replication using Oracle Goldengate 11g (Installation & Configuration)