Monthly Archive: December 2014

OGG-02077 Oracle GoldenGate Capture for Oracle, Extract encountered a read error in the asynchronous reader thread and is abending: Error code 4031

Extract encountered a read error in the asynchronous reader thread and is abending: Error code 447, error message: ORA-00447: fatal error in background process.

 

Recently I configured a report server. Used Oracle GoldenGate 12c Integrated Mode for the Real Time Replication from Production server. Nearly I configured the replication for more than 7 Schemas and size of each schema was more than 300 GB.
Continue reading…

OGG-02028 Failed to attach to logmining server Error code 1304

OGG-02028  Failed to attach to logmining server Error code 1304, error message: ORA-01304: subordinate process error

In this post, I would liketo share my experience of an error which I had faced recently.

For a project, I Configured Oracle GoldenGate 12c Integrated Mode for replicating between two Oracle Databases. I faced an issue and the Integrated Extract got ABENDED due to the below Error.
Continue reading…

Oracle GoldenGate Initial Load Techniques

What is GoldenGate Initial Load?

Before Starting any Oracle GoldenGate Online Replication, we should see to that  both Source and Target are in Sync. There are different techniques or methods to achieve this.

The GoldenGate offers a technique called Initial Load which is used to synchronize both Source and Target databases. This is the first step in the Oracle GoldenGate data replication.

An amazing feature given by the GoldenGate is the ability for the Change Synchronization that keeps track of the Online transactional change during the Initial Load is being run. These change synchronization processes runs concurrently with the Initial Load which are later reconciled with the Initial Load.
Continue reading…

What is Oracle GoldenGate?

Introduction to Oracle GoldenGate

 

  • It is the strategic replication tool for Oracle database and also for Heterogeneous databases. It means data can be replicated to one another, independent of the database platforms.
  • It is a strategic solution for Real Time Data Integration.
  • It enables mission critical systems to have continuous availability and access to real-time data.
  • It offers a fast and robust solution for replicating transactional data between operational and analytical systems.

Continue reading…