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…
Translating 4,000 Oracle views, rebuilding indexes offline on Standard Edition, and compressing clustered index to save 1T.
When migrating a Coordinated Replicat for a client, I faced a very specific OGG-02454 error that I wanted to share. When using the migration utility on a Classic Architecture Coordinated Replicat, every attempt failed at the checkpoint conversion step with OGG-02454 Trail … not found in checkpoint file. Because the migration utility rolls back the entire migration on any hard…
In a previous blog, I went through the full procedure of renaming a GoldenGate extract from the adminclient. I included all necessary steps to avoid missing transactions. Doing this by hand is completely fine, but if you do it often, or want to remove the risk of a typo on an SCN, I have another solution for you. In this…
Throughout my consulting missions, I have often been asked to rename GoldenGate extracts. While this is not a difficult task, it should still be done correctly to avoid missing transactions. In this blog, I will explain how to rename a GoldenGate extract from the adminclient. If you often rename extracts, or want to remove the risk of a typo on…
Upgrading GoldenGate when the source is DB2 for z/OS is not quite the same exercise as upgrading a GoldenGate installation for Oracle. Most of what I described in my generic blogs about planning a GoldenGate upgrade and migrating from Classic to Microservices Architecture is still valid. However, there is an extra layer to deal with. It has to do with…
Every time I work on database migrations with GoldenGate, I have the same talks with application teams about missing primary keys. Especially when it comes to LOB replication with GoldenGate. In a previous blog, I wrote about how to interpret the DBA_GOLDENGATE_NOT_UNIQUE view, which lists tables with no primary key or non-null unique indexes. There are two main groups of…
The GoldenGate migration utility provided by Oracle allows you to quickly upgrade your classic architecture into GoldenGate 26ai with Microservices Architecture. But even after some updates, it still has a few bugs, as I explained in a previous blog post. One of them can lead to an OGG-15409 error during the migration. This error will not appear when running the…
While migrating a GoldenGate classic architecture setup with the migration utility, I recently had the following OGG-12020 error: It is a very cryptic error at first glance, but let’s try to understand what happened. Where does the error come from ? The first step is to understand what is causing the issue. For this, you need to understand how the…
When running the GoldenGate migration utility, which I presented in a previous blog post, you might encounter the following warning on USERID syntax: This is not really a surprise, since USERID is an old syntax that should not be used anymore. In fact, it is not even part of the latest versions of GoldenGate. Let’s see a very basic example…
Depending on the location of your GoldenGate trail files, you might have to use the convchk utility to relocate them before migrating to the Microservices Architecture. Oracle has the following restrictions for using the migration utility: Absolute path names for trail files. Classic trail file MUST reside in ./dirdat (or a subdirectory within it). If the trail file reside in another directory,…
I have been asked to migrate a customer environment from WildFly 26 to WildFly 38. That’s a meaningful upgrade, not just a version bump, because WildFly 38 represents the latest stable baseline with modern Jakarta EE support, updated security, and long-term compatibility with modern Java runtimes like OpenJDK 17… Before we dive into commands and configurations, let’s anchor this in…
