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