Terminate an Autonomous Database Instance

Describes the steps to terminate an Autonomous Database instance.

Note

Terminating an Autonomous Database deletes the instance and it will no longer be available to use. You may undelete a terminated database instance and its retained backups using the Undelete database option. See Undelete a Terminated Autonomous Database Instance for more information.

Perform the following prerequisite steps as necessary:

  • Open the Oracle Cloud Infrastructure Console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation menu click Oracle Database and then, depending on your workload click one of: Autonomous Data Warehouse, Autonomous JSON Database, or Autonomous Transaction Processing.
  • On the Autonomous Databases page select an Autonomous Database from the links under the Display name column.

  1. On the Details page, from the More actions drop-down list, select Terminate.
  2. On the Terminate Autonomous Database page enter the database name to confirm that you want to terminate the database.

    When concurrent operations such as scaling are active, the confirmation also confirms either pausing or canceling the concurrent operation. See Concurrent Operations on Autonomous Database for more information.

  3. Click Terminate.

Notes for terminating a database:

  • There are limitations for terminating a database when Autonomous Data Guard is enabled with a cross-region standby database. See Terminate a Cross-Region Standby Database for more information.

  • You must first terminate the alastic pool before you terminate a database that is an elastic pool leader. See Terminate an Elastic Pool for more information.

  • After a database is terminated, you can list the terminated databases. To show terminated databases, on the Autonomous Databases list page, in the Search box enter Terminated databases, select Include, and click Apply filter.