1- One of the obsolete integrated extract was causing Rman not to delete expired archive logs. orcl:/u02/DBA/scripts ->./delete_arch.sh The Oracle … More
Category: GoldenGate
GoldenGate numeric data validation with REGEXP
Here is a simple validation mapping to verify if the value in the trail file is numeric. I had to … More
Install and Configure Oracle GoldenGate 12.3 Microservices Architecture
The objective of this document is to demonstrate how to install and configure the new Oracle 12.3 GoldenGate Microservices Architecture. … More
Replicat abending with database error 1403
Replicat abending with database error 1403() during the initial startup during a compressed update. This error can be seen very … More
Purge DDL tables in GoldenGate for multiple instances
When setting up a DDL replication in Integrated Capture there are couple tables that gets populated on a regular basis, … More
Script to add trandata for GoldenGate
Here is a simple script to check which tables are missing trandata and generate the GG (so call DDL) to … More
GGSCI Commands
Commands ggsci> HELP [command] [object] ggsci> help GGSCI Command Summary: Object: Command: SUBDIRS … More
