ArcSDE and Oracle Physical Standby Database

EmadAl-Mousa · ‎07-31-2013

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,

WilliamCraft · ‎09-12-2013

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.

View solution in original post

WilliamCraft · ‎09-12-2013

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.