After replication is configured, it is critical that replication run without issues so that all data is replicated between all locations. Because replication is accomplished using the GoldenGate software, the database administrator is responsible for monitoring and maintaining replication using the tools available in the GoldenGate installation. There are several methods that can be used to monitor replication from simple SQL scripts through reports to sophisticated utilities.
Issues with replication must be resolved promptly because they might impact modeling.
Verify GoldenGate Manager Windows Service is running
The manager is the control process of GoldenGate. It serves as the parent process for all processes extracting and replicating data from the databases.
Open the Windows Services console, and verify that the GoldenGate manager service is running. Manually start the service if it is not running. The service has the following name format:
Verify that the GoldenGate manager service has been set to Automatic (Delayed Start).
If you want to use a graphical tool to monitor the GoldenGate installation, refer the Oracle GoldenGate Monitor Installation Guide.
Verify GoldenGate processes are running
There are three types of GoldenGate processes:
Connects to the source database to capture changes and writes them to a local file called the trail file.
Reads information from the trail file and sends it across the network to the corresponding trail file on the target server. This is a secondary process to the Extract process.
Reads the information from the trail file on the system on which it resides and applies it to the corresponding target database.
At the Host server, the number of Extract processes corresponds to the number of databases being replicated. For a one Model workshare, there is a total of 5 Extract processes, 5 Data Pumps, and 1 Replicat.
The GoldenGate command interface can be used to retrieve status information from each one of these processes.
Click Start > All Programs > Accessories > Command Prompt, and then navigate to the GoldenGate home folder.
Type the following command to open the GoldenGate command interface:
Type the following command:
A list of the GoldenGate processes displays.
Verify that the status of each Extract, Data Pump, and Replicat process is set to RUNNING. If a process is not running, start the process by typing the command "start" followed by the process name on the command line and then pressing ENTER. You can start all processes simultaneously by Typing start * on the command line.
The last letter of the process identifies the process type. Extract, Data Pump, and Replicat are represented by E, P, and R, respectively. For example, a process with the name "07601SSE" is an Extract process.
The status of the GoldenGate manager service can be obtained by typing INFO MGR in the GoldenGate command line interpreter.
The GoldenGate Data Pump is not related to the database engine Data Pump.