-
Book Overview & Buying
-
Table Of Contents
Oracle GoldenGate 11g Implementer's guide
By :
So you have configured your GoldenGate environment, maybe in its simplest form, having one source and one target database. But despite starting the Manager, Extract, and Replicat processes, data is not being replicated.
The easiest way to determine that data replication is not working is to execute row counts against a given source and its target table. Then drill into the GoldenGate processes to obtain their status and statistics.
The following paragraphs provide the necessary troubleshooting tips to enable a quick resolution to the most common issues.
Start your troubleshooting at the source. We need to determine that the Extracts are processing data before looking at the other components in the data stream. Two methods exist to confirm throughput, which we have already discussed in Chapter 8, Managing Oracle GoldenGate and Chapter 9, Performance Tuning. These are the GGSCI SEND and STATS commands, demonstrated in the following examples:
GGSCI...
Change the font size
Change margin width
Change background colour