Re: question on data guard
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 4 Feb 2021 09:38:56 -0500
Message-ID: <c0f36845-2dff-c35a-9724-a471982124a6_at_gmail.com>
Date: Thu, 4 Feb 2021 09:38:56 -0500
Message-ID: <c0f36845-2dff-c35a-9724-a471982124a6_at_gmail.com>
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
-- Mladen Gogala Database Consultant https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 04 2021 - 15:38:56 CET