Oracle GoldenGate – Event (Error) Log, DiscardFile and System Log

  • Use GGSCI commands to view: Processing Status, Events, Errors and Checkpoints
  • View Oracle GoldenGate reports and logs: Process Reports, Error Log, Discard File and System Logs

Event (Error) Log

Oracle GoldenGate Event Log lists show:
– A history of GGSCI commands
– Processes that started and stopped
– Errors that occurred
– Informational messages

The Event Log also shows events leading to an error.
For Example, you might discover one of the following:
– Someone stopped a process.
– A process failed to make a TCP/IP or database connection.
– A process could not open a file.

Use one of the following to view the Event Log:
– A standard text editor or a shell command
– The GGSCI command View GGSEVT (GoldenGate Software Event)
– Oracle GoldenGate Monitor or Director

Note: Error messages can have different numbers and layouts for different platforms and versions.

Discard File (Created for each Group)

A discard file:
– Is created if the DiscardFile <filename> parameter is used in the Extract or Replicat parameter file
– Is created when Extract or Replicat has a problem with the record that it is processing
– Contains column-level details for operations that the process cannot handle
– Is usually used for Replicat to log operations that cannot be reconstructed or applied
– Can help you resolve data-mapping issues

System Logs

  • Oracle GoldenGate writes operating system level errors to the Event Viewer (in Windows) or to the syslog (in Unix).
  • Windows: Use the ADDEVENTS option of the INSTALL program to add generic GoldenGate events to the Event Manager. – Shell> install addevents.
  • UNIX: System log is enabled by default. For more specific messages, copy category.dll and ggsmsg.dll from the Oracle GoldenGate directory to the SYSTEM32 directory

These errors also appear in the Event Log.

 

Share This

Muhammad Rawish Siddiqui

Master in Computer Science (Database Engineering) and PGD in Management Information System.
45+ Online Certifications, which includes EDRP (EC-Council Disaster Recovery Professional), Data Management, Security+, DBaaS - Cloud Certified Expert, Oracle Cloud Autonomous Database Specialist, Oracle Database Cloud Certified Professional, Oracle Cloud Infrastructure, OCP 7.3, 10g, 11g, 11i, R12, OCE/OCS 11i System Administration, Solaris, Linux and Real Application Cluster 10g, 11g, Oracle Autonomous Database, Real Application Cluster, Oracle Data Guard and Performance Tuning etc. .

Foremost interested areas include, Data Management, Oracle Databases and EBS Health Checks, Real Application Cluster, Disaster Recovery, GoldenGate and Oracle Cloud.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments