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
Using the CLI
Using the REST API, run the GetBackup operation.

Using the Console

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

Open the navigation menu and select Databases. Under HeatWave MySQL, click Backups.
Choose your compartment from the List scope.
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 HeatWave 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 HeatWave 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. 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.
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.

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.

Oracle Cloud Infrastructure Documentation Try Free Tier