Will updates statements applied to a Logical Standby DB update DBs accessed via DB Links
edited Jun 5, 2018 5:00AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Hi,
What I like to know is whether updates statements applied to a Logical Standby Database
will update other databases accessed via Database Links.
We have
Primary DB - PrimA
External DB - ExtDB
our applications run on "PrimA" and they may
Scenario 1. update data in "ExtDB" using a DB Link.
Scenario 2. Update data in PrimA based on data stored in ExtDB accessed via a DB Link
We have created a Logical Standby Database from "PrimA" for reporting purposes called "DestB".
My query is based on what happens when SQL-APPLY applies SQL from "PrimA" to "DestB"
Scenario 1. "ExtDB" has already been updated by "PrimA" - will "DestB" try and update also ?
0