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.