Oracle Cloud Infrastructure Documentation

Backing Up an Autonomous Data Warehouse Database Manually

This topic describes how to create manual backups of Autonomous Data Warehouse databases. You can use the Oracle Cloud Infrastructure console or the API to perform these tasks.

Autonomous Data Warehouse automatically backs up your database and retains these backups for 60 days. Autonomous Data Warehouse provides weekly full backups and daily incremental backups. You can also create manual backups to supplement your automatic backups. Manual backups are stored in an Object Storage bucket that you create, and are not deleted automatically by Autonomous Data Warehouse.

Your database remains available during a backup. However, management operations performed using the Oracle Cloud Infrastructure Console are not available during a restore. These operations include the following:

  • Scaling the CPU core count
  • Scaling the database storage
  • Managing tags
  • Starting, stopping, or terminating the database

Prerequisites

  • To create or manage Autonomous Data Warehouse backups, you must be given the required type of access in a An IAM document that specifies who has what type of access to your resources. It is used in different ways: to mean an individual statement written in the policy language; to mean a collection of statements in a single, named "policy" document (which has an Oracle Cloud ID (OCID) assigned to it); and to mean the overall body of policies your organization uses to control access to resources. written by an administrator, whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you try to perform an action and get a message that you don’t have permission or are unauthorized, confirm with your administrator the type of access you've been granted and which A collection of related resources that can be accessed only by certain groups that have been given permission by an administrator in your organization. you should work in. See Authentication and Authorization for more information on user authorizations for the Oracle Cloud Infrastructure Database service.
  • To create a manual backup for Autonomous Data Warehouse, you must first configure an Object Storage bucket to serve as a destination for your manual backups. See Setting up a Bucket to Store Manual Backups for instructions.

Using the Oracle Cloud Infrastructure Console

To Create a Manual Backup of an Autonomous Data Warehouse Database

  1. Open the navigation menu. Under Database, click Autonomous Data Warehouse.

  2. Choose your Compartment.
  3. In the list of Autonomous Data Warehouse databases, find the database that you want to back up.
  4. Click the name to display the Autonomous Data Warehouse database details.
  5. Click Create Manual Backup.

    Tip

    If this step does not successfully complete, confirm that you have an Object Storage bucket set up and configured to store manual backups. See Setting Up a Bucket to Store Manual Backups for instructions.

  6. In the Create Manual Backup dialog, enter a name for your backup. Avoid entering confidential information.
  7. Click Create. Your backup may take several hours to complete, depending on the size of your database.
  8. Optionally, you can check the state of your backup in the list of backups on the database details page. For some states, an information icon (encircled i) is displayed to provide additional details regarding the state or ongoing operations like deletions. The backup has one of the following states:

    • Creating
    • Active
    • Deleting
    • Deleted
    • Failed

Using the API

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

Use these API operations to manage Autonomous Data Warehouse backups:

Setting Up a Bucket to Store Manual Backups

You must create an Oracle Cloud Infrastructure Object Storage bucket to hold your Autonomous Data Warehouse manual backups and configure your database to connect to it. This is a one-time operation.

To set up an object store and user credentials for your manual backups