Edit

Run Oracle databases on Azure

Azure Load Balancer
Azure Application Gateway

Solution ideas

This article is a solution idea. If you'd like us to expand the content with more information, such as potential use cases, alternative services, implementation considerations, or pricing guidance, let us know by providing GitHub feedback.

High availability for your front-end and 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 extra availability and/or Disaster Recovery, consider deploying another Database VM in a different Azure region and schedule frequent RMAN backups.

Potential use cases

This solution idea illustrates a canonical architecture to achieve high availability for your Oracle Database Enterprise Edition in Azure.

Architecture

Architecture diagram shows from client through load balancer and subnets to Azure V NET. Download an SVG of this architecture.

Dataflow

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

Components

Key technologies used to implement this architecture:

Next steps

Product documentation:

Microsoft Learn modules: