Well, that might be a long post…..lol I’ve heard it for years. And every time I hear it, I smile… READ MORE
Why Logdump Matters Every Oracle GoldenGate deployment depends on trail files, the immutable record of changes moving between systems. While… READ MORE
I put together a handy script that reproduces the Data Definition Language (DDL) for an existing GoldenGate user. This friendly… READ MORE
Every once in a while, I’ve gotten a question about what are the main advantages of Microservices Architecture over Classic… READ MORE
When Oracle GoldenGate encounters tables without a primary key (PK) for data replication, it has different approaches depending on the… READ MORE
From time to time you might need to find out where a particular transaction is in the redo logs. Most… READ MORE
This is a quick setup of a goldenGate HUB in Docker with an Extract from a 12.2 Oracle database and… READ MORE
RMAN command to create level 0 backup which is needed before running of incremental backup RMAN> BACKUP INCREMENTAL LEVEL 0… READ MORE
There are couple of ways to determine if RMAN database is registered with a catalog. Using RMAN when you connect… READ MORE
When using VALIDATE option, Oracle will validate backup and not create backups and will not restore when this option is… READ MORE
To move/rename current block change tracking file, one would need to restart the database. # Get current block change tracking… READ MORE
Backup in RMAN can be compressed when they are being created. Using the following command one can compress backup to… READ MORE
Starting RMAN with check syntax will check syntax of RMAN command, it will report errors if the syntax is incorrect.… READ MORE
Scenario when all control files for some reason have been lost. The following scenario shows how to restore controlfile and… READ MORE
Restore spfile through RMAN, here are some scenerios/examples. There are some pre-requites, the database would need to be in nomount… READ MORE
“Control what I can control”
~ Alex Lima