Oracle Cloud Infrastructure Documentation

Managing a Backup

Use the Console or the command-line interface to edit, delete, or move a backup.

Editing a Backup

Use the Console or the command-line interface to edit the display name, description, and retention period of a DB system backup.

Using the Console

Use the Console to edit the display name, description, and retention period of your backup.

Note

The Edit backup panel is different from the Edit backup plan panel. The Edit backup plan panel enables you to enable automatic backups, edit the retention period and window start time of an existing DB system. See Editing a Backup Plan.
  1. Open the navigation menu and select Databases. Under MySQL HeatWave, click Backups.
  2. Do one of the following:
    • Click Edit from the Actions menu on the same line as your DB system.
    • Click the name of the backup to open the Backup details page and click Edit.
  3. On the Edit backup panel, provide the following details:
    • Display name: Specify the new name of the backup. If you do not modify the name, the existing name is retained.
    • Description: Specify the new description of the backup. If you do not modify the description, the existing description is retained.
    • Retention period: Specify the new retention period of the backup. If you do not modify the retention period, the existing value is retained.
      Note

      You cannot change the retention period of automatic backups.
  4. Click Save changes.
The backup metadata is updated.

Using the CLI

Use the command-line interface to update the display name, description, and retention period of your backup.

This task requires the following:
  • A backup OCID.
  • A policy that permits you to update 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 update a backup:
  1. Open a command prompt, and run the following command:
    oci mysql backup update 
--backup-id <BackupOCID> 
--display-name <DisplayName>
--description <Description>
--retention-in-days <NumberOfDays>

    • --backup-id: Specify the OCID of the backup.

    • --display-name: (Optional) Specify the new display name of the backup. If you do not define a display name, the existing name is retained.

    • --description: (Optional) Specify the new description of the backup. If you do not define a description, the existing description is retained.

    • --retention-in-days: (Optional) Specify the new number of days to retain the backup. If you do not define a number, the existing retention period is retained.

MySQL HeatWave Service udpates the backup metadata.

Editing a Backup Plan

Edit the backup plan of an existing DB system to enable automatic backups and point in time recovery, and edit the retention period and window start time.

Using the Console

Use the Console to edit the backup plan of an existing DB system.

Note

The Edit backup plan panel is different from the Edit backup panel. The Edit backup panel enables you to edit the display name and description of the backup. See Editing a Backup.
  1. Navigate to the DB system details page of the DB system.
  2. From the More actions menu, select Edit backup plan.
  3. On the Edit backup plan panel, provide the following details:
    • Enable automatic backups: Select to enable automatic backups, and to configure the backup retention period, enable point-in-time recovery, and select the backup window. If you do not enable automatic backups, create a manual backup. It is recommended to enable automatic backups.
      • Backup retention period: (Optional) Specify how long to retain the backups, in days. The default retention period is seven days.
      • Enable point-in-time recovery: Select the option to enable you to restore a DB system at a point-in-time to a new DB system.
      • Select backup window: Select to enable you to define the starting time of backup of your DB system in the Window start time field. Your backup starts at some point in the 30 minutes following the Window start time. Click Show backup windows per region to view the default backup window specific to your region.
      Note

      There is no impact on the DB system or the database connections when the automatic backup is created.
  4. Click Save changes.
The backup plan is updated.

Moving a Backup

You can move an active backup to a different compartment. You can not move a backup that is in any other state.

Use the Console or the command-line interface to move a backup to a different compartment.

Using the Console

Use the Console to move your backup to a different compartment.

This task requires the following:
  • The access permission, MYSQL_BACKUP_MOVE, on the compartment to which you want to move your backup. See mysql-backups.
  • An active backup. You can not move a backup that is in any other state.
Do the following to move a backup to a different compartment:
  1. Open the navigation menu, and click Databases. Under MySQL HeatWave, click Backups.
  2. Choose your compartment from the List scope.
  3. Do one of the following:
    • Choose Move resource from the Actions menu on the same line as your backup.
    • Click the name of the backup to open the Backup details page. Click Move resource.
  4. In the Move resource dialog box, choose the new compartment. You cannot select the compartment the backup is currently in.
  5. Click Move backup.
The backup is moved to the selected compartment.

Using the CLI

Use the command-line interface to move a backup to a different compartment.

This task requires the following:
  • A backup OCID.
  • A policy that permits you to move 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 move a backup to a different compartment:
  1. Open a command prompt, and run the following command:
    oci mysql backup change-compartment 
--backup-id <BackupOCID> 
--compartment-id <TargetCompartmentOCID>

    • --backup-id: Specify the OCID of the backup.

    • --compartment-id: Specify the OCID of the target compartment to which the backup is moved.

MySQL HeatWave Service moves the backup to the target compartment.

Deleting a Backup

Use the Console or the command-line interface to delete a backup of the DB system.

Using the Console

Use the Console to delete a backup of your DB system.

  1. Open the navigation menu and select Databases. Under MySQL HeatWave, click Backups.
  2. Do one of the following:
    • Choose Delete from the Actions menu on the same line as your DB system.
    • Click the name of the DB system to open the Backup details page. Click the More actions button and select Delete.
  3. On the Delete backup dialog box, click Delete backup.
The backup is deleted.

Using the CLI

Use the command-line interface to delete a backup.

This task requires the following:
  • A backup OCID.
  • A policy that permits you to delete 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 delete a backup:
  1. Open a command prompt, and run the following command:
    oci mysql backup delete --backup-id <BackupOCID>

    • --backup-id: Specify the OCID of the backup.

MySQL HeatWave Service deletes the backup.