goldengate Archive

GoldenGate: Setting trail files auto purge and purging trails on demand

Introduction In today’s post, I will discuss about purging old trail files for a GoldenGate replication setup. GoldenGate generates two set of trail files. The first set is generated by the EXTRACT process after processing the transactions

OGG-01973: The redo record indicates data loss on object

Problem Description In one of our GoldenGate setup, the EXTRACT process got ABENDED with OGG-01973 error (The redo record indicates data loss on object) 2015-08-08 00:35:37 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, EX_MYPROD.prm: The redo record

Understanding Oracle GoldenGate Architecture

Introduction: GoldenGate is the Logical Replication solution provided by Oracle that can be used to replicate data across heterogeneous databases.   Overview of the Golden Gate Architecture: Oracle GoldenGateĀ provides the following methods for replication across multiple heterogeneous

Configure Goldengate DDL replication between Oracle Databases

Environment Used for the excersie: Source database : LABPA Target Database : LABPABR Listener Port : 1521 Source Schema : sender Target Schema : receiver Source Manager Port : 7809 Target Manager Port : 7809 GG_HOME=/opt/oracle/gg/12.1.2 –>

Installing Oracle 12c Goldengate on Linux x64

Considerations (Demo Environment) GG_HOME=/opt/oracle/gg/12.1.2 Oracle RDBMS Release 12c is already installed ORCALE_HOME (for 12c database)=/app/oracle/product/12.1.0 Step 1: Download the installation package from OTN For Linux x64 :   Step 2: unzip   Step 3: Move
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed