Re: question on data guard

Wouldn't a logical standby allow for separate objects that exist outside the primary database? Been doing that for many years. Logical standby is kludgy but it still works.

This depends on the parameter

alter database guard all;
vs.
alter database guard standby; -- this setting allows for separate tablespace to be created and separate objects outside the primary.

*alter **database **guard **all*|standby|none;

On Thu, Feb 4, 2021 at 8:12 AM Pap <oracle.developer35_at_gmail.com> wrote:

> 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.'
>>>
>>

-- 
April C. Sims
IOUG SELECT Journal Editor
http://aprilcsims.wordpress.com
Twitter, LinkedIn
Oracle Database 11g – Underground Advice for Database Administrators
<http://www.amazon.com/Oracle-Database-Underground-Advice-Administrators/dp/1849680000/ref=sr_1_1?ie=UTF8&s=books&qid=1272289339&sr=8-1#noop>
https://www.packtpub.com/oracle-11g-database-implementations-guide/book
OCP 8i, 9i, 10g, 11g DBA
Southern Utah University
aprilcsims_at_gmail.com

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