Re: question on data guard

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 4 Feb 2021 07:41:40 -0600
Message-ID: <CAJvnOJagckjO0nNY4YgZNELdywygA2mxv5Zo+mjy1zTZK+zM+A_at_mail.gmail.com>



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
Received on Thu Feb 04 2021 - 14:41:40 CET

Original text of this message