Oracle Cloud Infrastructure Documentation

Backing Up an Exadata Database

You can back up databases on an Exadata DB system to an existing bucket in the Oracle Cloud Infrastructure Object Storage service and to the local disk Fast Recovery Area.

This topic explains how to:

  • Create a backup configuration file that indicates the backup destination, when the backup should run, and how long backups are retained. If the backup destination is Object Storage, the file also contains the credentials to access the service.
  • Associate the backup configuration file with a database. The database will be backed up as scheduled, or you can create an on-demand backup.
Note

You must update the cloud-specific tooling on all the compute nodes in your Exadata DB system before performing the following procedures. For more information, see Updating an Exadata DB System.

Prerequisites

  • The Exadata DB system requires access to the Oracle Cloud Infrastructure Object Storage service. For more information, see Configuring a Static Route for Accessing the Object Store.

  • The DB system's cloud network (VCN) must be configured with either a service gateway or an internet gateway. For information about service gateways, see Access to Object Storage: Service Gateway.

    Note

    • With an internet gateway, network traffic between the system and Object Storage does not leave the cloud and never reaches the public internet. For more information, see Internet Gateway.
    • See Known Issues for information about OS updates when using a service gateway.

    If you use an internet gateway instead of a service gateway, add a route rule with the internet gateway as the target and the destination CIDR block as the IP range listed under Object Storage IP Allocations. For more information, see Route Tables.

    Oracle recommends that you update the backup subnet's security list to disallow any access from outside the subnet and allow egress traffic for TCP port 443 (https) on the IP ranges listed under Object Storage IP Allocations. For more information, see Security Lists.

    Object Storage IP Allocations
  • An existing Object Storage bucket to use as the backup destination. You can use the Console or the Object Storage API to create the bucket. For more information, see Managing Buckets.
  • An auth token generated by Oracle Cloud Infrastructure. You can use the Console or the IAM API to generate the password. For more information, see Working with Auth Tokens.
  • The user name specified in the backup configuration file must have tenancy-level access to Object Storage. An easy way to do this is to add the user name to the Administrators group. However, that allows access to all of the cloud services. Instead, an administrator can create a policy that allows tenancy-level access to just Object Storage. The following is an example of such a policy.

    Allow group DBAdmins to manage buckets in tenancy

    Allow group DBAdmins to manage objects in tenancy

    For more information about adding a user to a group, see Managing Groups. For more information about policies, see Getting Started with Policies.

Default Backup Configuration

The backup configuration follows a set of Oracle best-practice guidelines:

  • Full (level 0) backup of the database followed by rolling incremental (level 1) backups on a seven-day cycle (a 30-day cycle for the Object Storage destination).
  • Full backup of selected system files.
  • Automatic backups daily at a specific time set during the database deployment creation process.

Retention period:

  • Both Object Storage and local storage: 30 days, with the 7 most recent days' backups available on local storage.
  • Object Storage only: 30 days.
  • Local storage only: Seven days.

Encryption:

  • Both Object Storage and local storage: All backups to cloud storage are encrypted.
  • Object Storage only: All backups to cloud storage are encrypted.

Managing Backups

To create a backup configuration file
To create an on-demand backup
To remove the backup configuration
To delete a local backup
To delete a backup in Object Storage

What Next?

If you used Object Storage as a backup destination, you can display the backup files in your bucket in the Console on the Storage page, by selecting Object Storage.

You can manually restore a database backup by using the RMAN utility. For information about using RMAN, see the Oracle Database Backup and Recovery User's Guide for Release 18.1, 12.2, 12.1, or 11.2.