In a word - no. What you are describing is two way replication, not
standby database. There are many 2 way replication products on the
market, GoldenGate being the most popular. Select the product with an
adequate price/performance and configure replicas.
Regards
On 2/4/21 1:20 AM, Pap wrote:
We are using data guard configuration and it's a physical standby for disaster recovery. The version is 11.2.0.4 of Oracle. My questions, we do use DR for querying many times, but is there any way we can use/open physical standby for DML also and so that both primary and DR will be in sync bi-directionally and we can utilize the DR/Standby database resources for our application queries?
Thanks and Regards
Pap