Trigger on Logical Standby not capturing DML
edited May 5, 2020 5:06PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered ✓
Hello Team -
We have a Production database with a Logical Standby for reporting - 12c
The Reporting Team wants have reports fired when certain thresholds are hit - and part of that process is to create a trigger on one of the replicated tables (on the Logical Standby) to monitor inserts/deletes/updates
Trigger compiles without issue - after INSERT or DELETE or UPDATE
Insert on Primary occurs, data is replicated to the Logical - however the trigger on the Logical Standby is not capturing the event
My understanding of Log Apply is that the SQL statements are recreated and executed - should not the trigger capture those DML actions ?
Tagged:
0