In a scenario where Oracle Golden Gate is used to replicate a primary site with an Oracle RAC database to a secondary site (and active/active back) we suspect unexpected changes from the unused secondary site.
The issue is a bit hard to debug as we do not have direct DBA access. I wonder is there an easy way with unprivileged SQL access on the primary side to see if any changes are received from the other database?
Can I see counters or timestamps of OGG activity which helps me to track down DML made?
As I understand it I could see changes from the OGG user when setting up triggers or auditing - however both is not available in this situation.
Asked by eckes
(1456 rep)
Oct 26, 2017, 08:28 AM
Last activity: Aug 1, 2018, 02:22 PM
Last activity: Aug 1, 2018, 02:22 PM