According to the Oracle database documentation there are two types of constraints: DEFERRED and NOT DEFERRED. The first one can be evaluated at the and of the transaction, and the second one if validated immediately. On the other hand Oracle GoldenGate can handle the replication when the target uses both of them. Let’s find out […]
How Oracle GoldenGate Replicat handles Foreign Key Constraints Read More »
In my previous post I have analyzed what happens if you would like to prevent archive logs from deletion so that they can be further processed by Oracle GoldenGate. I have assumed that it would work the same if the RMAN recovery catalog was being used. Lets find out what happens.
Oracle GoldenGate Classic Extract together with RMAN recovery catalog Read More »
Not many people are aware that recently UKSUG (aka UK Sybase User Group) has published on Vimeo their videos from TechSelect 2017.
UKSUG 2017 videos availabe on Vimeo (SAP/Sybase ASE) Read More »
A script to check the health of SAP Replication Server (Sybase RS) server for Nagios.
Nagios script for checking SAP Replication Server (Sybase RS) Read More »
A script to check the health of SAP Adaptive Server Enterprise (Sybase ASE) server for Nagios.
Nagios script for checking SAP Adaptive Server Enterprise (Sybase ASE) Read More »
This is a follow up of my previous article about an analysis of all Extract parameters for Oracle GoldenGate 11.2 and 12.1. It is a comprehensive analysis of how the parameters UPDATERECORDFORMAT COMPACT|FULL, (NO)COMPRESSUPDATES, (NO)COMPRESSDELETES, (IGNORE)GETUPDATEBEFORES and also (NO)LOGALLSUPPCOLS used in Extract param file affect what is written to the trail file.
What is Oracle GoldenGate Extract writing to the trail file (OGG 12.2 & 12.3) Read More »
This is a follow up of my previous article about an analysis of all Extract parameters for Oracle GoldenGate 11.2. How the parameters UPDATERECORDFORMAT COMPACT|FULL, (NO)COMPRESSUPDATES, (NO)COMPRESSDELETES, (IGNORE)GETUPDATEBEFORES affect what is written to the trail file.
What is Oracle GoldenGate Extract writing to the trail file (OGG 12.1) Read More »
This article presents the complete full list of cases that has been used in Extract analysis of Oracle GoldenGate 11.2
GoldenGate Extract 11.2 test cases Read More »
In one of my previous posts I have made a detailed analysis about supplemental logging in the database that is a result of ADD TRANDATA command from OGG. Apart of what is written to the redo log it is another subject of what is read from the redo log by OGG and written to the
What is Oracle GoldenGate Extract writing to the trail file (OGG 11.2) Read More »
Oracle licenses GoldenGate based on the CPU count of the source database that is replicated. Starting from version 12.3 of OGG the Extract process logs in the error log the information about cores on the sources.
Oracle GoldenGate 12.3 traces CPU count on source databases Read More »