Re: question on data guard

I saw a few blogs stating the DML on standby possible on the global temporary table on a physical standby if temp_undo_enabled set to TRUE and it's on 12.1. Not seeing any such in doc though for 11.2., but is it also possible on 11.2.0.4 to perform DML/INSERT into a global temporary table on DR or its strictly in 12.1+ versions?

On Thu, Feb 4, 2021 at 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