Oracle Cloud Infrastructure Documentation

Viewing Backup Details

Use the Console or the command-line interface to view all backups present in the compartment and its details.

Using the Console

Use the Console to view all backups present in the compartment and its details.

  1. Open the navigation menu and select Databases. Under HeatWave MySQL, select Backups.
  2. Choose your compartment from the List scope.
  3. In the list of backups, selet the name of the backup to open the Backup details page. Under DB system you can find the details of the associated DB system.

Backup Details

The Backup details page shows details of the backup and the resources associated with it.

Backup Information

The following information is displayed on the Backup information tab in the Backup details page:

Table 9-3 Backup Information

Field Description
General information
  • OCID: The unique identifier of the backup.
  • Description: A user-defined description of the backup.
  • Compartment: The name of the compartment in which the backup is created. To see the OCID of the compartment, click the compartment name.
  • Created: The date and time the backup was created.
  • Last updated: The date and time the backup was last updated.
Backup configuration
  • Shape: The DB system shape of the backup.
  • Database version: The MySQL version of the backup. See MySQL Server Versions.
  • Retention days: The number of days the backup is retained.
  • Backup type: The type of backup, Full or Incremental. See Overview of Backups.
  • Creation type: How the backup was created, Manual, Automatic, Final, or Operator. See Overview of Backups.
  • Backup size: The size of the backup, in GB. In some cases the backup size may be larger than the volume usage. See Volume Backup Size.
  • Storage size: The storage size of the DB system at the time the backup was created.
Encrypt
  • Encryption key: Displays the type of encryption key used by the backup.

DB System State During Backup

The following information is displayed on the DB system state during backup tab in the Backup details page:

Table 9-4 DB system state during backup

Field Description
General information
  • Name: The name of the DB system with a link to the DB system details page.
  • OCID: The unique identifier of the DB system.
  • Description: A user-defined description of the DB system.
  • Compartment: The name of the compartment in which the DB system is created. To see the OCID of the compartment, click the compartment name.
DB system configuration
  • Shape: The resource template applied to the DB system. See Supported Shapes.
  • Automatic storage expansion: Displays automatic storage expansion status. Enabled or Disabled. Click Edit to open the Update storage size dialog box. See Enabling or Disabling Automatic Storage Expansion.
  • Allocated storage size: (Is shown when automatic storage expansion is enabled) The amount of storage currently allocated to the DB system. For Highly Available systems, this also provides a breakdown of storage size allocated to each instance.
  • Maximum storage size: (Is shown when automatic storage expansion is enabled) The maximum amount of storage that can be allocated to the DB system . For Highly Available systems, this also provides a breakdown of the maximum storage size that can be allocated to each instance.
  • Storage size: (Is shown when automatic storage expansion is disabled) The amount of storage available to the DB system. For Highly Available systems, this also provides a breakdown of storage allocated per instance. Click Edit to open the Update storage size dialog box. See Increasing the Storage of a DB System.
  • Database version: The version of MySQL contained by the DB system. Click Edit to change the MySQL version. See MySQL Server Versions.
  • Configuration: The name of the HeatWaave configuration used in the DB system and a link to that configuration's details page.
  • Crash recovery: Displays whether crash recovery is enabled or disabled. See Crash Recovery.
Encrypt
  • Encryption key: Displays the type of encryption key used by the DB system.
Networking
  • Virtual cloud network: The network on which the DB system was created.
  • Subnet: The subnet to which the DB system is attached.
  • Subnet type: The type of subnet. Regional or AD-specific.
  • Network security groups: The list of network security groups which the DB system belongs to.
Backup plan
Deletion plan
  • Delete protected: Displays whether delete protection is enabled or disabled on your DB system. See Deleting a DB System.
  • Automatic backup retention: Displays whether the automatic backups are retained or deleted after you delete your DB system.
  • Final backup: Displays whether a final backup is created or skipped before deleting the DB system.
High availability
  • High availability: Displays the high availability status of the DB system. Enabled or Disabled. See High Availability.

Copy Information

If the backup is copied from another region, the following information is displayed on the Copy information tab in the Backup details page:

Table 9-5 Copy Information

Field Description
Immediate source backup OCID The unique identifier of the MySQL backup from which this backup was copied.
Original source backup OCID The unique identifier of the original MySQL backup of the DB system.
Time copy created The date and time the backup was copied.

DB System

The following information is displayed on the DB system tab in the Backup details page:

