About Backing Up and Restoring Databases

By backing up your Oracle Data Hub Cloud Service databases, you can protect the clusters and databases against loss if a failure occurs. By restoring from a backup, you can restore the cluster configuration and database to its state at the time of the backup.

Oracle Data Hub Cloud Service provides a backup feature that backs up:

  • The database

  • Cluster configuration files

Default Backup Configuration

When you create a cluster, you choose one of the following backup destinations:

  • Both Cloud Storage and Local Storage — backups are configured to be created automatically and stored both on local and cloud storage.

  • Cloud Storage Only — backups are configured to be created automatically and stored on cloud storage.

  • None — no automatic backups are configured.

The backup configuration created when you choose a destination other than None follows a set of Oracle best-practice guidelines:

  • Full backup of the database followed by rolling incremental backups on a seven-day cycle (a 30-day cycle for the Cloud Storage Only destination)

  • Full backup of the cluster configuration files

  • Automatic backups daily at a time between 11 PM (23:00) and 3 AM (03:00)

  • Retention period:

    • Both Cloud Storage and Local Storage: 30 days, with the most recent 1 day backup available on local storage

    • Cloud Storage Only: 30 days

If the defaults do not suit your needs, you can customize the backup configuration for your deployment. For information, see Customizing the Current Backup Configuration.

About Local Storage for Backups

When a cluster is created on Oracle Data Hub Cloud Service, Oracle Cloud Infrastructure Compute Classic or Oracle Cloud Infrastructure Compute storage volumes are created and associated with the compute nodes.

The space allocated for the local storage used for backups is twice the space allocated for data storage. For example, if you chose 100 GB for Usable Database Storage when creating the cluster, 200 GB are allocated for backups.