Skip to content

Oracle

Oracle Database as our consultants live it every day: installation and patching, upgrades, RMAN backup and recovery, Data Guard, RAC, performance tuning, multitenant, licensing, and engineered systems such as ODA and Exadata.

Oracle and btrfs snapshots

In my last blog post Snapshots with VirtualBox and btrfs we have seen some possibilities of btrfs snapshots. In this blog post we will see how we can use btrfs snapshots in combination with an Oracle database to clone PDBs. My colleague Marc Wagner has shown in his article the possibilities and the limitations of snapshot clones of a PDB.… 

Retrieving GoldenGate logs, reports, and diagnostics with the REST API

I often need to retrieve report files or logs from GoldenGate deployments, and I wanted to find ways of automating this. Hence this blog, about retrieving all available logs with GoldenGate REST API. I previously wrote about the GoldenGate log files. Some of them (extract.log, replicat.log and others) are in fact just filters of other logs (ggserr.log or restapi.log). These… 

Anatomy of an Enterprise Manager metric extension

Recently, I was working on deploying metric extensions automatically in Enterprise Manager, but the more I looked into it, the more it turned into a different question: what does a metric extension look like ? In a previous blog, I presented the SYSMAN tables containing the metric extensions definitions. I also showed how to retrieve the targets where a metric… 

How to detect a suspended GoldenGate extract

While testing EVENTACTIONS (SUSPEND) on an extract, I noticed that nothing in INFO tells you the process is suspended. The extract shows as RUNNING, the lag might look fine for a while, and yet it has stopped capturing. You may use SUSPEND on purpose (to pause an extract when a specific DDL goes by, for instance). Or someone else put… 

Import order matters for GoldenGate instantiation filtering

When migrating a large database with GoldenGate, most of the volume is sometimes in old partitions which no longer change. A common shortcut is to move them first with expdp/impdp, even before GoldenGate is set up. Everything else, the active partitions and the non-partitioned tables, is exported once the extract is running, with PREPARECSN set. Instantiation filtering then makes the… 

Removing instantiation filtering from a GoldenGate replicat

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 instantiation CSN. It applies everything above it. This replicat parameter should be kept during the whole initial load process. At some point the replicat has processed past the instantiation boundary for every table,… 

GoldenGate 26ai AutoSchema TYPEMAP: overriding the default datatype mapping

In my blog about the new automatic schema evolution feature in GoldenGate 26ai, I was replicating the following table from Oracle to PostgreSQL: The replicat created a PostgreSQL table from an Oracle one during an initial load. It worked, but one choice was not mine: the NUMBER primary key became a varchar(50). Automatic Schema Evolution takes its datatypes from a… 

GoldenGate 26ai automatic schema evolution: creating missing tables during an initial load

For as long as I have used GoldenGate, an initial load had one prerequisite: the target tables must already exist. Data Pump takes care of it between two Oracle databases. For anything else, you write the CREATE TABLE statements yourself, with the datatypes you choose, or choose another initial load method. The Automatic Schema Evolution feature launched in GoldenGate 26ai… 

SOUG Day October 2026

What a great and interesting day I could spent today at the SOUG Day which took place at the SIX ConventionPoint in Zurich. Thanks to the whole SOUG team for the great organization and to all the speakers for the interesting sessions. Oracle Database Mission-critical Technologies by Ashish Ray (Oracle) In his presentation, Ashish definitively confirmed that the new driver… 

AI meets OEM, let’s test Oracle AI Database Assistant

I have been recently blogging on how I have setup Oracle Enterprise Manager 24ai lab, installed an agent and finally configured Oracle AI Database Assistant. It’s time for me to test it now. Product evolution AI integration in Oracle Enterprise Manager 24ai was quite evolving rapidly. In a nutshell Oracle AI Database Assistant will help me interacting with OEM with…