Back Up a Database Using the Console

This article explains how to work with backups managed by the Recovery Service and the Object Storage using the Console.

For more information on backups, see Back Up and Recovery in Base Database Service.

Required IAM Policy

To use Oracle Cloud Infrastructure, you must be granted security access in a policy by an administrator. This access is required whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you get a message that you don’t have permission or are unauthorized, verify with your administrator what type of access you have and which compartment to work in.

If you're new to policies, see Getting Started with Policies and Common Policies.

Related Topics

Navigate to the List of Standalone Backups for Your Current Compartment

Perform the following steps to navigate to the list of standalone backups in your compartment.

  1. Open the navigation menu. Select Oracle Database, then click Oracle Base Database.
  2. Under Resources, click Standalone Backups. A list of standalone backups is displayed.

Configure Automatic Backups for a Database

When you launch a DB system, you can optionally enable automatic backups for the initial database. Use this procedure to configure or disable automatic backups after the database is created.

Note:

Switching the backup destination will trigger an immediate full backup by default. This full backup cannot be rescheduled.
  1. Open the navigation menu. Select Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the name of the DB system that contains the database for which you want to configure automatic backups.
  4. The details of the DB system followed by a list of databases are displayed.
  5. In the list of databases, click the name of the database for which you want to configure automatic backups.
  6. The details of the database are displayed.
  7. On the Database Details page, in the Database information tab, the Backup details indicate whether automatic backups are enabled. When backups are enabled, the details also indicate the chosen backup retention period.
  8. To configure automatic backups, on the Database Details page, click Configure automatic backups.
  9. In the Configure database backups dialog, check or uncheck Enable automatic backups, as applicable. If you are enabling automatic backups, you can choose to configure Recovery Service or Object Storage as the Backup destination.
  10. If Recovery Service is selected as the Backup destination, you can configure the following options:

    • Protection policy: You can choose from one of the preset protection policies or a custom policy. The system automatically deletes your backups at the end of your chosen protection policy recovery window.

      The following retention periods are available for Recovery Service. The retention periods (in days) are defined in the Recovery Service protection policy.
      • Bronze (14 days)
      • Silver (35 days) (default)
      • Gold (65 days)
      • Platinum (95 days)
      • Custom (User defined protection policy)

    • Real-time data protection: Real-time protection is the continuous transfer of redo changes from a protected database to Recovery Service. This reduces data loss and provides a recovery point objective (RPO) near 0. This is an extra cost option.

    • Deletion options after database termination: You can use the following options to retain managed database backups after the database is terminated. These options can also help restore the database from backups in case of accidental or malicious damage to the database.

      • Retain backups according to the retention period: When a database is terminated, the automatic database backups associated with the terminated database will be removed at the end of the specified retention period.
      • Retain backups for 72 hours, then delete: When a database is terminated, the automatic database backups associated with the terminated database will be retained for 72 hours and then deleted. The backups are retained for 72 hours to safeguard against accidental deletion by the user.
    • Scheduled day for initial backup: Choose a day of the week for the initial backup to begin.
    • Scheduled time for initial backup (UTC): Choose a time for the initial backup to begin. The initial backup could start at any time or within the chosen two-hour scheduling window.
    • Scheduled time for daily backup (UTC): Choose a time for the daily backup to begin. The daily backup could start at any time or within the chosen two-hour scheduling window.
    • Take the first backup immediately: A full backup is an operating system backup of all datafiles and the control file that constitute an Oracle Database. A full backup should also include the parameter files associated with the database. You can take a database backup when the database is shut down or while the database is open. You should not normally take a backup after an instance failure or other unusual circumstances. If you choose to defer the initial backup, your database may not be recoverable in the event of a database failure.
  11. If Object Storage is selected as the Backup destination, you can configure the following options:

    • Backup retention period: If you choose to enable automatic backups, you can choose a policy with one of the preset retention periods. The system automatically deletes your incremental backups at the end of your chosen retention period. You can change the backup retention period after provisioning.

      The following retention periods are available for Object Storage.
      • 7 days
      • 15 days
      • 30 days (default)
      • 45 days
      • 60 days
    • Scheduled day for full backup: Choose a day of the week for the initial and future full backups to begin.
    • Scheduled time for full backup (UTC): Choose a time for the full backup to begin. The full backup could start at any time or within the chosen two-hour scheduling window.
    • Scheduled time for incremental backup (UTC): Choose a time for the incremental backup to begin. The incremental backup could start at any time or within the chosen two-hour scheduling window.
    • Take the first backup immediately: A full backup is an operating system backup of all datafiles and the control file that constitute an Oracle Database. A full backup should also include the parameter files associated with the database. You can take a database backup when the database is shut down or while the database is open. You should not normally take a backup after an instance failure or other unusual circumstances. If you choose to defer the initial backup, your database may not be recoverable in the event of a database failure.
  12. Click Save changes.
  13. The Database Details page displays the automatic backup status and details in the Backup section.

