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.

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.

  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.
  10. If you are enabling automatic backups, you can choose to configure the following:
    • Backup scheduling (UTC): If you enable automatic backups to Recovery Service then the automatic backup process could start at any time or within the assigned window. If you enable automatic backups to Object Storage then you can choose a two-hour scheduling window to control when backup operations begin. If you do not specify a window, the six-hour default window of 00:00 to 06:00 (in the time zone of the DB system's region) is used for your database.
    • Backup destination: Your choices are Recovery Service or Object Storage.
    • Backup retention period: If you choose to enable automatic backups, you can choose a policy with one of the preset retention periods, or a custom policy. The system automatically deletes your incremental backups at the end of your chosen retention period.
      • The following retention periods are available for Recovery Service.
        • Bronze (14 days)
        • Silver (35 days) (default)
        • Gold (65 days)
        • Platinum (95 days)
        • Custom: User defined protection policy
      • The following retention periods are available for Object Storage.
        • 7 days
        • 15 days
        • 30 days (default)
        • 45 days
        • 60 days.
    • Real-time data protection: (Available only if Recovery Service is selected.) This is an extra cost option.
    • Deletion options after database termination: (Available only if Recovery Service is selected.) Choose either Retain backups according to the protection policy retention period or Retain backups for 72 hours, then delete.
  11. Click Save changes.
  12. 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.

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.