Re: question on data guard

Oracle introduced Active Data Guard DML Redirection in 19c: https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-E2F2E0EE-D58B-4F9C-A7F8-301D9AEA34D8 Take a look if it fits the bill.
I could even work in 18c per *Active Data Guard DML Redirection 19c (Doc ID 2465016.1)*

On Thu, 4 Feb 2021 at 13:41, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> If you want to run updates on the standby, it is not longer a standby. The
> only way to do this is with Golden Gate or similar technology (shareplex).
>
> On Thu, Feb 4, 2021 at 12:20 AM Pap <oracle.developer35_at_gmail.com> 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
>>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

--
http://www.freelists.org/webpage/oracle-l