Oracle Cloud Infrastructure Documentation

Autonomous Database

This topic explains how to modify resources for Oracle Autonomous Database Services.

  • Disaster Recovery

    Oracle Autonomous Database Service provides you with the capability to set up and modify disaster recovery configurations. It is crucial to establish your recovery time objective (RTO) and recovery point objective (RPO) for different levels of failures, including both planned and unplanned events.

    Follow these steps to set up the different types of disaster recovery.
    • Backup-based disaster recovery:

      Oracle Autonomous Database Service on Azure supports backup-based disaster recovery (DR).

    • Autonomous Data Guard:

      Autonomous Data Guard for Oracle Autonomous Database Service provides high availability and disaster recovery by maintaining a standby database in a separate availability zone (AZ) or region. When enabled, it ensures that the primary and standby databases remain synchronized with a RPO of 1 minute and it allows automatic failover in the event of an outage or disaster.

    Note

    If you have selected deployment mode as Secure access from everywhere or Secure access from allowed IPs, you may create up to 1 local peer. If you have selected deployment mode as Managed private virtual network IP only, you may create up to 1 local peer and one cross region peer for every remote paired region.
    These are the paired regions as of today.

    Table 1-1 Paired Regions

    Regional Pair A Regional Pair B
    East US West US
    East US Canada Central
    East US Brazil South
    East US Central US
    West US East US
    Canada Central East US
    Brazil South East US
    UK South UK West
    UK South Australia East
    UK West UK South
    Australia East UK South
    France Central (Paris) Germany West Central
    France Central (Paris) Italy North
    Germany West Central France Central
    Italy North France Central
    Central US East US
    US East 2 Central US
    US East 2 Canada Central
    US East 2 Brazil South
    US East 2 West US

    Add

    Complete the following steps to set up a disaster recovery.
    1. From the Azure portal, select Oracle Database@Azure.
    2. From the left navigation menu, select Oracle Autonomous Database Service.
    3. Select your Autonomous Database that you want to modify.
    4. Expand the Settings section, and then select the Disaster recovery link.This screenshot shows how to perform disaster recovery.
    5. Click the Add button, and then complete the following substeps.
      1. From the dropdown list, select your Region.
      2. From the dropdown list, select your Resource group.
      3. Enter an unique Name. The value must contain only letters and numbers, starting with a letter. 30 characters max. Spaces are not allowed.
      4. Select your Disaster recovery type from the dropdown list. Choose either the Backup-based disaster recovery or Autonomous Data Guard option.
      5. From the Networking section, select your Virtual network and Subnet.
      6. To Enable cross-region backup replication to disaster recovery peer, select the checkbox.
      7. Select the Next button to proceed.
      8. From Review + create tab, select the Create button. Go to the previous page to correct any validation errors.
      then . This screenshot shows how to perform disaster recovery.
    6. Once you complete, select the Review + create button.

    For more information, see Service Level Objectives (SLOs).

    Edit

    Complete the following steps to edit a disaster recovery.
    1. From the Azure portal, select Oracle Database@Azure.
    2. From the left navigation menu, select Oracle Autonomous Database Service.
    3. Select your Autonomous Database that you want to modify.
    4. Expand the Settings section, and then select the Disaster recovery link.
    5. Click the Edit button, and then complete the following substeps.
      1. From the dropdown list, select Peer autonomous database.
      2. The Disaster recovery type field has two options. Choose either Autonomous Data Guard or Backup-based disaster recovery.
      3. Enable the Automatic Failover with data loss limit in seconds option if it is required.
      4. Select the Edit button.

    Switchover

    Switchover is a planned transition from the primary database to its standby. This operation is typically used for maintenance, testing, or proactively shifting the workloads. When using Oracle Autonomous Data Guard, switchover ensures minimal downtime and zero data loss by promoting the standby database to primary status while demoting the original primary to standby. To perform a switchover, your Autonomous Database must be part of a configured Disaster Recovery Protection Group.

    Complete the following steps to perform a switchover.
    1. From the Azure portal, select Oracle Database@Azure.
    2. From the left navigation menu, select Oracle Autonomous Database Service.
    3. Select your Autonomous Database that you are using.
    4. Expand the Settings section, and then select the Disaster recovery link.
    5. Select the Switchover button and from the Swithover database state page, complete the following substeps:
      1. From the dropdown list, select your Peer autonomous database.
      2. Enter switchover into the field to confirm your action.
      3. Select the Submit button to apply the changes.This screenshot shows how to perform a switchover.

    Backup

    Follow the steps in the Restore and Backup documentation for more information.

    Tags

    These are steps to modify tags of Autonomous Database Services.
    1. From the Azure portal, select Oracle Database@Azure.
    2. From the left navigation menu, select Oracle Autonomous Database Service.
    3. Select your Autonomous Database that you are using.
    4. From the left navigation menu , select the Tags link.
    5. You can add, remove or modify Tags based on the requirements.This screenshot shows how to modify tags.

    Auto Start and Stop Schedule

    These are the steps to schedule automatic start and stop your Autonomous Database from the Azure portal.
    1. From the Azure portal, select Oracle Database@Azure.
    2. From the left menu, select Oracle Autonomous Database Service.
    3. From the Name column, select your database that you are using.
    4. Select the Auto start/stop schedule button from the top menu, and then complete the following substeps:
      1. From the Auto start/stop schedule page, you can configure the auto start/stop schedule by selecting the days and the times from the dropdown lists. For each day of the week:
        1. Start (UTC): Select the start time for the schedule on this day.
        2. Stop (UTC): Select the stop time for the schedule on this day.
      2. Select the Yes button to save your changes.
      This screenshot shows how to auto start and stop schedule.

  • There is currently no content for this page. Oracle Database@Azure team intends to add content here, and this placeholder text is provided until that text is added. The Oracle Database@Azure team is excited about future new features, enhancements, and fixes to this product and this accompanying documentation. We strongly recommend you watch this page for those updates.

  • There is currently no content for this page. Oracle Database@Azure team intends to add content here, and this placeholder text is provided until that text is added. The Oracle Database@Azure team is excited about future new features, enhancements, and fixes to this product and this accompanying documentation. We strongly recommend you watch this page for those updates.

  • There is currently no content for this page. Oracle Database@Azure team intends to add content here, and this placeholder text is provided until that text is added. The Oracle Database@Azure team is excited about future new features, enhancements, and fixes to this product and this accompanying documentation. We strongly recommend you watch this page for those updates.

  • There is currently no content for this page. Oracle Database@Azure team intends to add content here, and this placeholder text is provided until that text is added. The Oracle Database@Azure team is excited about future new features, enhancements, and fixes to this product and this accompanying documentation. We strongly recommend you watch this page for those updates.