Oracle Cloud Infrastructure Documentation

Deleting a DB System

You can delete a DB system permanently.

All manual backups of the DB system are retained for the defined retention period.

If Automatic backup retention is set to Retain, all automatic backups of the DB system are retained for the defined retention period. If Automatic backup retention is set to Delete, automatic backups in the ACTIVE state are permanently deleted immediately, even if soft delete is enabled. Backups that are already in the DELETE_SCHEDULED state are not deleted immediately and remain available for the soft-delete retention period.

If you have selected Require final backup in the Deletion plan, a final backup is created before deleting the DB system.

Using the Console

Use the Console to delete a DB system permanently.

  1. On the DB systems list page, find the DB system that you want to work with. If you need help finding the list page or the DB system, see Listing DB Systems - Using the Console.
  2. From the Actions menu for the DB system, select Delete.
  3. In the Delete DB systems dialog box:
    1. Check the DB system deletion plan. If you want to change the deletion plan, select Edit
      • Choose whether to Delete or Retain automatic backups.
        Note

        If you choose to delete automatic backups, automatic backups in the ACTIVE state are permanently deleted immediately, even if soft delete is enabled. Backups that are already in the DELETE_SCHEDULED state are not deleted immediately and remain available for the soft-delete retention period.
      • Choose whether to Skip or Require a final backup before deleting the DB system.
    2. Select the Delete DB systems permanently check box.
    3. Select Delete DB systems.
When you delete a DB system, you can see the deleted DB system in the list of DB systems for 90 days. However, you cannot start the deleted DB system again.

Using the CLI

Use the command-line interface to delete a DB system.

This task requires the following:
  • A DB system Oracle Cloud Identifier (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 db-system delete --db-system-id <DBSystemOCID>
    • db-system-id: Specify the OCID of the DB system that you want to delete.
The command deletes the DB system.