Azure HA/DR

Sanjay Kumar Pandey 20 Reputation points
2023-10-30T12:25:09.0166667+00:00

Hi Team,

What are the pros and cons of going with the single region (UK south) for HA and DR setup for Oracle DB in azure

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,407 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Michael Durkan 12,176 Reputation points MVP
    2023-10-30T14:10:56.6766667+00:00

    Hi

    your choice here is based on how critical your application is, if you are limited by costs etc.

    UK South has Availability Zones, unique physical locations within an Azure region with independent power, cooling, and networking. This offers high-availability that protects your applications and data from datacenter failures.

    The other option here would be to build your app using Region Pairs, however its important to note that although UK South and UK West are Region Pairs, UK West does not have availability zones and is a single datacenter.

    Hope this helps,

    Thanks

    Michael Durkan

    • If the reply was helpful please upvote and/or accept as answer as this helps others in the community with similar questions. Thanks!
    0 comments No comments

  2. vipullag-MSFT 25,446 Reputation points
    2023-11-02T04:11:01.7366667+00:00

    Hello Sanjay Kumar Pandey

    Welcome to Microsoft Q&A Platform, thanks for posting your query here.

    Using Oracle Data Guard with Fast-Start Failover (FSFO) as a disaster recovery option in the same region has its benefits and challenges.

    Benefits:

    • It provides a high level of availability and resiliency for your Oracle database.
    • It can be a cost-effective solution as it does not require replicating data across regions.
    • It can provide a low RTO (Recovery Time Objective) as the failover process can be automated and completed quickly.
    • It can provide a low RPO (Recovery Point Objective) as the secondary database is kept in sync with the primary database.

    Challenges:

    • It may not provide sufficient protection against regional disasters or large-scale phenomena that could affect the entire region.
    • It may not meet compliance or data residency requirements if those requirements mandate data to be stored in multiple regions.
    • It may require additional licensing costs for Active Data Guard and FSFO.

    The RTO/RPO for Oracle Data Guard with FSFO can vary depending on the specific requirements of your organization. However, with the failover process being automated and completed quickly, it is possible to achieve a low RTO. Similarly, with the secondary database being kept in sync with the primary database, it is possible to achieve a low RPO. It is important to determine the specific RTO/RPO requirements for your organization and configure the Oracle Data Guard with FSFO accordingly.

    Hope that helps.

    0 comments No comments