ArcSDE and Oracle Physical Standby Database

EmadAl-Mousa — Wed, 31 Jul 2013 19:23:05 GMT

Greetings,

i would like to ask if ArcSDE would work with Physical Standby Oracle database in (read-only mode) ?

should the connection be Direct Connection ?

I checked this presentation slide that says "yes" but with no further details: http://proceedings.esri.com/library/userconf/proc11/tech-workshops/tw_1149.pdf

Thanks,

Re: ArcSDE and Oracle Physical Standby Database

WilliamCraft — Fri, 13 Sep 2013 01:45:21 GMT

It depends, in my opinion. For your Oracle read-only database, is this physical standby being managed by Oracle Active Dataguard? Those are, by definition, read-only as you mention. From your primary database, you'd be able to replicate the SDE user schema (and other schemas) to the secondary / read-only standby... thus allow you to make an ArcSDE connection. But, you wouldn't be able to perform inserts/updates/deletes by way of adding feature classes, re-calculating spatial indexes, or deleting relationship classes. These types of operations issue SQL to modify objects just like any other SQL command you might issue on another schema's set of objects. In summary, I think SDE would "work" as far as being able to connect but that's it.

topic ArcSDE and Oracle Physical Standby Database in Data Management Questions

ArcSDE and Oracle Physical Standby Database

Re: ArcSDE and Oracle Physical Standby Database