Backup Base Database

Learn how to backup an Base Database using the Automatic Backup and Manual Backup options

Automatic Backup

Oracle recommends to use Oracle-managed automatic backup for your databases.

Oracle Database@Azure provides the following two (2) choices as the Backup destination for Oracle Base Database in the OCI console.
  1. Autonomous Recovery Service (Recommended)
  2. Object Storage

After creating the Base Database, you need to select one of the choices described above from the OCI console.

Note

Your Base Database Backup retention period and Backup schedule will vary based on the selected Backup destination.

Autonomous Recovery Service

  1. Select Autonomous Recovery Service from the Backup destination list.
  2. Select your Compartment and Protection policy. The Protection policy list provides different protection policies with Backup retention period ranging from 14 to 95 days.
  3. You can modify the retention period after the database has been created.
  4. From the Scheduled time for daily backup (UTC) dropdown list, select the time window when the daily backup starts.
  5. From the Scheduled time for incremental backup (UTC) dropdown list, select the time window when the incremental backups start.
  6. If you want to take your first backup immediately after your Exascale Database is created, select the Take the first backup immediately button.

Object Storage

  1. Select Object Storage from the Backup destination list.
  2. Enter your Backup retention period between 7 and 60 days. You can modify the retention period after the database has been provisioned.
  3. From the Scheduled time for daily backup (UTC) dropdown list, select the time window when the daily backup starts.
  4. From the Scheduled time for incremental backup (UTC) dropdown list, select the time window when the incremental backups start.
  5. If you want to take your first backup immediately after your Exascale Database is created, select the Take the first backup immediately button.

Automatic Backup from the OCI Console

  1. From the OCI console, select Oracle Base Database Service, and then select the DB Systems.
  2. From the DB Systems list, select the DB system that you are using, and then select the Databases tab. Optionally, you can select the compartment from the Applied filters.This screenshot shows automatic backup of Base Database.
  3. From the Databases tab, select the database that you are using.
  4. From the Database information tab, navigate to the Backup section to view the details of your Automatic backup settings such as Incremental backup schedule, Backup destination and Backup retention period.
  5. From the More actions dropdown on Database information tab, you can select the Configure automatic backups option.
    1. From the Configure automatic backups page, turn on the toggle for Enable automatic backups. This screenshot shows automatic backup of Base Database.
    2. Adjust the configuration of automatic backups, and then select the Save button to confirm.This screenshot shows automatic backup of Base Database.
  6. Select the Backups tab to view details of your backup including State, Type, Backup destination, Encryption Key, Database version, Started and Ended.This screenshot shows automatic backup of Base Database.
  7. You can modify the automatic backups configuration by selecting the More actions button, then select the Configure automatic backups option. Once it is complete, select the Save button to confirm.

Manual Backup

Manual backups are Oracle Database backups stored in the same backup destination as the automatic backup destination selected during the configure automatic backups step. Manual backups are not subject to automatic backup retention policies if the backup destination is object storage. They are kept in the selected backup destination until you decide to delete them. Manual backups are subject to automatic retention policies if backup destination is Autonomous Recovery Service.

Complete the following steps to create a manual backup.
  1. From the OCI console, select Oracle Base Database Service, and then select the DB Systems.
  2. From the DB Systems list, select the DB system that you are using, and then select the Databases tab. Optionally, you can select the compartment from the Applied filters.This screenshot shows how to back up Base Database.
  3. From the Databases tab, select the database that you are using.
  4. Select the Backups tab, and then select the Create Backup button.
  5. From the Create Backup page, complete the following substeps:
    1. Enter a Name for your backup.
    2. For the Backup retention period, you can select either Retain backup per backup retention policy and Specify long-term backup retention period options.
    3. Select the Create button to confirm.This screenshot shows how to back up Base Database.
    4. Return to the Backups tab to view the State of your backup. Once your backup is created, the state will change from Backup In Progress to Active.This screenshot shows how to back up Base Database.