Re: question on data guard

Thank you all. So it means it's atleast not possible in our current version i.e 11.2.0.4. And 19c has the option but that is too not for heavy dml.

On Thu, 4 Feb 2021, 7:28 pm Mikhail Velikikh, <mvelikikh_at_gmail.com> wrote:

> 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