Table 9-6 DB System

Section Field and Description
General information
  • Name: The name of the DB system with a link to the DB system details page.
  • OCID: The unique identifier of the DB system.
  • Description: A user-defined description of the DB system.
  • State: The current lifecycle state of the DB system.
  • Compartment: The name of the compartment in which the DB system is created. To see the OCID of the compartment, click the compartment name.
  • Created: The date and time the DB system was created.
  • Last updated: The date and time the DB system was last updated.
DB system configuration
  • Shape: The resource template applied to the DB system. See Supported Shapes.
  • Automatic storage expansion: Displays automatic storage expansion status. Enabled or Disabled. Click Edit to open the Update storage size dialog box. See Enabling or Disabling Automatic Storage Expansion.
  • Allocated storage size: (Is shown when automatic storage expansion is enabled) The amount of storage currently allocated to the DB system. For Highly Available systems, this also provides a breakdown of storage size allocated to each instance.
  • Maximum storage size: (Is shown when automatic storage expansion is enabled) The maximum amount of storage that can be allocated to the DB system . For Highly Available systems, this also provides a breakdown of the maximum storage size that can be allocated to each instance.
  • Storage size: (Is shown when automatic storage expansion is disabled) The amount of storage available to the DB system. For Highly Available systems, this also provides a breakdown of storage allocated per instance. Click Edit to open the Update storage size dialog box. See Increasing the Storage of a DB System.
  • Database version: The version of MySQL contained by the DB system. Click Edit to change the MySQL version. See MySQL Server Versions.
  • Configuration: The name of the HeatWaave configuration used in the DB system and a link to that configuration's details page.
  • Crash recovery: Displays whether crash recovery is enabled or disabled. See Crash Recovery.
Encrypt
  • Encryption key: Displays the type of encryption key used by the DB system.
Networking
  • Virtual cloud network: The network on which the DB system was created.
  • Subnet: The subnet to which the DB system is attached.
  • Subnet type: The type of subnet. Regional or AD-specific.
  • Network security groups: The list of network security groups which the DB system belongs to.
Backup plan
  • Automatic backups: Displays automatic backup status. Enabled or Disabled. See Backing Up a DB System.Automatic backup retention: Displays whether the automatic backups are retained or deleted after you delete your DB system.
Deletion plan
  • Delete protected: Displays whether delete protection is enabled or disabled on your DB system. See Deleting a DB System.
  • Automatic backup retention: Displays whether the automatic backups are retained or deleted after you delete your DB system.
  • Final backup: Displays whether a final backup is created or skipped before deleting the DB system.
High availability
  • High availability: Displays the high availability status for this DB system. Enabled or Disabled. See High Availability.
HeatWave cluster
  • HeatWave cluster: Displays HeatWave cluster status for this DB system. Enabled or Disabled. If the DB system is using the correct shape, an active link to Enable HeatWave Cluster is also displayed. This opens the Add HeatWave cluster dialog. See Adding a HeatWave Cluster.

Resources: Work Requests

The Work requests resource on the Backup details page lists the activity logs for ongoing and recent operations on the backup. Work requests are retained for 12 hours.

Table 9-7 Work Requests

Field Description
Operation One of the following operation names:
  • CREATE_BACKUP
  • DELETE_BACKUP
  • COPY_BACKUP

For more information on Work Requests, see Work Request Overview.

State Current state:
  • ACCEPTED: The request is in the work request queue to be processed.
  • IN_PROGRESS: A work request record exists for the specified request, but there is no associated WORK_COMPLETED record.
  • SUCCEEDED: A work request record exists for this request and an associated WORK_COMPLETED record has the state SUCCEEDED.
  • FAILED: A work request record exists for this request and an associated WORK_COMPLETED record has the state FAILED.
  • CANCELING: The work request is in the process of canceling.
  • CANCELED: The work request has been canceled.
% Complete The percentage completion.
Accepted Date and time the operation was accepted.
Started Date and time the operation started.
Finished Date and time the operation finished.
Action menu (3 dots) Opens the Action menu. The following actions are possible:
  • View details: opens the Work request details page.
  • Copy OCID: Copy the OCID of the work request to the clipboard.

Using the CLI

Use the command-line interface to view the details of a backup.

This task requires the following:
  • A backup OCID.
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
  1. Open a command prompt and run the following command:
    oci mysql backup get --backup-id <BackupOCID>
HeatWave Service retrieves the backup details and displays the result in JSON format.