#oracle

When migrating a large database with GoldenGate, most of the volume is sometimes in old partitions which no longer change.

In a recent blog, I explained how instantiation filtering works. DBOPTIONS ENABLE_INSTANTIATION_FILTERING makes a replicat discard any record whose commit CSN is at or below a table's…

For more than ten years (GoldenGate 12.2, released in 2015), GoldenGate has provided a way of performing initial load of tables with a per-table instantiation CSN.

When replicating data with GoldenGate, you often want DDL changes (table alterations, new tables, dropped indexes, etc.) to follow alongside DML.

I recently wanted to work on Metric Extensions automation, and realized the task was a bit more complicated than I thought. My original idea was to look into the emcli verb list, but I was unlucky.

When doing complex operations with GoldenGate, checking for long running transactions is mandatory if you don't want to miss transactions.

Among all the automation I was doing around a GoldenGate installation for DB2, I recently ended up with an INS-85037 error when running the configuration assistant oggca.sh.

When patching GoldenGate Classic Architecture, you might encounter an OGG-08048 error when restarting your extracts and replicats.

Oracle Cloud Infrastructure (OCI) provides an easy-to-use command line interface named oci, with which you can do a lot of administrative tasks.

Another day, another not-so-documented GoldenGate error, this time about the OGG-10556 error, which I had when setting up replication on a new GoldenGate installation.

If you start using the GoldenGate web UI after installing it, you might end up thinking that extending the session timeout would be nice.

Very quick piece of blog today to tackle the OGG-00423 error. There is not much information online on the matter, and the official Oracle documentation doesn't help.

I was recently setting up GoldenGate for a client when I was struck by a ORA-44001 error.

*26ai update: This article was originally written for 23ai. But not much changes when setting up GoldenGate 26ai.

If you've ever had to deal with MongoDB after years (or even decades) of working with SQL, you've probably realized that querying JSON documents can sometimes be painful, to say the least.