Create an On-Demand Full Backup of a Database

Perform the following steps to create an on-demand full backup of a database.

  1. Open the navigation menu. Select Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the name of the DB system that contains the database for which you want to create an on-demand full backup.
  4. The details of the DB system followed by a list of databases are displayed.
  5. In the list of databases, click the name of the database for which you want to create an on-demand full backup.
  6. The details of the database are displayed.
  7. Under Resources, click Backups. A list of backups is displayed.
  8. Click Create backup.
  9. Provide a name for the backup database.
  10. Click Create backup.

View Details of a Protected Database

Perform the following steps to view the details of the protected database using the Console.

  1. Open the navigation menu. Select Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the name of the DB system that contains the database for which you want to configure automatic backups.
  4. The details of the DB system followed by a list of databases are displayed.
  5. In the list of databases, click the name of the database for which you want to configure automatic backups.
  6. The details of the database are displayed.
  7. On the Database Details page, in the Database information tab, the Backup details indicate whether automatic backups are enabled. When backups are enabled, the details also indicate the chosen backup details.
  8. Click the Recovery Service link in the Backup destination to view the details of the protected database.

For more information on protected databases, see Managing Protected Databases.

View Status of a Backup

Perform the following steps to view the backup status of a database.

  1. Open the navigation menu. Select Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the name of the DB system that contains the database for which you want to view the backup status.
  4. The details of the DB system followed by a list of databases are displayed.
  5. In the list of databases, click the name of the database for which you want to view the backup status.
  6. The details of the database are displayed.
  7. Under Resources, click Backups. A list of backups is displayed.
  8. The State column displays the status of the backup.
  9. The following are the various states of the backup: Active, Creating, Canceled, Canceling, or Failed.

Cancel a Backup

Perform the following steps to cancel a backup of a database.

Note:

Only backups in the Creating state can be canceled.
  1. Open the navigation menu. Select Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the name of the DB system that contains the database for which you want to cancel the backup.
  4. The details of the DB system followed by a list of databases are displayed.
  5. In the list of databases, click the name of the database for which you want to cancel the backup.
  6. The details of the database are displayed.
  7. Under Resources, click Backups. A list of backups is displayed.
  8. The State column displays the status of the backup. The following are the various states of the backup: Active, Creating, Canceled, Canceling, or Failed.
  9. In the list of backups, click the Actions menu for the backup you want to cancel.
  10. Click Cancel backup and confirm when prompted.
  11. The status of the backup changes to Canceling.

If the cancel backup fails, in the Work requests pane under Resources, you will see a line item called Cancel database backup in Failed state. There will also be a work request for the backup Create database backup that will reflect the state of the backup operation.

Delete Full Backups of a Database

Perform the following steps to delete the full backup of a database.

Note:

You cannot explicitly delete automatic backups. Unless you terminate the database, automatic backups remain in Recovery Service for 35 days and Object Storage for 30 days, after which time they are automatically deleted.
  1. Open the navigation menu. Select Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the name of the DB system that contains the database for which you want to delete the backup.
  4. The details of the DB system followed by a list of databases are displayed.
  5. In the list of databases, click the name of the database for which you want to delete the backup.
  6. The details of the database are displayed.
  7. Under Resources, click Backups. A list of backups is displayed.
  8. In the list of backups, click the Actions menu for the backup you want to delete.
  9. Click Delete and confirm when prompted.

Delete Standalone Backups of a Database

Perform the following steps to delete a standalone backup of a database.

  1. Open the navigation menu. Select Oracle Database, then click Oracle Base Database.
  2. Under Resources, click Standalone Backups. A list of standalone backups is displayed.
  3. In the list of standalone backups, click the Actions menu for the backup you want to delete.
  4. Click Delete and confirm when prompted.