Reference architecture for Oracle Database on Azure

This solution architecture illustrates a canonical architecture to achieve high availability for your Oracle Database Enterprise Edition in Azure. High availability for your front-end as well as the middle tier can be obtained by using Azure Load Balancers or Application Gateways. An uptime availability of 99.99% for your database tier can be achieved using a combination of Azure Availability Zones and Oracle Active DataGuard with FSFO. For additional availability and/or Disaster Recovery, consider deploying another Database VM in a different Azure region and schedule frequent RMAN backups.

Reference architecture for Oracle Database on AzureThis solution architecture illustrates a canonical architecture to achieve high availability for your Oracle Database Enterprise Edition in Azure. High availability for your front-end as well as the middle tier can be obtained by using Azure Load Balancers or Application Gateways. An uptime availability of 99.99% for your database tier can be achieved using a combination of Azure Availability Zones and Oracle Active DataGuard with FSFO. For additional availability and/or Disaster Recovery, consider deploying another Database VM in a different Azure region and schedule frequent RMAN backups.App Server1FrontEnd 1FrontEnd 2Client SystemFrontEnd 3App Server2Oracle SB1(primary)Premium Storageusing Oracle ASMRedo StreamActiveDataguardFSFQ ObserverOracle DB2(standby)Oracle EnterpriseManagerPremium Storageusing Oracle ASM(sync)Availability ZoneSubnetLoadbalancer0Availability Zone0Availability ZoneSubnetAzure VNET1Availability Zone21234567

The client system accesses a custom application with Oracle DB back-end via the web.

Web front-end is configured in a load balancer.

Web front-end makes a call to the appropriate Application Server to handle the work.

Application server queries primary Oracle Database.

Oracle Database has been configured using a HyperThreaded Virtual Machine with multiple Premium storage-based Managed Disks for performance and availability.

Oracle databases are replicated with Oracle DataGuard (or Active DataGuard) or Oracle GoldenGate for HA and DR purposes.

Oracle databases are monitored for uptime and performance by Oracle Enterprise Manager. OEM also allows you to generate various performance and usage reports.

  1. 1 The client system accesses a custom application with Oracle DB back-end via the web.
  2. 2 Web front-end is configured in a load balancer.
  3. 3 Web front-end makes a call to the appropriate Application Server to handle the work.
  4. 4 Application server queries primary Oracle Database.
  1. 5 Oracle Database has been configured using a HyperThreaded Virtual Machine with multiple Premium storage-based Managed Disks for performance and availability.
  2. 6 Oracle databases are replicated with Oracle DataGuard (or Active DataGuard) or Oracle GoldenGate for HA and DR purposes.
  3. 7 Oracle databases are monitored for uptime and performance by Oracle Enterprise Manager. OEM also allows you to generate various performance and usage reports.