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, click Backups.
  2. Choose your compartment from the List scope.
  3. In the list of backups, click 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
OCID The unique identifier of the MySQL backup.
Description User-defined description of the MySQL backup.
Compartment The name of the compartment in which the backup is stored. To see the OCID of the compartment, click the compartment name.
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.
Created The date and time the backup was created.
Last updated The date and time the backup was last updated.

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
  • Configuration: The name of the MySQL 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.
  • Storage size: The size of the DB system, in GB.
Backup
  • Automatic backups: Displays automatic backup status. Enabled or Disabled. See Backing Up a DB System.
  • 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.

Resources: DB System

The DB system resource on the Backup details page shows information of the DB system in the backup.

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
  • Configuration: The name of the MySQL 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.
Backup
  • Automatic backups: Displays automatic backup status. Enabled or Disabled. See Backing Up a DB System.
  • 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. By default, automatic backups are deleted when you delete the DB system.
  • Final backup: Displays whether a final backup is created or skipped before deleting the DB system. By default, the final backup is skipped, that is, not created.
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.

Status 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.
Progress A progress bar for the work request.
% 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.

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.