Oracle 架构汇总

来源：这里教程网时间：2026-03-03 17:29:26 作者：

一：Oracle数据库架构

1.1 Oracle 单实例

https://www.oracle.com/webfolder/technetwork/tutorials/architecture-diagrams/19/rac/main.html

1.2 Oracle DG

https://docs.oracle.com/en/database/oracle/oracle-database/21/sbydb/data-guard-concepts-and-administration.pdf https://www.oracle.com/a/tech/docs/maa-onpremises-overview.pdf

1.2.1 DG

1.2.2 ADG

12.23 Active Data Guard Far Sync

Oracle Active Data Guard Far Sync Solution https://docs.oracle.com/en/database/oracle/oracle-database/21/haovw/high-availability-overview-and-best-practices.pdf 切换 PDB Failover: Normal Runtime PDB Failover after PDB 2 Outage DML Physical Standby Databases Logical Standby Databases Snapshot Standby Databases

1.2.4 Oracle Data Guard Broker

https://docs.oracle.com/en/database/oracle/oracle-database/21/dgbkr/data-guard-broker.pdf

1.3 Oracle Sharding

https://docs.oracle.com/en/database/oracle/oracle-database/21/shard/using-oracle-sharding.pdf https://www.oracle.com/a/tech/docs/maa-onpremises-overview.pdf Oracle Database Sharding – Benefits

1.4 Oracle OGG

https://www.oracle.com/a/tech/docs/maa-onpremises-overview.pdf Oracle GoldenGate Architecture https://docs.oracle.com/en/middleware/goldengate/core/12.3.0.1/ggcon/introduction-oracle-goldengate.html#GUID-794696C5-9241-42A2-88C4-2EB54F237AF4 Components of Oracle GoldenGate Classic Architecture Components of Oracle GoldenGate Microservices Architecture Figure 2-1 Receiver Server Communication

1.5 Oracle Streams

https://docs.oracle.com/cd/E11882_01/server.112/e17069/strms_over.htm#STRMS180 Figure 1-2 Sample Hub-and-Spoke Replication Configuration Figure 1-3 Sample Replication Configuration with Downstream Captur e Sample Replication Configuration That Uses Synchronous Captures Figure 1-5 Sample N-Way Replication Configuration Figure 1-6 Sample Single Database Capture and Apply Configuration Figure 1-7 Sample Messaging Configuration

1.6 Oracle RAC

https://docs.oracle.com/en/database/oracle/oracle-database/21/racad/real-application-clusters-administration-and-deployment-guide.pdf https://docs.oracle.com/en/database/oracle/oracle-database/21/haovw/high-availability-overview-and-best-practices.pdf https://www.oracle.com/webfolder/technetwork/tutorials/architecture-diagrams/19/rac/main.html https://docs.oracle.com/en/database/oracle/oracle-database/21/gsmug/global-data-services-concepts-and-administration-guide.pdf

1.6.1 Oracle RAC one Node

https://www.oracle.com/technetwork/database/options/clustering/rac-one-node-wp-12c-1896130.pdf

1.6.2 Oracle Extended RAC

Oracle RAC and Oracle RAC One Node on Extended Distance (Stretched) Clusters Host Based Mirroring (Active / Active Storage) Array Based Mirroring (Active / Passive Storage)

1.6.3 Oracle Flex Cluster

https://docs.oracle.com/en/database/oracle/oracle-database/21/cwadd/oracle-flex-clusters.html#GUID-E1014B42-E671-4314-A2B0-D7B03EA4285F

1.7 Oracle 第三方主备

1.7.1 Rose HA

http://www.rosedata.com/index.php/Cloud/index/schid/5/pid/1

1.7.2 Oracle VCS

https://blog.csdn.net/ilovemilk/article/details/4735619

1.8 Oracle MAA

https://www.oracle.com/a/tech/docs/maa-onpremises-overview.pdf https://docs.oracle.com/en/database/oracle/oracle-database/21/haovw/high-availability-overview-and-best-practices.pdf Figure 11-1 Network Routes Before Site Failover Figure 11-2 Network Routes After Site Failover Oracle Maximum Availability Architecture Oracle Multitenant