Oracle Cloud Infrastructure Documentation

Creating a Manual Backup

Use the Console or the command-line interface to create a manual backup of an active or inactive DB system.

Note

You cannot create a manual backup on an Always Free DB system.

Using the Console

Use the Console to create a manual backup of your DB system.

This task requires the following:
  • The DB system state is ACTIVE or INACTIVE.
  • A policy that permits you to create backups in the compartment or tenancy.

Do the following to create a manual backup of a DB system:

  1. On the DB systems list page, select the DB system that you want to work with. If you need help finding the list page or the DB system, see Listing DB Systems - Using the Console.

    The details page opens and displays information about the DB system.

  2. From the menu at the top of the page, select Create manual backup.
  3. In the Create manual backup panel, provide the following information:
    • Display name: Specify the name of the backup. If you do not define a name, HeatWave Service generates one for you in the format, NameOfDBSystem-Backup-Date, Time.
    • Description: Specify a description of the backup. If you do not define a description,HeatWave Service generates one for you in the format, NameOfDBSystem-Backup-Date, Time.
    • Backup type: Specify the backup type, full or incremental.
    • Retention period: Specify the number of days the backup is retained. You can either select the number of days of retention or the end date of the retention.
    • Soft delete: Select this option to retain the backup to be deleted due to the retention policy in DELETE_SCHEDULED state for 7 additional days before permanently deleting it. This is enabled by default. See Soft Delete.
  4. Select Create manual backup to create the backup.
HeatWave Service immediately starts to create the manual backup. The DB system state changes to Updating while creating the manual backup, and returns to the original state once the backup is created. There is no other impact on the DB system.

Using the CLI

Use the command-line interface to create a manual backup.

This task requires the following:
  • The OCID of a DB system in ACTIVE or INACTIVE state.
  • A policy that permits you to create backups in the compartment or tenancy.
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
Do the following on the CLI to create a backup:
  1. Open a command prompt, and run the following command:
    oci mysql backup create 
--db-system-id <DBSystemOCID> 
--backup-type FULL 
--display-name <BackUpName>
--retention-in-days <NumberOfDays>
--soft-delete ENABLED

    • db-system-id: Specify the OCID of the DB system.

    • backup-type: (Optional) Specify the type of backup, FULL or INCREMENTAL. The default value is INCREMENTAL.

    • display-name: (Optional) Specify the display name of the DB system. If you do not define a display name, one is generated for you in the mysqlbackupYYYYMMDDHHMMSS format.

    • retention-in-days: (Optional) Specify the number of days the backup is retained. The default retention period is 365 days.

    • soft-delete: (Optional) Specify the soft delete setting of the backup, ENABLED or DISABLED. The default is ENABLED.

HeatWave Service immediately starts to create the manual backup. There is no other impact on the DB system.