oci_database_autonomous_database

This resource provides the Autonomous Database resource in Oracle Cloud Infrastructure Database service.

Creates a new Autonomous Database.

Example Usage

resource "oci_database_autonomous_database" "test_autonomous_database" {
	#Required
	compartment_id = var.compartment_id

	#Optional
	admin_password = var.autonomous_database_admin_password
	are_primary_whitelisted_ips_used = var.autonomous_database_are_primary_whitelisted_ips_used
	auto_refresh_frequency_in_seconds = var.autonomous_database_auto_refresh_frequency_in_seconds
	auto_refresh_point_lag_in_seconds = var.autonomous_database_auto_refresh_point_lag_in_seconds
	autonomous_container_database_id = oci_database_autonomous_container_database.test_autonomous_container_database.id
	autonomous_database_backup_id = oci_database_autonomous_database_backup.test_autonomous_database_backup.id
	autonomous_database_id = oci_database_autonomous_database.test_autonomous_database.id
	autonomous_maintenance_schedule_type = var.autonomous_database_autonomous_maintenance_schedule_type
	backup_retention_period_in_days = var.autonomous_database_backup_retention_period_in_days
	byol_compute_count_limit = var.autonomous_database_byol_compute_count_limit
	character_set = var.autonomous_database_character_set
	clone_table_space_list = var.autonomous_database_clone_table_space_list
	clone_type = var.autonomous_database_clone_type
	compute_count = var.autonomous_database_compute_count
	compute_model = var.autonomous_database_compute_model
	cpu_core_count = var.autonomous_database_cpu_core_count
	customer_contacts {

		#Optional
		email = var.autonomous_database_customer_contacts_email
	}
	data_safe_status = var.autonomous_database_data_safe_status
	data_storage_size_in_gb = var.autonomous_database_data_storage_size_in_gb
	data_storage_size_in_tbs = var.autonomous_database_data_storage_size_in_tbs
	database_edition = var.autonomous_database_database_edition
	db_name = var.autonomous_database_db_name
	db_tools_details {
		#Required
		name = var.autonomous_database_db_tools_details_name

		#Optional
		compute_count = var.autonomous_database_db_tools_details_compute_count
		is_enabled = var.autonomous_database_db_tools_details_is_enabled
		max_idle_time_in_minutes = var.autonomous_database_db_tools_details_max_idle_time_in_minutes
	}
	db_version = var.autonomous_database_db_version
	db_workload = var.autonomous_database_db_workload
	defined_tags = var.autonomous_database_defined_tags
	disaster_recovery_type = var.autonomous_database_disaster_recovery_type
	display_name = var.autonomous_database_display_name
	encryption_key {

		#Optional
		arn_role = var.autonomous_database_encryption_key_arn_role
		autonomous_database_provider = var.autonomous_database_encryption_key_autonomous_database_provider
		certificate_directory_name = var.autonomous_database_encryption_key_certificate_directory_name
		certificate_id = oci_apigateway_certificate.test_certificate.id
		directory_name = var.autonomous_database_encryption_key_directory_name
		external_id = oci_database_external.test_external.id
		key_arn = var.autonomous_database_encryption_key_key_arn
		key_name = oci_kms_key.test_key.name
		kms_key_id = oci_kms_key.test_key.id
		okv_kms_key = var.autonomous_database_encryption_key_okv_kms_key
		okv_uri = var.autonomous_database_encryption_key_okv_uri
		service_endpoint_uri = var.autonomous_database_encryption_key_service_endpoint_uri
		vault_id = oci_kms_vault.test_vault.id
		vault_uri = var.autonomous_database_encryption_key_vault_uri
	}
	freeform_tags = {"Department"= "Finance"}
	in_memory_percentage = var.autonomous_database_in_memory_percentage
	is_access_control_enabled = var.autonomous_database_is_access_control_enabled
	is_auto_scaling_enabled = var.autonomous_database_is_auto_scaling_enabled
	is_auto_scaling_for_storage_enabled = var.autonomous_database_is_auto_scaling_for_storage_enabled
	is_backup_retention_locked = var.autonomous_database_is_backup_retention_locked
	is_data_guard_enabled = var.autonomous_database_is_data_guard_enabled
	is_dedicated = var.autonomous_database_is_dedicated
	is_dev_tier = var.autonomous_database_is_dev_tier
	is_free_tier = var.autonomous_database_is_free_tier
	is_local_data_guard_enabled = var.autonomous_database_is_local_data_guard_enabled
	is_mtls_connection_required = var.autonomous_database_is_mtls_connection_required
	is_preview_version_with_service_terms_accepted = var.autonomous_database_is_preview_version_with_service_terms_accepted
	is_replicate_automatic_backups = var.autonomous_database_is_replicate_automatic_backups
	kms_key_id = oci_kms_key.test_key.id
	license_model = var.autonomous_database_license_model
	ncharacter_set = var.autonomous_database_ncharacter_set
	nsg_ids = var.autonomous_database_nsg_ids
	ocpu_count = var.autonomous_database_ocpu_count
	open_mode = var.autonomous_database_open_mode
	private_endpoint_ip = var.autonomous_database_private_endpoint_ip
	private_endpoint_label = var.autonomous_database_private_endpoint_label
	refreshable_mode = var.autonomous_database_refreshable_mode
	remote_disaster_recovery_type = var.autonomous_database_remote_disaster_recovery_type
	resource_pool_leader_id = oci_database_resource_pool_leader.test_resource_pool_leader.id
	resource_pool_summary {

		#Optional
		is_disabled = var.autonomous_database_resource_pool_summary_is_disabled
		pool_size = var.autonomous_database_resource_pool_summary_pool_size
	}
	scheduled_operations {
		#Required
		day_of_week {
			#Required
			name = var.autonomous_database_scheduled_operations_day_of_week_name
		}

		#Optional
		scheduled_start_time = var.autonomous_database_scheduled_operations_scheduled_start_time
		scheduled_stop_time = var.autonomous_database_scheduled_operations_scheduled_stop_time
	}
	secret_id = oci_vault_secret.test_secret.id
	secret_version_number = var.autonomous_database_secret_version_number
	security_attributes = var.autonomous_database_security_attributes
	source = var.autonomous_database_source
	source_id = oci_database_source.test_source.id
	standby_whitelisted_ips = var.autonomous_database_standby_whitelisted_ips
	subnet_id = oci_core_subnet.test_subnet.id
	subscription_id = oci_onesubscription_subscription.test_subscription.id
	time_of_auto_refresh_start = var.autonomous_database_time_of_auto_refresh_start
	timestamp = var.autonomous_database_timestamp
	use_latest_available_backup_time_stamp = var.autonomous_database_use_latest_available_backup_time_stamp
	vault_id = oci_kms_vault.test_vault.id
	whitelisted_ips = var.autonomous_database_whitelisted_ips
}

Argument Reference

The following arguments are supported:

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Attributes Reference

The following attributes are exported:

Timeouts

The timeouts block allows you to specify timeouts for certain operations: * create - (Defaults to 12 hours), when creating the Autonomous Database * update - (Defaults to 12 hours), when updating the Autonomous Database * delete - (Defaults to 12 hours), when destroying the Autonomous Database

Import

AutonomousDatabases can be imported using the id, e.g.

$ terraform import oci_database_autonomous_database.test_autonomous_database "id"