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. On the Backups list page, select the backup that you want to work with. If you need help finding the list page or the backup, see Listing Backups - Using the Console.

    The details page opens and displays information about the backup. 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.

Details

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

Table 9-3 Details

Field Description
Backup information
  • Name: The display name of the backup. Select Edit to edit the backup. See Editing a Backup - Using the Console.
  • OCID: The unique identifier of the backup.
  • Description: A user-defined description of the backup. Select Edit to edit the backup. See Editing a Backup - Using the Console.
  • Compartment: The name of the compartment in which the backup is created.
  • Created: The date and time the backup was created.
  • Last updated: The date and time the backup was last updated.
Encrypt
  • Encryption key: Displays the type of encryption key used by the backup.
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. Select Edit to edit the backup. See Editing a Backup - Using the Console.
  • Soft delete: Displays whether soft delete is enabled or disabled. Select Edit to edit the backup. See Editing a Backup - Using the Console.
  • 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.

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
DB system 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.
  • Database version: The version of the database contained by the DB system.
  • Crash recovery: Displays whether crash recovery is enabled or disabled. See Crash Recovery.
Resource allocation
  • Shape: The resource template applied to the DB system. See Supported Shapes.
  • Configuration: The name of the HeatWave configuration used in the DB system and a link to that configuration's details page.
  • 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.
  • 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.
  • Automatic storage expansion: Displays automatic storage expansion status. Enabled or Disabled. Select Edit to open the Update storage size dialog box. See Enabling or Disabling Automatic Storage Expansion.
  • 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.
Encrypt
  • Encryption key: Displays the type of encryption key used by the DB system.
High availability
  • High availability: Displays the high availability status of the DB system. Enabled or Disabled. See High Availability.
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.
  • Availability domain: The availability domain the DB system is in. See Regions and Availability Domains.
  • Fault domain: The fault domain within the availability domain. See Fault Domains.
  • 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.
  • If automatic backups is enabled:
    • Backup window: The time at which the automatic backup window starts.
    • Retention days: The number of days the automatic backups are retained.
    • Point-in-time recovery: The setting of point-in-time recovery (enabled or disabled).
    • Soft delete: The setting of soft delete (enabled or disabled).
    • Cross region copy: The setting of cross region copy (enabled or disabled).
    • Destination region: (Is shown when cross region copy is enabled) The destination region of cross region copy.
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.

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
DB system 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, select 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.
  • Database version: The version of MySQL contained by the DB system.
  • Access mode: Displays the access mode, whether it is all users or administrators only.
  • Database mode: Displays the database mode whether it is read-write or read-only.
  • Crash recovery: Displays whether crash recovery is enabled or disabled. See Crash Recovery.
Resource allocation
  • Shape: The resource template applied to the DB system. See Supported Shapes.
  • Configuration: The name of the HeatWaave configuration used in the DB system and a link to that configuration's details page.
  • 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.
  • 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.
  • Automatic storage expansion: Displays automatic storage expansion status. Enabled or Disabled.
  • 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.
Encrypt
  • Encryption key: Displays the type of encryption key used by the DB system.
HeatWave cluster
  • HeatWave cluster: Displays HeatWave cluster status for this DB system. Enabled or Disabled.
High availability
  • High availability: Displays the high availability status for this DB system. Enabled or Disabled. See High Availability.
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.
  • Availability domain: The availability domain the DB system is in. See Regions and Availability Domains.
  • Fault domain: The fault domain within the availability domain. See Fault Domains.
  • 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.
  • If automatic backups is enabled:
    • Backup window: The time at which the automatic backup window starts.
    • Retention days: The number of days the automatic backups are retained.
    • Point-in-time recovery: The setting of point-in-time recovery (enabled or disabled).
    • Soft delete: The setting of soft delete (enabled or disabled).
    • Cross region copy: The setting of cross region copy (enabled or disabled).
    • Destination region: (Is shown when cross region copy is enabled) The destination region of cross region copy.
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.

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.