Sample Header Ad - 728x90

Golden Gate activity auditing with SQL?

0 votes
1 answer
386 views
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