Listing Backups

You can retrieve a list of backups.

Use the Console, a command-line interface, or the REST API to list backups.

Using the Console

Use the Console to list backups.

  1. Open the navigation menu and select Databases. Under HeatWave MySQL, select Backups.
    The Backups list page opens. All backups in the selected compartment are displayed in a table.
  2. To view the backups in a different compartment, use the Compartment filter to switch compartments.
    Note

    You must have permission to work in a compartment to see the resources in it. If you're not sure which compartment to use, contact an administrator. For more information, see Understanding Compartments.
  3. Filtering List Results: Use filters to limit the backups in the list. Perform one of the following actions depending on the options that you see:
    • From the Search and Filter box above the list table, select one or more filters and specify the values that you want to use to narrow the list. In general, the filters correspond to the columns shown in the list table, although some filters represent attributes that aren't shown in the table. The Compartment filter is always displayed next to Applied filters.
    • On the left side of the list page, select a value from one of the available filters, such as compartment, state, or tags.
    Change the order of the items in the list table by using the sort icons next to the column names.
  4. Actions: In the list table, select the name of a backup to open its details page, where you can view its status and perform other tasks. To perform an action on a backup directly from the list table, select any of the following options from the Actions menu in the row for that backup:
    • View details: Open the details page for the backup.
    • Restore to a new DB system: Restore the backup to a new DB system.
    • Copy OCID: Copy the OCID of the backup to the clipboard.
    • Delete: Delete the backup.
    • Cancel deletion: Cancel the backup scheduled deletion.
    To perform a bulk delete on one or more backups, select a list of backups and select Delete at the top of the table.

Using the CLI

Use the command-line interface to list backups.

This task requires the following:
  • The Oracle Cloud Identifier (OCID) of your compartment.
  • A policy that permits you to list backups in the compartment or tenancy.
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
List all backups in a compartment using the CLI:
  1. Open a command prompt and run the following command:
    oci mysql backup list 
         --compartment-id <CompartmentOCID>
    • compartment-id: Specify the OCID of the compartment.
If the command validates and runs successfully, you get a response which list all the backups found in the specified compartment.