This page describes how to delete an Autonomous AI Database in Google Cloud. To create a database, see [Create databases](https://docs.cloud.google.com/oracle/database/docs/create-databases.md.txt). To modify an existing database, see [Manage databases](https://docs.cloud.google.com/oracle/database/docs/manage-databases.md.txt). ## Before you begin - [Set up the gcloud CLI and enable the API](https://docs.cloud.google.com/oracle/database/docs/set-up.md.txt). - Enable the Oracle Database@Google Cloud API for the project. [Enable the Oracle Database@Google Cloud API](https://console.cloud.google.com/apis/enableflow?apiid=oracledatabase.googleapis.com) - Confirm that you have the required roles necessary to create an instance: `autonomousDatabaseAdmin`. For more information on how to assign roles, see [Apply IAM roles](https://docs.cloud.google.com/oracle/database/docs/iam-roles.md.txt). ## Delete database > [!WARNING] > **Warning:** Deleting a database permanently removes the database. You can't undo this later. To delete your Autonomous AI Database, complete the following steps: ### Console 1. Go to the **Autonomous AI Database Service** page in the Google Cloud console. [Go to Autonomous AI Database Service](https://console.cloud.google.com/oracle/autonomous-databases/) 2. Click the name of the database you want to delete. 3. Click **Delete** at the top of the page. 4. In the **Delete database instance** dialog, type the Database ID to confirm deletion of your database. 5. Click **Confirm**. Your database is deleted. ### gcloud You can use the `gcloud oracle-database autonomous-databases delete` command to delete a database. gcloud oracle-database autonomous-databases delete DATABASE_ID --location=REGION_ID Replace the following: - DATABASE_ID: the identifier for the database that you want to delete. - REGION_ID: the region for the database that you want to delete. ### C# ```c# using Google.Cloud.OracleDatabase.V1; using Google.LongRunning; using Google.Protobuf.WellKnownTypes; using System.Threading.Tasks; public sealed partial class GeneratedOracleDatabaseClientSnippets { /// Snippet for DeleteAutonomousDatabaseAsync /// /// This snippet has been automatically generated and should be regarded as a code template only. /// It will require modifications to work: /// - It may require correct/in-range values for request initialization. /// - It may require specifying regional endpoints when creating the service client as shown in /// https://cloud.google.com/dotnet/docs/reference/help/client-configuration#endpoint. /// public async Task DeleteAutonomousDatabaseAsync() { // Create client OracleDatabaseClient oracleDatabaseClient = await OracleDatabaseClient.CreateAsync(); // Initialize request argument(s) string name = "projects/[PROJECT]/locations/[LOCATION]/autonomousDatabases/[AUTONOMOUS_DATABASE]"; // Make the request Operation response = await oracleDatabaseClient.DeleteAutonomousDatabaseAsync(name); // Poll until the returned long-running operation is complete Operation completedResponse = await response.PollUntilCompletedAsync(); // Retrieve the operation result Empty result = completedResponse.Result; // Or get the name of the operation string operationName = response.Name; // This name can be stored, then the long-running operation retrieved later by name Operation retrievedResponse = await oracleDatabaseClient.PollOnceDeleteAutonomousDatabaseAsync(operationName); // Check if the retrieved long-running operation has completed if (retrievedResponse.IsCompleted) { // If it has completed, then access the result Empty retrievedResult = retrievedResponse.Result; } } } ``` ### Go ```go //go:build examples package main import ( "context" oracledatabase "cloud.google.com/go/oracledatabase/apiv1" oracledatabasepb "cloud.google.com/go/oracledatabase/apiv1/oracledatabasepb" ) func main() { ctx := context.Background() // This snippet has been automatically generated and should be regarded as a code template only. // It will require modifications to work: // - It may require correct/in-range values for request initialization. // - It may require specifying regional endpoints when creating the service client as shown in: // https://pkg.go.dev/cloud.google.com/go#hdr-Client_Options c, err := oracledatabase.NewClient(ctx) if err != nil { // TODO: Handle error. } defer c.Close() req := &oracledatabasepb.DeleteAutonomousDatabaseRequest{ // TODO: Fill request struct fields. // See https://pkg.go.dev/cloud.google.com/go/oracledatabase/apiv1/oracledatabasepb#DeleteAutonomousDatabaseRequest. } op, err := c.DeleteAutonomousDatabase(ctx, req) if err != nil { // TODO: Handle error. } err = op.Wait(ctx) if err != nil { // TODO: Handle error. } } ``` ### Java ```java import com.google.api.core.ApiFuture; import com.google.cloud.oracledatabase.v1.AutonomousDatabaseName; import com.google.cloud.oracledatabase.v1.DeleteAutonomousDatabaseRequest; import com.google.cloud.oracledatabase.v1.OracleDatabaseClient; import com.google.longrunning.Operation; public class AsyncDeleteAutonomousDatabase { public static void main(String[] args) throws Exception { asyncDeleteAutonomousDatabase(); } public static void asyncDeleteAutonomousDatabase() throws Exception { // This snippet has been automatically generated and should be regarded as a code template only. // It will require modifications to work: // - It may require correct/in-range values for request initialization. // - It may require specifying regional endpoints when creating the service client as shown in // https://cloud.google.com/java/docs/setup#configure_endpoints_for_the_client_library try (OracleDatabaseClient oracleDatabaseClient = OracleDatabaseClient.create()) { DeleteAutonomousDatabaseRequest request = DeleteAutonomousDatabaseRequest.newBuilder() .setName( AutonomousDatabaseName.of("[PROJECT]", "[LOCATION]", "[AUTONOMOUS_DATABASE]") .toString()) .setRequestId("requestId693933066") .build(); ApiFuture future = oracleDatabaseClient.deleteAutonomousDatabaseCallable().futureCall(request); // Do something. future.get(); } } } ``` ### Node.js ```javascript /** * This snippet has been automatically generated and should be regarded as a code template only. * It will require modifications to work. * It may require correct/in-range values for request initialization. * TODO(developer): Uncomment these variables before running the sample. */ /** * Required. The name of the resource in the following format: * projects/{project}/locations/{location}/autonomousDatabases/{autonomous_database}. */ // const name = 'abc123' /** * Optional. An optional ID to identify the request. This value is used to * identify duplicate requests. If you make a request with the same request ID * and the original request is still in progress or completed, the server * ignores the second request. This prevents clients from * accidentally creating duplicate commitments. * The request ID must be a valid UUID with the exception that zero UUID is * not supported (00000000-0000-0000-0000-000000000000). */ // const requestId = 'abc123' // Imports the Oracledatabase library const {OracleDatabaseClient} = require('@google-cloud/oracledatabase').v1; // Instantiates a client const oracledatabaseClient = new OracleDatabaseClient(); async function callDeleteAutonomousDatabase() { // Construct request const request = { name, }; // Run request const [operation] = await oracledatabaseClient.deleteAutonomousDatabase(request); const [response] = await operation.promise(); console.log(response); } callDeleteAutonomousDatabase(); ``` ### PHP ```php use Google\ApiCore\ApiException; use Google\ApiCore\OperationResponse; use Google\Cloud\OracleDatabase\V1\Client\OracleDatabaseClient; use Google\Cloud\OracleDatabase\V1\DeleteAutonomousDatabaseRequest; use Google\Rpc\Status; /** * Deletes a single Autonomous Database. * * @param string $formattedName The name of the resource in the following format: * projects/{project}/locations/{location}/autonomousDatabases/{autonomous_database}. Please see * {@see OracleDatabaseClient::autonomousDatabaseName()} for help formatting this field. */ function delete_autonomous_database_sample(string $formattedName): void { // Create a client. $oracleDatabaseClient = new OracleDatabaseClient(); // Prepare the request message. $request = (new DeleteAutonomousDatabaseRequest()) ->setName($formattedName); // Call the API and handle any network failures. try { /** @var OperationResponse $response */ $response = $oracleDatabaseClient->deleteAutonomousDatabase($request); $response->pollUntilComplete(); if ($response->operationSucceeded()) { printf('Operation completed successfully.' . PHP_EOL); } else { /** @var Status $error */ $error = $response->getError(); printf('Operation failed with error data: %s' . PHP_EOL, $error->serializeToJsonString()); } } catch (ApiException $ex) { printf('Call failed with message: %s' . PHP_EOL, $ex->getMessage()); } } /** * Helper to execute the sample. * * This sample has been automatically generated and should be regarded as a code * template only. It will require modifications to work: * - It may require correct/in-range values for request initialization. * - It may require specifying regional endpoints when creating the service client, * please see the apiEndpoint client configuration option for more details. */ function callSample(): void { $formattedName = OracleDatabaseClient::autonomousDatabaseName( '[PROJECT]', '[LOCATION]', '[AUTONOMOUS_DATABASE]' ); delete_autonomous_database_sample($formattedName); } ``` ### Python ```python # This snippet has been automatically generated and should be regarded as a # code template only. # It will require modifications to work: # - It may require correct/in-range values for request initialization. # - It may require specifying regional endpoints when creating the service # client as shown in: # https://googleapis.dev/python/google-api-core/latest/client_options.html from google.cloud import oracledatabase_v1 def sample_delete_autonomous_database(): # Create a client client = oracledatabase_v1.OracleDatabaseClient() # Initialize request argument(s) request = oracledatabase_v1.DeleteAutonomousDatabaseRequest( name="name_value", ) # Make the request operation = client.delete_autonomous_database(request=request) print("Waiting for operation to complete...") response = operation.result() # Handle the response print(response) ``` ### Ruby ```ruby require "google/cloud/oracle_database/v1" ## # Snippet for the delete_autonomous_database call in the OracleDatabase service # # This snippet has been automatically generated and should be regarded as a code # template only. It will require modifications to work: # - It may require correct/in-range values for request initialization. # - It may require specifying regional endpoints when creating the service # client as shown in https://cloud.google.com/ruby/docs/reference. # # This is an auto-generated example demonstrating basic usage of # Google::Cloud::OracleDatabase::V1::OracleDatabase::Client#delete_autonomous_database. # def delete_autonomous_database # Create a client object. The client can be reused for multiple calls. client = Google::Cloud::OracleDatabase::V1::OracleDatabase::Client.new # Create a request. To set request fields, pass in keyword arguments. request = Google::Cloud::OracleDatabase::V1::DeleteAutonomousDatabaseRequest.new # Call the delete_autonomous_database method. result = client.delete_autonomous_database request # The returned object is of type Gapic::Operation. You can use it to # check the status of an operation, cancel it, or wait for results. # Here is how to wait for a response. result.wait_until_done! timeout: 60 if result.response? p result.response else puts "No response received." end end ``` ## What's next - Learn how to [create](https://docs.cloud.google.com/oracle/database/docs/create-databases.md.txt) or [manage](https://docs.cloud.google.com/oracle/database/docs/manage-databases.md.txt) an Autonomous AI Database. - Configure [Identity and Access Management roles](https://docs.cloud.google.com/oracle/database/docs/iam-roles.md.txt) for a database. - [Use monitoring metrics](https://docs.cloud.google.com/oracle/database/docs/monitoring-metrics.md.txt) to monitor your databases.