Oracle GoldenGate Integrated Replicat and NOSCHEDULINGCOLS

According to the documentation it is not allowed to use NOSCHEDULINGCOLS with ADD TRANDATA when you would use Integrated Replicat. Why would Oracle care for that? Let’s find out what can happen if you don’t apply the rules.

(more…)

Oracle GoldenGate Classic Replicat checkpointing

One of the key aspects for replication is checkpointing. A target database checkpoint tells which transactions are actually committed and which not yet. This is a key aspect of transactional replication. Let’s look how that works for the Oracle GoldenGate Classic Replicat.

(more…)

Oracle GoldenGate remote Classic Extract

Most people I have spoken to are are absolutely convinced that the Extract process has to be running on the source database host. This thinking comes from all Oracle diagrams where the Extract process is located on the source database host. Till OGG version 11.1.1 this was indeed true. Some have heard that the Extract process can be removed from the source host but it can only done with the Integrated Extract process.

There is however the TRANLOGOPTIONS DBLOGREADER parameter which allows the Classic Extract can be run remotely without any need of accessing the redo/archive logs file system (or ASM).

(more…)

How Oracle GoldenGate Replicat handles Foreign Key Constraints

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 this works. (more…)

Oracle GoldenGate Classic Extract together with RMAN recovery catalog

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. (more…)

UKSUG 2017 videos availabe on Vimeo (SAP/Sybase ASE)

Not many people are aware that recently UKSUG (aka UK Sybase User Group) has published on Vimeo their videos from TechSelect 2017.

(more…)

Nagios script for checking SAP Replication Server (Sybase RS)

A script to check the health of SAP Replication Server (Sybase RS) server for Nagios.

(more…)

Nagios script for checking SAP Adaptive Server Enterprise (Sybase ASE)

A script to check the health of SAP Adaptive Server Enterprise (Sybase ASE) server for Nagios.

(more…)

What is Oracle GoldenGate Extract writing to the trail file (OGG 12.2 & 12.3)

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.

(more…)

What is Oracle GoldenGate Extract writing to the trail file (OGG 12.1)

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.

(more…)


  Previous Page

- PAGE 2 OF 4 -

Next Page  

loading
×