#automation

When automating your GoldenGate deployments, or tearing down a test environment, handling trail files is important.

In a previous post, I shared the OGGRestAPI Python client I built for the GoldenGate REST API. Since then, I kept using it on production deployments, fixing it and adding new features along the way.

In a previous blog, I presented how to set up a distribution path between two GoldenGate deployments both secured with NGINX. The method I used there was purely through the Web UI.

I already covered out-of-place patching from the web UI, but patching tasks should be automated, and clicking through the same screens for every deployment can get repetitive.

*Updated in June 2026, based on the latest version of the client.

In this blog post, I will guide you on how to query the restapi.log file of your GoldenGate deployments more efficiently.

Oracle GoldenGate REST API has been around for quite some time now, but I've yet to see it used in practice at customers. Every time I tried to introduce it, it was some sort of novelty.

If you start using the GoldenGate web UI after installing it, you might end up thinking that extending the session timeout would be nice.

*26ai update: This article was originally written for 23ai. But not much changes when setting up GoldenGate 26ai.

Contrary to other DBMS, MongoDB self-managed deployments generate logs in a JSON format, which can be quite intimidating at first.