ArcSDE ESRI ( )
High availability Backup & recovery Clustering Replication Mirroring Standby servers
ArcSDE
% 95% 99.9% 99.99% 99.999% 99.9999% 18.25 / 8.7 / 52.5 / 5.25 / 31.8 /
Spatial Geodatabase Connection Types 2 Tier Connection 3 Tier Connection 3 Tier Connection ArcGIS DBMS Network Client ArcGIS ArcGIS Client ArcSDE DBMS Network Client ArcSD E Server ArcSDE DBMS DBMS Network Client Backup/Recovery, Clustering, Failover, Replication, Mirroring, Standby Servers DBMS DBMS DBMS Server Direct Connect ArcSDE Local ArcSDE Remote
(Backup / Recovery)
/
Clustering
(Clustering) cluster?
ArcSDE 8.1.2 SDE LICENSE Oracle - Oracle10g Oracle 9i
Microsoft Cluster Services (MSCS) MSCS Windows 2000,, Windows Server 2003. MSCS IBM DB2, IBM Informix, Microsoft SQL Server and Oracle (with Oracle fail safe)
MSCS Cluster
MSCS SQL Server SQL Server ( ) cluster
MSCS Oracle Fail Safe Oracle10g license Microsoft Windows NT, Windows 2000, and Windows 2003 Microsoft Cluster Server Oracle
MSCS ArcSDE 1 DBMS 2 ArcSDE, 3 4 ArcSDE ArcSDE
GIS Client License Server TCP/IP Network \\VirtualServer ArcSDE ( Server Node 1 - Active Primary DBMS Server ArcSDE Server Node 2 - Passive Secondary DBMS Server ArcSDE Shared Storage MSCS Active/Passive Cluster
Oracle Real Application Cluster (RAC) 1 2 3 - ArcSDE
RAC 1 (CPUs RAM) 2 (CPUs RAM) ( )
RAC 1 2 3 4 Oracle 5
RAC ArcSDE 1 RAC Listener down down 2 3 RAC RAC SDE
RAC TEST = (DESCRIPTION = (load_balance=on) (failover=on) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.172)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.174)(PORT = 1521)) ) (SOURCE_ROUTE = yes) (CONNECT_DATA = (SERVICE_NAME = rac0) (failover_mode = (type = session) (method = basic) ) ) )
Oracle Transparent Application Failover (TAF) HA failover HA Oracle9i(10G) Real Application Clusters Oracle Fail Safe, failover failover Select Oracle Call Interface (OCI), OCI TAF
Oracle Transparent Application Failover (TAF) TAF TAF : Oracle9i Real Application Clusters, replicated systems, standby databases
TAF TAF Oracle Net Services Oracle 9i 10g TAF Oracle TAF
TAF sales.us.acme.com= (DESCRIPTION= (LOAD_BALANCE=on) (FAILOVER=on) (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-server)(PORT=1521)) server)(port=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-server)(PORT=1521)) server)(port=1521)) (CONNECT_DATA= (SERVICE_NAME=sales.us.acme.com) (FAILOVER_MODE= (TYPE=select) (METHOD=basic))))
Replication
(SQL) 1 2 ( ) 3 4 Using Microsoft SQL Server Snapshot Replication with ArcSDE
(SQL Server) 1 master replica. 2 Replicate 3 ArcSDE Configuration and Tuning Guide for Microsoft SQL Server Master Database Replica Database
Production - Editors Transport SDE SQL Water SDE SQL Building SDE SQL DoT SDE SQL Environmental Services SDE SQL T ransactional Replication Production - Viewers Desktop SDE SQL Internet SDE SQL IMS TCP/IP Editors ArcInfo ` ` Viewers Web Browser ArcInfo ` `
ESRI ArcCatalog copy/paste ArcGIS XML Export/Import ArcSDE export/import HP,EMC
Mirroring
( ) Oracle databases Standby : Oracle Standby database
vs.
vs. IO
Standby Databases
Oracle10g Data Guard standby Standby managed recovery standby ArcSDE
Oracle10g Data Guard Log data flow
High availability Backup & recovery Clustering Replication Mirroring Standby servers
ArcSDE HA
Thank you!
Materialized View (Oracle),,
Materialized View (Oracle) 9 rossetup.sql SDEHOME\tools\oracle\replication\snapshot KB #24742 rossetup.sql SDE schema ArcSDE metadata SDE.TABLE_REGISTRY SDE.LAYERS ArcSDE logfile
GIS Client License Server TCP/IP Network \\VirtualServer 1 \\VirtualServer2 ArcSDE Server Node 1 - Failover for Node 2 Primary DBMS Server 1 ArcSDE 1 Secondary DBMS Server 2 ArcSDE 2 Server Node 2 - Failov er for Node 1 Primary DBMS Server 2 ArcSDE 2 Secondary DBMS Server 1 ArcSDE 1 Shared Storage Shared Storage MSCS Active/Active Cluster
ArcMap,