Oracle GoldenGate (OGG) on OCI is a fully managed, cloud-native solution for real-time replication between Oracle and non-Oracle databases. But to maintain low-lag, data consistency, and high availability, monitoring performance is critical.
This post lays out a practical, hands-on guide to monitoring GoldenGate performance in OCI and outlines key metrics, tools, and proactive alerting practices.
Leave a CommentIn one of our database where GoldenGate setup is done, RMAN process was not able to delete the archive logs. The error message that coming…
Leave a CommentGoldenGate 12c version has many great features as compared to older versions. Below are some of the key new features of Oracle GoldenGate 12c that are worth mentioning
1 CommentWhen we face issues in GoldenGate extract or replicat setup, we follow some of the tried and tested initial troubleshooting steps mentioned below that helps us in pointing out the exact case of the issue.
To start with, GGSCI commands which are useful for Gathering evidences of issue:
Leave a CommentGoldenGate Downstream deployment allows you to offload the source database extract load to intermediate or target server. The source database ships its redo logs to a downstream database, and Extract uses the logmining server at the downstream database to mine the redo logs. A downstream mining database can accept both archived logs and online redo logs from a source database
1 CommentBelow are some of the GoldenGate commands that we use frequently. We work on GoldenGate 12c version but almost all commands work in same manner…
2 CommentsThere are a number of factors that we need to keep in mind to be able to successfully tune a GoldenGate Setup. If you carefully design your system keeping in mind the end goal and apply some proven performance tuning measures you should be able to get real time replication from your GoldenGate setup.
3 CommentsAfter successfully installing Oracle GoldenGate 12c, it will create a lot of sub-directories structure which will be used by the different components of Oracle GoldenGate. There are so many directories that new user will get confused what to look where.The directories are the default locations for GoldenGate when creating objects and parameter files.
Leave a CommentQ 1: What is Oracle GoldenGate? A 1: Oracle GoldenGate 12c is a fancy name for a piece of software which enables the continuous, real-time…
2 Comments