Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

AutonomousDatabase

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

Creates a new Autonomous Database.

Create a AutonomousDatabase Resource

new AutonomousDatabase(name: string, args: AutonomousDatabaseArgs, opts?: CustomResourceOptions);
@overload
def AutonomousDatabase(resource_name: str,
                       opts: Optional[ResourceOptions] = None,
                       admin_password: Optional[str] = None,
                       are_primary_whitelisted_ips_used: Optional[bool] = None,
                       autonomous_container_database_id: Optional[str] = None,
                       autonomous_database_backup_id: Optional[str] = None,
                       autonomous_database_id: Optional[str] = None,
                       autonomous_maintenance_schedule_type: Optional[str] = None,
                       clone_type: Optional[str] = None,
                       compartment_id: Optional[str] = None,
                       cpu_core_count: Optional[int] = None,
                       customer_contacts: Optional[Sequence[_database.AutonomousDatabaseCustomerContactArgs]] = None,
                       data_safe_status: Optional[str] = None,
                       data_storage_size_in_gb: Optional[int] = None,
                       data_storage_size_in_tbs: Optional[int] = None,
                       database_edition: Optional[str] = None,
                       database_management_status: Optional[str] = None,
                       db_name: Optional[str] = None,
                       db_version: Optional[str] = None,
                       db_workload: Optional[str] = None,
                       defined_tags: Optional[Mapping[str, Any]] = None,
                       display_name: Optional[str] = None,
                       freeform_tags: Optional[Mapping[str, Any]] = None,
                       is_access_control_enabled: Optional[bool] = None,
                       is_auto_scaling_enabled: Optional[bool] = None,
                       is_auto_scaling_for_storage_enabled: Optional[bool] = None,
                       is_data_guard_enabled: Optional[bool] = None,
                       is_dedicated: Optional[bool] = None,
                       is_free_tier: Optional[bool] = None,
                       is_mtls_connection_required: Optional[bool] = None,
                       is_preview_version_with_service_terms_accepted: Optional[bool] = None,
                       is_refreshable_clone: Optional[bool] = None,
                       is_shrink_only: Optional[bool] = None,
                       kms_key_id: Optional[str] = None,
                       license_model: Optional[str] = None,
                       max_cpu_core_count: Optional[int] = None,
                       nsg_ids: Optional[Sequence[str]] = None,
                       ocpu_count: Optional[float] = None,
                       open_mode: Optional[str] = None,
                       operations_insights_status: Optional[str] = None,
                       permission_level: Optional[str] = None,
                       private_endpoint_label: Optional[str] = None,
                       refreshable_mode: Optional[str] = None,
                       rotate_key_trigger: Optional[bool] = None,
                       scheduled_operations: Optional[Sequence[_database.AutonomousDatabaseScheduledOperationArgs]] = None,
                       source: Optional[str] = None,
                       source_id: Optional[str] = None,
                       standby_whitelisted_ips: Optional[Sequence[str]] = None,
                       state: Optional[str] = None,
                       subnet_id: Optional[str] = None,
                       switchover_to: Optional[str] = None,
                       switchover_to_remote_peer_id: Optional[str] = None,
                       timestamp: Optional[str] = None,
                       vault_id: Optional[str] = None,
                       whitelisted_ips: Optional[Sequence[str]] = None)
@overload
def AutonomousDatabase(resource_name: str,
                       args: AutonomousDatabaseArgs,
                       opts: Optional[ResourceOptions] = None)
func NewAutonomousDatabase(ctx *Context, name string, args AutonomousDatabaseArgs, opts ...ResourceOption) (*AutonomousDatabase, error)
public AutonomousDatabase(string name, AutonomousDatabaseArgs args, CustomResourceOptions? opts = null)
public AutonomousDatabase(String name, AutonomousDatabaseArgs args)
public AutonomousDatabase(String name, AutonomousDatabaseArgs args, CustomResourceOptions options)
type: oci:Database:AutonomousDatabase
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string
The unique name of the resource.
args AutonomousDatabaseArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args AutonomousDatabaseArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args AutonomousDatabaseArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args AutonomousDatabaseArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args AutonomousDatabaseArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

AutonomousDatabase Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The AutonomousDatabase resource accepts the following input properties:

CompartmentId string

(Updatable) The OCID of the compartment of the Autonomous Database.

DbName string

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

AdminPassword string

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

ArePrimaryWhitelistedIpsUsed bool

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

AutonomousContainerDatabaseId string

The Autonomous Container Database OCID.

AutonomousDatabaseBackupId string

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

AutonomousDatabaseId string

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

AutonomousMaintenanceScheduleType string

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

CloneType string

The Autonomous Database clone type.

CpuCoreCount int

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

CustomerContacts List<AutonomousDatabaseCustomerContactArgs>

(Updatable) Customer Contacts.

DataSafeStatus string

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

DataStorageSizeInGb int

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

DataStorageSizeInTbs int

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

DatabaseEdition string

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

DatabaseManagementStatus string

Status of Database Management for this Autonomous Database.

DbVersion string

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

DbWorkload string

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
DefinedTags Dictionary<string, object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DisplayName string

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

FreeformTags Dictionary<string, object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

IsAccessControlEnabled bool

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

IsAutoScalingEnabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

IsAutoScalingForStorageEnabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

IsDataGuardEnabled bool

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

IsDedicated bool

True if the database is on dedicated Exadata infrastructure.

IsFreeTier bool

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

IsMtlsConnectionRequired bool

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

IsPreviewVersionWithServiceTermsAccepted bool

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

IsRefreshableClone bool

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

IsShrinkOnly bool

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

LicenseModel string

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

MaxCpuCoreCount int

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

NsgIds List<string>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
OcpuCount double

(Updatable) The number of OCPU cores to be made available to the database.

OpenMode string

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

OperationsInsightsStatus string

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

PermissionLevel string

The Autonomous Database permission level. Restricted mode allows access only to admin users.

PrivateEndpointLabel string

(Updatable) The private endpoint label for the resource.

RefreshableMode string

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

RotateKeyTrigger bool

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

ScheduledOperations List<AutonomousDatabaseScheduledOperationArgs>

(Updatable) list of scheduled operations

Source string

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

SourceId string

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

StandbyWhitelistedIps List<string>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

State string

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

SubnetId string

(Updatable) The OCID of the subnet the resource is associated with.

SwitchoverTo string

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

SwitchoverToRemotePeerId string

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

Timestamp string

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

WhitelistedIps List<string>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

CompartmentId string

(Updatable) The OCID of the compartment of the Autonomous Database.

DbName string

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

AdminPassword string

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

ArePrimaryWhitelistedIpsUsed bool

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

AutonomousContainerDatabaseId string

The Autonomous Container Database OCID.

AutonomousDatabaseBackupId string

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

AutonomousDatabaseId string

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

AutonomousMaintenanceScheduleType string

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

CloneType string

The Autonomous Database clone type.

CpuCoreCount int

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

CustomerContacts []AutonomousDatabaseCustomerContactArgs

(Updatable) Customer Contacts.

DataSafeStatus string

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

DataStorageSizeInGb int

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

DataStorageSizeInTbs int

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

DatabaseEdition string

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

DatabaseManagementStatus string

Status of Database Management for this Autonomous Database.

DbVersion string

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

DbWorkload string

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
DefinedTags map[string]interface{}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DisplayName string

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

FreeformTags map[string]interface{}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

IsAccessControlEnabled bool

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

IsAutoScalingEnabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

IsAutoScalingForStorageEnabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

IsDataGuardEnabled bool

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

IsDedicated bool

True if the database is on dedicated Exadata infrastructure.

IsFreeTier bool

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

IsMtlsConnectionRequired bool

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

IsPreviewVersionWithServiceTermsAccepted bool

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

IsRefreshableClone bool

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

IsShrinkOnly bool

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

LicenseModel string

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

MaxCpuCoreCount int

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

NsgIds []string

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
OcpuCount float64

(Updatable) The number of OCPU cores to be made available to the database.

OpenMode string

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

OperationsInsightsStatus string

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

PermissionLevel string

The Autonomous Database permission level. Restricted mode allows access only to admin users.

PrivateEndpointLabel string

(Updatable) The private endpoint label for the resource.

RefreshableMode string

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

RotateKeyTrigger bool

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

ScheduledOperations []AutonomousDatabaseScheduledOperationArgs

(Updatable) list of scheduled operations

Source string

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

SourceId string

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

StandbyWhitelistedIps []string

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

State string

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

SubnetId string

(Updatable) The OCID of the subnet the resource is associated with.

SwitchoverTo string

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

SwitchoverToRemotePeerId string

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

Timestamp string

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

WhitelistedIps []string

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

compartmentId String

(Updatable) The OCID of the compartment of the Autonomous Database.

dbName String

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

adminPassword String

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

arePrimaryWhitelistedIpsUsed Boolean

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

autonomousContainerDatabaseId String

The Autonomous Container Database OCID.

autonomousDatabaseBackupId String

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

autonomousDatabaseId String

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

autonomousMaintenanceScheduleType String

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

cloneType String

The Autonomous Database clone type.

cpuCoreCount Integer

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

customerContacts List<AutonomousCustomerContactArgs>

(Updatable) Customer Contacts.

dataSafeStatus String

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

dataStorageSizeInGb Integer

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

dataStorageSizeInTbs Integer

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

databaseEdition String

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

databaseManagementStatus String

Status of Database Management for this Autonomous Database.

dbVersion String

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

dbWorkload String

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
definedTags Map<String,Object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName String

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

freeformTags Map<String,Object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

isAccessControlEnabled Boolean

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

isAutoScalingEnabled Boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

isAutoScalingForStorageEnabled Boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

isDataGuardEnabled Boolean

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

isDedicated Boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier Boolean

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

isMtlsConnectionRequired Boolean

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

isPreviewVersionWithServiceTermsAccepted Boolean

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

isRefreshableClone Boolean

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

isShrinkOnly Boolean

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

licenseModel String

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

maxCpuCoreCount Integer

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

nsgIds List<String>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
ocpuCount Double

(Updatable) The number of OCPU cores to be made available to the database.

openMode String

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

operationsInsightsStatus String

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

permissionLevel String

The Autonomous Database permission level. Restricted mode allows access only to admin users.

privateEndpointLabel String

(Updatable) The private endpoint label for the resource.

refreshableMode String

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

rotateKeyTrigger Boolean

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

scheduledOperations List<AutonomousScheduledOperationArgs>

(Updatable) list of scheduled operations

source String

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

sourceId String

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

standbyWhitelistedIps List<String>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

state String

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

subnetId String

(Updatable) The OCID of the subnet the resource is associated with.

switchoverTo String

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

switchoverToRemotePeerId String

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

timestamp String

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps List<String>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

compartmentId string

(Updatable) The OCID of the compartment of the Autonomous Database.

dbName string

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

adminPassword string

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

arePrimaryWhitelistedIpsUsed boolean

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

autonomousContainerDatabaseId string

The Autonomous Container Database OCID.

autonomousDatabaseBackupId string

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

autonomousDatabaseId string

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

autonomousMaintenanceScheduleType string

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

cloneType string

The Autonomous Database clone type.

cpuCoreCount number

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

customerContacts AutonomousDatabaseCustomerContactArgs[]

(Updatable) Customer Contacts.

dataSafeStatus string

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

dataStorageSizeInGb number

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

dataStorageSizeInTbs number

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

databaseEdition string

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

databaseManagementStatus string

Status of Database Management for this Autonomous Database.

dbVersion string

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

dbWorkload string

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
definedTags {[key: string]: any}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName string

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

freeformTags {[key: string]: any}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

isAccessControlEnabled boolean

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

isAutoScalingEnabled boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

isAutoScalingForStorageEnabled boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

isDataGuardEnabled boolean

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

isDedicated boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier boolean

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

isMtlsConnectionRequired boolean

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

isPreviewVersionWithServiceTermsAccepted boolean

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

isRefreshableClone boolean

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

isShrinkOnly boolean

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

kmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

licenseModel string

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

maxCpuCoreCount number

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

nsgIds string[]

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
ocpuCount number

(Updatable) The number of OCPU cores to be made available to the database.

openMode string

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

operationsInsightsStatus string

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

permissionLevel string

The Autonomous Database permission level. Restricted mode allows access only to admin users.

privateEndpointLabel string

(Updatable) The private endpoint label for the resource.

refreshableMode string

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

rotateKeyTrigger boolean

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

scheduledOperations AutonomousDatabaseScheduledOperationArgs[]

(Updatable) list of scheduled operations

source string

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

sourceId string

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

standbyWhitelistedIps string[]

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

state string

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

subnetId string

(Updatable) The OCID of the subnet the resource is associated with.

switchoverTo string

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

switchoverToRemotePeerId string

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

timestamp string

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

vaultId string

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps string[]

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

compartment_id str

(Updatable) The OCID of the compartment of the Autonomous Database.

db_name str

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

admin_password str

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

are_primary_whitelisted_ips_used bool

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

autonomous_container_database_id str

The Autonomous Container Database OCID.

autonomous_database_backup_id str

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

autonomous_database_id str

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

autonomous_maintenance_schedule_type str

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

clone_type str

The Autonomous Database clone type.

cpu_core_count int

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

customer_contacts AutonomousDatabaseCustomerContactArgs]

(Updatable) Customer Contacts.

data_safe_status str

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

data_storage_size_in_gb int

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

data_storage_size_in_tbs int

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

database_edition str

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

database_management_status str

Status of Database Management for this Autonomous Database.

db_version str

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

db_workload str

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
defined_tags Mapping[str, Any]

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

display_name str

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

freeform_tags Mapping[str, Any]

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

is_access_control_enabled bool

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

is_auto_scaling_enabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

is_auto_scaling_for_storage_enabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

is_data_guard_enabled bool

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

is_dedicated bool

True if the database is on dedicated Exadata infrastructure.

is_free_tier bool

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

is_mtls_connection_required bool

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

is_preview_version_with_service_terms_accepted bool

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

is_refreshable_clone bool

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

is_shrink_only bool

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

kms_key_id str

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

license_model str

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

max_cpu_core_count int

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

nsg_ids Sequence[str]

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
ocpu_count float

(Updatable) The number of OCPU cores to be made available to the database.

open_mode str

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

operations_insights_status str

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

permission_level str

The Autonomous Database permission level. Restricted mode allows access only to admin users.

private_endpoint_label str

(Updatable) The private endpoint label for the resource.

refreshable_mode str

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

rotate_key_trigger bool

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

scheduled_operations AutonomousDatabaseScheduledOperationArgs]

(Updatable) list of scheduled operations

source str

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

source_id str

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

standby_whitelisted_ips Sequence[str]

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

state str

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

subnet_id str

(Updatable) The OCID of the subnet the resource is associated with.

switchover_to str

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

switchover_to_remote_peer_id str

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

timestamp str

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

vault_id str

The OCID of the Oracle Cloud Infrastructure vault.

whitelisted_ips Sequence[str]

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

compartmentId String

(Updatable) The OCID of the compartment of the Autonomous Database.

dbName String

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

adminPassword String

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

arePrimaryWhitelistedIpsUsed Boolean

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

autonomousContainerDatabaseId String

The Autonomous Container Database OCID.

autonomousDatabaseBackupId String

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

autonomousDatabaseId String

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

autonomousMaintenanceScheduleType String

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

cloneType String

The Autonomous Database clone type.

cpuCoreCount Number

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

customerContacts List<Property Map>

(Updatable) Customer Contacts.

dataSafeStatus String

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

dataStorageSizeInGb Number

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

dataStorageSizeInTbs Number

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

databaseEdition String

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

databaseManagementStatus String

Status of Database Management for this Autonomous Database.

dbVersion String

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

dbWorkload String

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
definedTags Map<Any>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName String

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

freeformTags Map<Any>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

isAccessControlEnabled Boolean

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

isAutoScalingEnabled Boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

isAutoScalingForStorageEnabled Boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

isDataGuardEnabled Boolean

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

isDedicated Boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier Boolean

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

isMtlsConnectionRequired Boolean

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

isPreviewVersionWithServiceTermsAccepted Boolean

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

isRefreshableClone Boolean

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

isShrinkOnly Boolean

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

licenseModel String

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

maxCpuCoreCount Number

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

nsgIds List<String>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
ocpuCount Number

(Updatable) The number of OCPU cores to be made available to the database.

openMode String

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

operationsInsightsStatus String

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

permissionLevel String

The Autonomous Database permission level. Restricted mode allows access only to admin users.

privateEndpointLabel String

(Updatable) The private endpoint label for the resource.

refreshableMode String

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

rotateKeyTrigger Boolean

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

scheduledOperations List<Property Map>

(Updatable) list of scheduled operations

source String

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

sourceId String

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

standbyWhitelistedIps List<String>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

state String

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

subnetId String

(Updatable) The OCID of the subnet the resource is associated with.

switchoverTo String

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

switchoverToRemotePeerId String

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

timestamp String

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps List<String>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

Outputs

All input properties are implicitly available as output properties. Additionally, the AutonomousDatabase resource produces the following output properties:

ActualUsedDataStorageSizeInTbs double

The current amount of storage in use for user and system data, in terabytes (TB).

AllocatedStorageSizeInTbs double

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

ApexDetails List<AutonomousDatabaseApexDetail>

Information about Oracle APEX Application Development.

AvailableUpgradeVersions List<string>

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

BackupConfigs List<AutonomousDatabaseBackupConfig>

Autonomous Database configuration details for storing manual backups in the Object Storage service.

ConnectionStrings List<AutonomousDatabaseConnectionString>

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

ConnectionUrls List<AutonomousDatabaseConnectionUrl>

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

DataguardRegionType string

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

FailedDataRecoveryInSeconds int

Indicates the number of seconds of data loss for a Data Guard failover.

Id string

The provider-assigned unique ID for this managed resource.

InfrastructureType string

The infrastructure type this resource belongs to.

IsPreview bool

Indicates if the Autonomous Database version is a preview version.

IsReconnectCloneEnabled bool

Indicates if the refreshable clone can be reconnected to its source database.

KeyHistoryEntries List<AutonomousDatabaseKeyHistoryEntry>

Key History Entry.

KeyStoreId string

The OCID of the key store.

KeyStoreWalletName string

The wallet name for Oracle Key Vault.

KmsKeyLifecycleDetails string

KMS key lifecycle details.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LifecycleDetails string

Additional information about the current lifecycle state.

MemoryPerOracleComputeUnitInGbs int

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

PeerDbIds List<string>

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

PrivateEndpoint string

The private endpoint for the resource.

PrivateEndpointIp string

The private endpoint Ip address for the resource.

RefreshableStatus string

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

Role string

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

ServiceConsoleUrl string

The URL of the Service Console for the Autonomous Database.

StandbyDbs List<AutonomousDatabaseStandbyDb>

Autonomous Data Guard standby database details.

SupportedRegionsToCloneTos List<string>

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

SystemTags Dictionary<string, object>

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

TimeCreated string

The date and time the Autonomous Database was created.

TimeDataGuardRoleChanged string

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

TimeDeletionOfFreeAutonomousDatabase string

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

TimeLocalDataGuardEnabled string

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

TimeMaintenanceBegin string

The date and time when maintenance will begin.

TimeMaintenanceEnd string

The date and time when maintenance will end.

TimeOfLastFailover string

The timestamp of the last failover operation.

TimeOfLastRefresh string

The date and time when last refresh happened.

TimeOfLastRefreshPoint string

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

TimeOfLastSwitchover string

The timestamp of the last switchover operation for the Autonomous Database.

TimeOfNextRefresh string

The date and time of next refresh.

TimeReclamationOfFreeAutonomousDatabase string

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

TimeUntilReconnectCloneEnabled string

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

UsedDataStorageSizeInTbs int

The amount of storage that has been used, in terabytes.

ActualUsedDataStorageSizeInTbs float64

The current amount of storage in use for user and system data, in terabytes (TB).

AllocatedStorageSizeInTbs float64

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

ApexDetails []AutonomousDatabaseApexDetail

Information about Oracle APEX Application Development.

AvailableUpgradeVersions []string

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

BackupConfigs []AutonomousDatabaseBackupConfig

Autonomous Database configuration details for storing manual backups in the Object Storage service.

ConnectionStrings []AutonomousDatabaseConnectionString

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

ConnectionUrls []AutonomousDatabaseConnectionUrl

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

DataguardRegionType string

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

FailedDataRecoveryInSeconds int

Indicates the number of seconds of data loss for a Data Guard failover.

Id string

The provider-assigned unique ID for this managed resource.

InfrastructureType string

The infrastructure type this resource belongs to.

IsPreview bool

Indicates if the Autonomous Database version is a preview version.

IsReconnectCloneEnabled bool

Indicates if the refreshable clone can be reconnected to its source database.

KeyHistoryEntries []AutonomousDatabaseKeyHistoryEntry

Key History Entry.

KeyStoreId string

The OCID of the key store.

KeyStoreWalletName string

The wallet name for Oracle Key Vault.

KmsKeyLifecycleDetails string

KMS key lifecycle details.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LifecycleDetails string

Additional information about the current lifecycle state.

MemoryPerOracleComputeUnitInGbs int

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

PeerDbIds []string

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

PrivateEndpoint string

The private endpoint for the resource.

PrivateEndpointIp string

The private endpoint Ip address for the resource.

RefreshableStatus string

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

Role string

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

ServiceConsoleUrl string

The URL of the Service Console for the Autonomous Database.

StandbyDbs []AutonomousDatabaseStandbyDb

Autonomous Data Guard standby database details.

SupportedRegionsToCloneTos []string

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

SystemTags map[string]interface{}

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

TimeCreated string

The date and time the Autonomous Database was created.

TimeDataGuardRoleChanged string

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

TimeDeletionOfFreeAutonomousDatabase string

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

TimeLocalDataGuardEnabled string

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

TimeMaintenanceBegin string

The date and time when maintenance will begin.

TimeMaintenanceEnd string

The date and time when maintenance will end.

TimeOfLastFailover string

The timestamp of the last failover operation.

TimeOfLastRefresh string

The date and time when last refresh happened.

TimeOfLastRefreshPoint string

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

TimeOfLastSwitchover string

The timestamp of the last switchover operation for the Autonomous Database.

TimeOfNextRefresh string

The date and time of next refresh.

TimeReclamationOfFreeAutonomousDatabase string

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

TimeUntilReconnectCloneEnabled string

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

UsedDataStorageSizeInTbs int

The amount of storage that has been used, in terabytes.

actualUsedDataStorageSizeInTbs Double

The current amount of storage in use for user and system data, in terabytes (TB).

allocatedStorageSizeInTbs Double

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

apexDetails List<AutonomousApexDetail>

Information about Oracle APEX Application Development.

availableUpgradeVersions List<String>

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

backupConfigs List<AutonomousBackupConfig>

Autonomous Database configuration details for storing manual backups in the Object Storage service.

connectionStrings List<AutonomousConnectionString>

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

connectionUrls List<AutonomousConnectionUrl>

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

dataguardRegionType String

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

failedDataRecoveryInSeconds Integer

Indicates the number of seconds of data loss for a Data Guard failover.

id String

The provider-assigned unique ID for this managed resource.

infrastructureType String

The infrastructure type this resource belongs to.

isPreview Boolean

Indicates if the Autonomous Database version is a preview version.

isReconnectCloneEnabled Boolean

Indicates if the refreshable clone can be reconnected to its source database.

keyHistoryEntries List<AutonomousKeyHistoryEntry>

Key History Entry.

keyStoreId String

The OCID of the key store.

keyStoreWalletName String

The wallet name for Oracle Key Vault.

kmsKeyLifecycleDetails String

KMS key lifecycle details.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lifecycleDetails String

Additional information about the current lifecycle state.

memoryPerOracleComputeUnitInGbs Integer

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

peerDbIds List<String>

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

privateEndpoint String

The private endpoint for the resource.

privateEndpointIp String

The private endpoint Ip address for the resource.

refreshableStatus String

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

role String

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

serviceConsoleUrl String

The URL of the Service Console for the Autonomous Database.

standbyDbs List<AutonomousStandbyDb>

Autonomous Data Guard standby database details.

supportedRegionsToCloneTos List<String>

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

systemTags Map<String,Object>

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

timeCreated String

The date and time the Autonomous Database was created.

timeDataGuardRoleChanged String

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

timeDeletionOfFreeAutonomousDatabase String

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

timeLocalDataGuardEnabled String

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

timeMaintenanceBegin String

The date and time when maintenance will begin.

timeMaintenanceEnd String

The date and time when maintenance will end.

timeOfLastFailover String

The timestamp of the last failover operation.

timeOfLastRefresh String

The date and time when last refresh happened.

timeOfLastRefreshPoint String

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

timeOfLastSwitchover String

The timestamp of the last switchover operation for the Autonomous Database.

timeOfNextRefresh String

The date and time of next refresh.

timeReclamationOfFreeAutonomousDatabase String

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

timeUntilReconnectCloneEnabled String

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

usedDataStorageSizeInTbs Integer

The amount of storage that has been used, in terabytes.

actualUsedDataStorageSizeInTbs number

The current amount of storage in use for user and system data, in terabytes (TB).

allocatedStorageSizeInTbs number

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

apexDetails AutonomousDatabaseApexDetail[]

Information about Oracle APEX Application Development.

availableUpgradeVersions string[]

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

backupConfigs AutonomousDatabaseBackupConfig[]

Autonomous Database configuration details for storing manual backups in the Object Storage service.

connectionStrings AutonomousDatabaseConnectionString[]

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

connectionUrls AutonomousDatabaseConnectionUrl[]

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

dataguardRegionType string

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

failedDataRecoveryInSeconds number

Indicates the number of seconds of data loss for a Data Guard failover.

id string

The provider-assigned unique ID for this managed resource.

infrastructureType string

The infrastructure type this resource belongs to.

isPreview boolean

Indicates if the Autonomous Database version is a preview version.

isReconnectCloneEnabled boolean

Indicates if the refreshable clone can be reconnected to its source database.

keyHistoryEntries AutonomousDatabaseKeyHistoryEntry[]

Key History Entry.

keyStoreId string

The OCID of the key store.

keyStoreWalletName string

The wallet name for Oracle Key Vault.

kmsKeyLifecycleDetails string

KMS key lifecycle details.

kmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lifecycleDetails string

Additional information about the current lifecycle state.

memoryPerOracleComputeUnitInGbs number

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

peerDbIds string[]

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

privateEndpoint string

The private endpoint for the resource.

privateEndpointIp string

The private endpoint Ip address for the resource.

refreshableStatus string

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

role string

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

serviceConsoleUrl string

The URL of the Service Console for the Autonomous Database.

standbyDbs AutonomousDatabaseStandbyDb[]

Autonomous Data Guard standby database details.

supportedRegionsToCloneTos string[]

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

systemTags {[key: string]: any}

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

timeCreated string

The date and time the Autonomous Database was created.

timeDataGuardRoleChanged string

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

timeDeletionOfFreeAutonomousDatabase string

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

timeLocalDataGuardEnabled string

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

timeMaintenanceBegin string

The date and time when maintenance will begin.

timeMaintenanceEnd string

The date and time when maintenance will end.

timeOfLastFailover string

The timestamp of the last failover operation.

timeOfLastRefresh string

The date and time when last refresh happened.

timeOfLastRefreshPoint string

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

timeOfLastSwitchover string

The timestamp of the last switchover operation for the Autonomous Database.

timeOfNextRefresh string

The date and time of next refresh.

timeReclamationOfFreeAutonomousDatabase string

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

timeUntilReconnectCloneEnabled string

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

usedDataStorageSizeInTbs number

The amount of storage that has been used, in terabytes.

actual_used_data_storage_size_in_tbs float

The current amount of storage in use for user and system data, in terabytes (TB).

allocated_storage_size_in_tbs float

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

apex_details AutonomousDatabaseApexDetail]

Information about Oracle APEX Application Development.

available_upgrade_versions Sequence[str]

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

backup_configs AutonomousDatabaseBackupConfig]

Autonomous Database configuration details for storing manual backups in the Object Storage service.

connection_strings AutonomousDatabaseConnectionString]

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

connection_urls AutonomousDatabaseConnectionUrl]

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

dataguard_region_type str

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

failed_data_recovery_in_seconds int

Indicates the number of seconds of data loss for a Data Guard failover.

id str

The provider-assigned unique ID for this managed resource.

infrastructure_type str

The infrastructure type this resource belongs to.

is_preview bool

Indicates if the Autonomous Database version is a preview version.

is_reconnect_clone_enabled bool

Indicates if the refreshable clone can be reconnected to its source database.

key_history_entries AutonomousDatabaseKeyHistoryEntry]

Key History Entry.

key_store_id str

The OCID of the key store.

key_store_wallet_name str

The wallet name for Oracle Key Vault.

kms_key_lifecycle_details str

KMS key lifecycle details.

kms_key_version_id str

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lifecycle_details str

Additional information about the current lifecycle state.

memory_per_oracle_compute_unit_in_gbs int

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

peer_db_ids Sequence[str]

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

private_endpoint str

The private endpoint for the resource.

private_endpoint_ip str

The private endpoint Ip address for the resource.

refreshable_status str

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

role str

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

service_console_url str

The URL of the Service Console for the Autonomous Database.

standby_dbs AutonomousDatabaseStandbyDb]

Autonomous Data Guard standby database details.

supported_regions_to_clone_tos Sequence[str]

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

system_tags Mapping[str, Any]

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

time_created str

The date and time the Autonomous Database was created.

time_data_guard_role_changed str

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

time_deletion_of_free_autonomous_database str

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

time_local_data_guard_enabled str

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

time_maintenance_begin str

The date and time when maintenance will begin.

time_maintenance_end str

The date and time when maintenance will end.

time_of_last_failover str

The timestamp of the last failover operation.

time_of_last_refresh str

The date and time when last refresh happened.

time_of_last_refresh_point str

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

time_of_last_switchover str

The timestamp of the last switchover operation for the Autonomous Database.

time_of_next_refresh str

The date and time of next refresh.

time_reclamation_of_free_autonomous_database str

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

time_until_reconnect_clone_enabled str

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

used_data_storage_size_in_tbs int

The amount of storage that has been used, in terabytes.

actualUsedDataStorageSizeInTbs Number

The current amount of storage in use for user and system data, in terabytes (TB).

allocatedStorageSizeInTbs Number

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

apexDetails List<Property Map>

Information about Oracle APEX Application Development.

availableUpgradeVersions List<String>

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

backupConfigs List<Property Map>

Autonomous Database configuration details for storing manual backups in the Object Storage service.

connectionStrings List<Property Map>

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

connectionUrls List<Property Map>

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

dataguardRegionType String

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

failedDataRecoveryInSeconds Number

Indicates the number of seconds of data loss for a Data Guard failover.

id String

The provider-assigned unique ID for this managed resource.

infrastructureType String

The infrastructure type this resource belongs to.

isPreview Boolean

Indicates if the Autonomous Database version is a preview version.

isReconnectCloneEnabled Boolean

Indicates if the refreshable clone can be reconnected to its source database.

keyHistoryEntries List<Property Map>

Key History Entry.

keyStoreId String

The OCID of the key store.

keyStoreWalletName String

The wallet name for Oracle Key Vault.

kmsKeyLifecycleDetails String

KMS key lifecycle details.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lifecycleDetails String

Additional information about the current lifecycle state.

memoryPerOracleComputeUnitInGbs Number

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

peerDbIds List<String>

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

privateEndpoint String

The private endpoint for the resource.

privateEndpointIp String

The private endpoint Ip address for the resource.

refreshableStatus String

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

role String

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

serviceConsoleUrl String

The URL of the Service Console for the Autonomous Database.

standbyDbs List<Property Map>

Autonomous Data Guard standby database details.

supportedRegionsToCloneTos List<String>

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

systemTags Map<Any>

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

timeCreated String

The date and time the Autonomous Database was created.

timeDataGuardRoleChanged String

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

timeDeletionOfFreeAutonomousDatabase String

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

timeLocalDataGuardEnabled String

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

timeMaintenanceBegin String

The date and time when maintenance will begin.

timeMaintenanceEnd String

The date and time when maintenance will end.

timeOfLastFailover String

The timestamp of the last failover operation.

timeOfLastRefresh String

The date and time when last refresh happened.

timeOfLastRefreshPoint String

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

timeOfLastSwitchover String

The timestamp of the last switchover operation for the Autonomous Database.

timeOfNextRefresh String

The date and time of next refresh.

timeReclamationOfFreeAutonomousDatabase String

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

timeUntilReconnectCloneEnabled String

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

usedDataStorageSizeInTbs Number

The amount of storage that has been used, in terabytes.

Look up an Existing AutonomousDatabase Resource

Get an existing AutonomousDatabase resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: AutonomousDatabaseState, opts?: CustomResourceOptions): AutonomousDatabase
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        actual_used_data_storage_size_in_tbs: Optional[float] = None,
        admin_password: Optional[str] = None,
        allocated_storage_size_in_tbs: Optional[float] = None,
        apex_details: Optional[Sequence[_database.AutonomousDatabaseApexDetailArgs]] = None,
        are_primary_whitelisted_ips_used: Optional[bool] = None,
        autonomous_container_database_id: Optional[str] = None,
        autonomous_database_backup_id: Optional[str] = None,
        autonomous_database_id: Optional[str] = None,
        autonomous_maintenance_schedule_type: Optional[str] = None,
        available_upgrade_versions: Optional[Sequence[str]] = None,
        backup_configs: Optional[Sequence[_database.AutonomousDatabaseBackupConfigArgs]] = None,
        clone_type: Optional[str] = None,
        compartment_id: Optional[str] = None,
        connection_strings: Optional[Sequence[_database.AutonomousDatabaseConnectionStringArgs]] = None,
        connection_urls: Optional[Sequence[_database.AutonomousDatabaseConnectionUrlArgs]] = None,
        cpu_core_count: Optional[int] = None,
        customer_contacts: Optional[Sequence[_database.AutonomousDatabaseCustomerContactArgs]] = None,
        data_safe_status: Optional[str] = None,
        data_storage_size_in_gb: Optional[int] = None,
        data_storage_size_in_tbs: Optional[int] = None,
        database_edition: Optional[str] = None,
        database_management_status: Optional[str] = None,
        dataguard_region_type: Optional[str] = None,
        db_name: Optional[str] = None,
        db_version: Optional[str] = None,
        db_workload: Optional[str] = None,
        defined_tags: Optional[Mapping[str, Any]] = None,
        display_name: Optional[str] = None,
        failed_data_recovery_in_seconds: Optional[int] = None,
        freeform_tags: Optional[Mapping[str, Any]] = None,
        infrastructure_type: Optional[str] = None,
        is_access_control_enabled: Optional[bool] = None,
        is_auto_scaling_enabled: Optional[bool] = None,
        is_auto_scaling_for_storage_enabled: Optional[bool] = None,
        is_data_guard_enabled: Optional[bool] = None,
        is_dedicated: Optional[bool] = None,
        is_free_tier: Optional[bool] = None,
        is_mtls_connection_required: Optional[bool] = None,
        is_preview: Optional[bool] = None,
        is_preview_version_with_service_terms_accepted: Optional[bool] = None,
        is_reconnect_clone_enabled: Optional[bool] = None,
        is_refreshable_clone: Optional[bool] = None,
        is_shrink_only: Optional[bool] = None,
        key_history_entries: Optional[Sequence[_database.AutonomousDatabaseKeyHistoryEntryArgs]] = None,
        key_store_id: Optional[str] = None,
        key_store_wallet_name: Optional[str] = None,
        kms_key_id: Optional[str] = None,
        kms_key_lifecycle_details: Optional[str] = None,
        kms_key_version_id: Optional[str] = None,
        license_model: Optional[str] = None,
        lifecycle_details: Optional[str] = None,
        max_cpu_core_count: Optional[int] = None,
        memory_per_oracle_compute_unit_in_gbs: Optional[int] = None,
        nsg_ids: Optional[Sequence[str]] = None,
        ocpu_count: Optional[float] = None,
        open_mode: Optional[str] = None,
        operations_insights_status: Optional[str] = None,
        peer_db_ids: Optional[Sequence[str]] = None,
        permission_level: Optional[str] = None,
        private_endpoint: Optional[str] = None,
        private_endpoint_ip: Optional[str] = None,
        private_endpoint_label: Optional[str] = None,
        refreshable_mode: Optional[str] = None,
        refreshable_status: Optional[str] = None,
        role: Optional[str] = None,
        rotate_key_trigger: Optional[bool] = None,
        scheduled_operations: Optional[Sequence[_database.AutonomousDatabaseScheduledOperationArgs]] = None,
        service_console_url: Optional[str] = None,
        source: Optional[str] = None,
        source_id: Optional[str] = None,
        standby_dbs: Optional[Sequence[_database.AutonomousDatabaseStandbyDbArgs]] = None,
        standby_whitelisted_ips: Optional[Sequence[str]] = None,
        state: Optional[str] = None,
        subnet_id: Optional[str] = None,
        supported_regions_to_clone_tos: Optional[Sequence[str]] = None,
        switchover_to: Optional[str] = None,
        switchover_to_remote_peer_id: Optional[str] = None,
        system_tags: Optional[Mapping[str, Any]] = None,
        time_created: Optional[str] = None,
        time_data_guard_role_changed: Optional[str] = None,
        time_deletion_of_free_autonomous_database: Optional[str] = None,
        time_local_data_guard_enabled: Optional[str] = None,
        time_maintenance_begin: Optional[str] = None,
        time_maintenance_end: Optional[str] = None,
        time_of_last_failover: Optional[str] = None,
        time_of_last_refresh: Optional[str] = None,
        time_of_last_refresh_point: Optional[str] = None,
        time_of_last_switchover: Optional[str] = None,
        time_of_next_refresh: Optional[str] = None,
        time_reclamation_of_free_autonomous_database: Optional[str] = None,
        time_until_reconnect_clone_enabled: Optional[str] = None,
        timestamp: Optional[str] = None,
        used_data_storage_size_in_tbs: Optional[int] = None,
        vault_id: Optional[str] = None,
        whitelisted_ips: Optional[Sequence[str]] = None) -> AutonomousDatabase
func GetAutonomousDatabase(ctx *Context, name string, id IDInput, state *AutonomousDatabaseState, opts ...ResourceOption) (*AutonomousDatabase, error)
public static AutonomousDatabase Get(string name, Input<string> id, AutonomousDatabaseState? state, CustomResourceOptions? opts = null)
public static AutonomousDatabase get(String name, Output<String> id, AutonomousDatabaseState state, CustomResourceOptions options)
Resource lookup is not supported in YAML
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
resource_name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
ActualUsedDataStorageSizeInTbs double

The current amount of storage in use for user and system data, in terabytes (TB).

AdminPassword string

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

AllocatedStorageSizeInTbs double

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

ApexDetails List<AutonomousDatabaseApexDetailArgs>

Information about Oracle APEX Application Development.

ArePrimaryWhitelistedIpsUsed bool

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

AutonomousContainerDatabaseId string

The Autonomous Container Database OCID.

AutonomousDatabaseBackupId string

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

AutonomousDatabaseId string

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

AutonomousMaintenanceScheduleType string

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

AvailableUpgradeVersions List<string>

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

BackupConfigs List<AutonomousDatabaseBackupConfigArgs>

Autonomous Database configuration details for storing manual backups in the Object Storage service.

CloneType string

The Autonomous Database clone type.

CompartmentId string

(Updatable) The OCID of the compartment of the Autonomous Database.

ConnectionStrings List<AutonomousDatabaseConnectionStringArgs>

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

ConnectionUrls List<AutonomousDatabaseConnectionUrlArgs>

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

CpuCoreCount int

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

CustomerContacts List<AutonomousDatabaseCustomerContactArgs>

(Updatable) Customer Contacts.

DataSafeStatus string

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

DataStorageSizeInGb int

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

DataStorageSizeInTbs int

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

DatabaseEdition string

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

DatabaseManagementStatus string

Status of Database Management for this Autonomous Database.

DataguardRegionType string

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

DbName string

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

DbVersion string

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

DbWorkload string

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
DefinedTags Dictionary<string, object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DisplayName string

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

FailedDataRecoveryInSeconds int

Indicates the number of seconds of data loss for a Data Guard failover.

FreeformTags Dictionary<string, object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

InfrastructureType string

The infrastructure type this resource belongs to.

IsAccessControlEnabled bool

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

IsAutoScalingEnabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

IsAutoScalingForStorageEnabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

IsDataGuardEnabled bool

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

IsDedicated bool

True if the database is on dedicated Exadata infrastructure.

IsFreeTier bool

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

IsMtlsConnectionRequired bool

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

IsPreview bool

Indicates if the Autonomous Database version is a preview version.

IsPreviewVersionWithServiceTermsAccepted bool

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

IsReconnectCloneEnabled bool

Indicates if the refreshable clone can be reconnected to its source database.

IsRefreshableClone bool

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

IsShrinkOnly bool

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

KeyHistoryEntries List<AutonomousDatabaseKeyHistoryEntryArgs>

Key History Entry.

KeyStoreId string

The OCID of the key store.

KeyStoreWalletName string

The wallet name for Oracle Key Vault.

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

KmsKeyLifecycleDetails string

KMS key lifecycle details.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LicenseModel string

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

LifecycleDetails string

Additional information about the current lifecycle state.

MaxCpuCoreCount int

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

MemoryPerOracleComputeUnitInGbs int

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

NsgIds List<string>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
OcpuCount double

(Updatable) The number of OCPU cores to be made available to the database.

OpenMode string

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

OperationsInsightsStatus string

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

PeerDbIds List<string>

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

PermissionLevel string

The Autonomous Database permission level. Restricted mode allows access only to admin users.

PrivateEndpoint string

The private endpoint for the resource.

PrivateEndpointIp string

The private endpoint Ip address for the resource.

PrivateEndpointLabel string

(Updatable) The private endpoint label for the resource.

RefreshableMode string

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

RefreshableStatus string

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

Role string

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

RotateKeyTrigger bool

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

ScheduledOperations List<AutonomousDatabaseScheduledOperationArgs>

(Updatable) list of scheduled operations

ServiceConsoleUrl string

The URL of the Service Console for the Autonomous Database.

Source string

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

SourceId string

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

StandbyDbs List<AutonomousDatabaseStandbyDbArgs>

Autonomous Data Guard standby database details.

StandbyWhitelistedIps List<string>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

State string

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

SubnetId string

(Updatable) The OCID of the subnet the resource is associated with.

SupportedRegionsToCloneTos List<string>

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

SwitchoverTo string

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

SwitchoverToRemotePeerId string

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

SystemTags Dictionary<string, object>

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

TimeCreated string

The date and time the Autonomous Database was created.

TimeDataGuardRoleChanged string

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

TimeDeletionOfFreeAutonomousDatabase string

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

TimeLocalDataGuardEnabled string

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

TimeMaintenanceBegin string

The date and time when maintenance will begin.

TimeMaintenanceEnd string

The date and time when maintenance will end.

TimeOfLastFailover string

The timestamp of the last failover operation.

TimeOfLastRefresh string

The date and time when last refresh happened.

TimeOfLastRefreshPoint string

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

TimeOfLastSwitchover string

The timestamp of the last switchover operation for the Autonomous Database.

TimeOfNextRefresh string

The date and time of next refresh.

TimeReclamationOfFreeAutonomousDatabase string

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

TimeUntilReconnectCloneEnabled string

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

Timestamp string

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

UsedDataStorageSizeInTbs int

The amount of storage that has been used, in terabytes.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

WhitelistedIps List<string>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

ActualUsedDataStorageSizeInTbs float64

The current amount of storage in use for user and system data, in terabytes (TB).

AdminPassword string

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

AllocatedStorageSizeInTbs float64

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

ApexDetails []AutonomousDatabaseApexDetailArgs

Information about Oracle APEX Application Development.

ArePrimaryWhitelistedIpsUsed bool

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

AutonomousContainerDatabaseId string

The Autonomous Container Database OCID.

AutonomousDatabaseBackupId string

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

AutonomousDatabaseId string

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

AutonomousMaintenanceScheduleType string

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

AvailableUpgradeVersions []string

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

BackupConfigs []AutonomousDatabaseBackupConfigArgs

Autonomous Database configuration details for storing manual backups in the Object Storage service.

CloneType string

The Autonomous Database clone type.

CompartmentId string

(Updatable) The OCID of the compartment of the Autonomous Database.

ConnectionStrings []AutonomousDatabaseConnectionStringArgs

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

ConnectionUrls []AutonomousDatabaseConnectionUrlArgs

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

CpuCoreCount int

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

CustomerContacts []AutonomousDatabaseCustomerContactArgs

(Updatable) Customer Contacts.

DataSafeStatus string

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

DataStorageSizeInGb int

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

DataStorageSizeInTbs int

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

DatabaseEdition string

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

DatabaseManagementStatus string

Status of Database Management for this Autonomous Database.

DataguardRegionType string

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

DbName string

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

DbVersion string

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

DbWorkload string

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
DefinedTags map[string]interface{}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DisplayName string

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

FailedDataRecoveryInSeconds int

Indicates the number of seconds of data loss for a Data Guard failover.

FreeformTags map[string]interface{}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

InfrastructureType string

The infrastructure type this resource belongs to.

IsAccessControlEnabled bool

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

IsAutoScalingEnabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

IsAutoScalingForStorageEnabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

IsDataGuardEnabled bool

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

IsDedicated bool

True if the database is on dedicated Exadata infrastructure.

IsFreeTier bool

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

IsMtlsConnectionRequired bool

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

IsPreview bool

Indicates if the Autonomous Database version is a preview version.

IsPreviewVersionWithServiceTermsAccepted bool

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

IsReconnectCloneEnabled bool

Indicates if the refreshable clone can be reconnected to its source database.

IsRefreshableClone bool

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

IsShrinkOnly bool

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

KeyHistoryEntries []AutonomousDatabaseKeyHistoryEntryArgs

Key History Entry.

KeyStoreId string

The OCID of the key store.

KeyStoreWalletName string

The wallet name for Oracle Key Vault.

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

KmsKeyLifecycleDetails string

KMS key lifecycle details.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LicenseModel string

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

LifecycleDetails string

Additional information about the current lifecycle state.

MaxCpuCoreCount int

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

MemoryPerOracleComputeUnitInGbs int

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

NsgIds []string

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
OcpuCount float64

(Updatable) The number of OCPU cores to be made available to the database.

OpenMode string

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

OperationsInsightsStatus string

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

PeerDbIds []string

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

PermissionLevel string

The Autonomous Database permission level. Restricted mode allows access only to admin users.

PrivateEndpoint string

The private endpoint for the resource.

PrivateEndpointIp string

The private endpoint Ip address for the resource.

PrivateEndpointLabel string

(Updatable) The private endpoint label for the resource.

RefreshableMode string

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

RefreshableStatus string

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

Role string

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

RotateKeyTrigger bool

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

ScheduledOperations []AutonomousDatabaseScheduledOperationArgs

(Updatable) list of scheduled operations

ServiceConsoleUrl string

The URL of the Service Console for the Autonomous Database.

Source string

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

SourceId string

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

StandbyDbs []AutonomousDatabaseStandbyDbArgs

Autonomous Data Guard standby database details.

StandbyWhitelistedIps []string

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

State string

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

SubnetId string

(Updatable) The OCID of the subnet the resource is associated with.

SupportedRegionsToCloneTos []string

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

SwitchoverTo string

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

SwitchoverToRemotePeerId string

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

SystemTags map[string]interface{}

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

TimeCreated string

The date and time the Autonomous Database was created.

TimeDataGuardRoleChanged string

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

TimeDeletionOfFreeAutonomousDatabase string

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

TimeLocalDataGuardEnabled string

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

TimeMaintenanceBegin string

The date and time when maintenance will begin.

TimeMaintenanceEnd string

The date and time when maintenance will end.

TimeOfLastFailover string

The timestamp of the last failover operation.

TimeOfLastRefresh string

The date and time when last refresh happened.

TimeOfLastRefreshPoint string

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

TimeOfLastSwitchover string

The timestamp of the last switchover operation for the Autonomous Database.

TimeOfNextRefresh string

The date and time of next refresh.

TimeReclamationOfFreeAutonomousDatabase string

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

TimeUntilReconnectCloneEnabled string

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

Timestamp string

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

UsedDataStorageSizeInTbs int

The amount of storage that has been used, in terabytes.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

WhitelistedIps []string

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

actualUsedDataStorageSizeInTbs Double

The current amount of storage in use for user and system data, in terabytes (TB).

adminPassword String

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

allocatedStorageSizeInTbs Double

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

apexDetails List<AutonomousApexDetailArgs>

Information about Oracle APEX Application Development.

arePrimaryWhitelistedIpsUsed Boolean

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

autonomousContainerDatabaseId String

The Autonomous Container Database OCID.

autonomousDatabaseBackupId String

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

autonomousDatabaseId String

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

autonomousMaintenanceScheduleType String

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

availableUpgradeVersions List<String>

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

backupConfigs List<AutonomousBackupConfigArgs>

Autonomous Database configuration details for storing manual backups in the Object Storage service.

cloneType String

The Autonomous Database clone type.

compartmentId String

(Updatable) The OCID of the compartment of the Autonomous Database.

connectionStrings List<AutonomousConnectionStringArgs>

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

connectionUrls List<AutonomousConnectionUrlArgs>

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

cpuCoreCount Integer

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

customerContacts List<AutonomousCustomerContactArgs>

(Updatable) Customer Contacts.

dataSafeStatus String

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

dataStorageSizeInGb Integer

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

dataStorageSizeInTbs Integer

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

databaseEdition String

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

databaseManagementStatus String

Status of Database Management for this Autonomous Database.

dataguardRegionType String

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

dbName String

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

dbVersion String

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

dbWorkload String

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
definedTags Map<String,Object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName String

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

failedDataRecoveryInSeconds Integer

Indicates the number of seconds of data loss for a Data Guard failover.

freeformTags Map<String,Object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

infrastructureType String

The infrastructure type this resource belongs to.

isAccessControlEnabled Boolean

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

isAutoScalingEnabled Boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

isAutoScalingForStorageEnabled Boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

isDataGuardEnabled Boolean

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

isDedicated Boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier Boolean

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

isMtlsConnectionRequired Boolean

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

isPreview Boolean

Indicates if the Autonomous Database version is a preview version.

isPreviewVersionWithServiceTermsAccepted Boolean

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

isReconnectCloneEnabled Boolean

Indicates if the refreshable clone can be reconnected to its source database.

isRefreshableClone Boolean

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

isShrinkOnly Boolean

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

keyHistoryEntries List<AutonomousKeyHistoryEntryArgs>

Key History Entry.

keyStoreId String

The OCID of the key store.

keyStoreWalletName String

The wallet name for Oracle Key Vault.

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyLifecycleDetails String

KMS key lifecycle details.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

licenseModel String

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

lifecycleDetails String

Additional information about the current lifecycle state.

maxCpuCoreCount Integer

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

memoryPerOracleComputeUnitInGbs Integer

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

nsgIds List<String>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
ocpuCount Double

(Updatable) The number of OCPU cores to be made available to the database.

openMode String

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

operationsInsightsStatus String

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

peerDbIds List<String>

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

permissionLevel String

The Autonomous Database permission level. Restricted mode allows access only to admin users.

privateEndpoint String

The private endpoint for the resource.

privateEndpointIp String

The private endpoint Ip address for the resource.

privateEndpointLabel String

(Updatable) The private endpoint label for the resource.

refreshableMode String

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

refreshableStatus String

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

role String

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

rotateKeyTrigger Boolean

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

scheduledOperations List<AutonomousScheduledOperationArgs>

(Updatable) list of scheduled operations

serviceConsoleUrl String

The URL of the Service Console for the Autonomous Database.

source String

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

sourceId String

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

standbyDbs List<AutonomousStandbyDbArgs>

Autonomous Data Guard standby database details.

standbyWhitelistedIps List<String>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

state String

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

subnetId String

(Updatable) The OCID of the subnet the resource is associated with.

supportedRegionsToCloneTos List<String>

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

switchoverTo String

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

switchoverToRemotePeerId String

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

systemTags Map<String,Object>

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

timeCreated String

The date and time the Autonomous Database was created.

timeDataGuardRoleChanged String

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

timeDeletionOfFreeAutonomousDatabase String

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

timeLocalDataGuardEnabled String

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

timeMaintenanceBegin String

The date and time when maintenance will begin.

timeMaintenanceEnd String

The date and time when maintenance will end.

timeOfLastFailover String

The timestamp of the last failover operation.

timeOfLastRefresh String

The date and time when last refresh happened.

timeOfLastRefreshPoint String

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

timeOfLastSwitchover String

The timestamp of the last switchover operation for the Autonomous Database.

timeOfNextRefresh String

The date and time of next refresh.

timeReclamationOfFreeAutonomousDatabase String

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

timeUntilReconnectCloneEnabled String

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

timestamp String

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

usedDataStorageSizeInTbs Integer

The amount of storage that has been used, in terabytes.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps List<String>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

actualUsedDataStorageSizeInTbs number

The current amount of storage in use for user and system data, in terabytes (TB).

adminPassword string

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

allocatedStorageSizeInTbs number

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

apexDetails AutonomousDatabaseApexDetailArgs[]

Information about Oracle APEX Application Development.

arePrimaryWhitelistedIpsUsed boolean

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

autonomousContainerDatabaseId string

The Autonomous Container Database OCID.

autonomousDatabaseBackupId string

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

autonomousDatabaseId string

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

autonomousMaintenanceScheduleType string

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

availableUpgradeVersions string[]

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

backupConfigs AutonomousDatabaseBackupConfigArgs[]

Autonomous Database configuration details for storing manual backups in the Object Storage service.

cloneType string

The Autonomous Database clone type.

compartmentId string

(Updatable) The OCID of the compartment of the Autonomous Database.

connectionStrings AutonomousDatabaseConnectionStringArgs[]

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

connectionUrls AutonomousDatabaseConnectionUrlArgs[]

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

cpuCoreCount number

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

customerContacts AutonomousDatabaseCustomerContactArgs[]

(Updatable) Customer Contacts.

dataSafeStatus string

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

dataStorageSizeInGb number

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

dataStorageSizeInTbs number

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

databaseEdition string

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

databaseManagementStatus string

Status of Database Management for this Autonomous Database.

dataguardRegionType string

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

dbName string

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

dbVersion string

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

dbWorkload string

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
definedTags {[key: string]: any}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName string

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

failedDataRecoveryInSeconds number

Indicates the number of seconds of data loss for a Data Guard failover.

freeformTags {[key: string]: any}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

infrastructureType string

The infrastructure type this resource belongs to.

isAccessControlEnabled boolean

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

isAutoScalingEnabled boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

isAutoScalingForStorageEnabled boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

isDataGuardEnabled boolean

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

isDedicated boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier boolean

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

isMtlsConnectionRequired boolean

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

isPreview boolean

Indicates if the Autonomous Database version is a preview version.

isPreviewVersionWithServiceTermsAccepted boolean

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

isReconnectCloneEnabled boolean

Indicates if the refreshable clone can be reconnected to its source database.

isRefreshableClone boolean

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

isShrinkOnly boolean

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

keyHistoryEntries AutonomousDatabaseKeyHistoryEntryArgs[]

Key History Entry.

keyStoreId string

The OCID of the key store.

keyStoreWalletName string

The wallet name for Oracle Key Vault.

kmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyLifecycleDetails string

KMS key lifecycle details.

kmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

licenseModel string

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

lifecycleDetails string

Additional information about the current lifecycle state.

maxCpuCoreCount number

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

memoryPerOracleComputeUnitInGbs number

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

nsgIds string[]

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
ocpuCount number

(Updatable) The number of OCPU cores to be made available to the database.

openMode string

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

operationsInsightsStatus string

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

peerDbIds string[]

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

permissionLevel string

The Autonomous Database permission level. Restricted mode allows access only to admin users.

privateEndpoint string

The private endpoint for the resource.

privateEndpointIp string

The private endpoint Ip address for the resource.

privateEndpointLabel string

(Updatable) The private endpoint label for the resource.

refreshableMode string

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

refreshableStatus string

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

role string

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

rotateKeyTrigger boolean

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

scheduledOperations AutonomousDatabaseScheduledOperationArgs[]

(Updatable) list of scheduled operations

serviceConsoleUrl string

The URL of the Service Console for the Autonomous Database.

source string

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

sourceId string

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

standbyDbs AutonomousDatabaseStandbyDbArgs[]

Autonomous Data Guard standby database details.

standbyWhitelistedIps string[]

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

state string

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

subnetId string

(Updatable) The OCID of the subnet the resource is associated with.

supportedRegionsToCloneTos string[]

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

switchoverTo string

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

switchoverToRemotePeerId string

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

systemTags {[key: string]: any}

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

timeCreated string

The date and time the Autonomous Database was created.

timeDataGuardRoleChanged string

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

timeDeletionOfFreeAutonomousDatabase string

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

timeLocalDataGuardEnabled string

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

timeMaintenanceBegin string

The date and time when maintenance will begin.

timeMaintenanceEnd string

The date and time when maintenance will end.

timeOfLastFailover string

The timestamp of the last failover operation.

timeOfLastRefresh string

The date and time when last refresh happened.

timeOfLastRefreshPoint string

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

timeOfLastSwitchover string

The timestamp of the last switchover operation for the Autonomous Database.

timeOfNextRefresh string

The date and time of next refresh.

timeReclamationOfFreeAutonomousDatabase string

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

timeUntilReconnectCloneEnabled string

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

timestamp string

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

usedDataStorageSizeInTbs number

The amount of storage that has been used, in terabytes.

vaultId string

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps string[]

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

actual_used_data_storage_size_in_tbs float

The current amount of storage in use for user and system data, in terabytes (TB).

admin_password str

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

allocated_storage_size_in_tbs float

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

apex_details AutonomousDatabaseApexDetailArgs]

Information about Oracle APEX Application Development.

are_primary_whitelisted_ips_used bool

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

autonomous_container_database_id str

The Autonomous Container Database OCID.

autonomous_database_backup_id str

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

autonomous_database_id str

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

autonomous_maintenance_schedule_type str

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

available_upgrade_versions Sequence[str]

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

backup_configs AutonomousDatabaseBackupConfigArgs]

Autonomous Database configuration details for storing manual backups in the Object Storage service.

clone_type str

The Autonomous Database clone type.

compartment_id str

(Updatable) The OCID of the compartment of the Autonomous Database.

connection_strings AutonomousDatabaseConnectionStringArgs]

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

connection_urls AutonomousDatabaseConnectionUrlArgs]

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

cpu_core_count int

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

customer_contacts AutonomousDatabaseCustomerContactArgs]

(Updatable) Customer Contacts.

data_safe_status str

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

data_storage_size_in_gb int

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

data_storage_size_in_tbs int

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

database_edition str

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

database_management_status str

Status of Database Management for this Autonomous Database.

dataguard_region_type str

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

db_name str

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

db_version str

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

db_workload str

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
defined_tags Mapping[str, Any]

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

display_name str

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

failed_data_recovery_in_seconds int

Indicates the number of seconds of data loss for a Data Guard failover.

freeform_tags Mapping[str, Any]

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

infrastructure_type str

The infrastructure type this resource belongs to.

is_access_control_enabled bool

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

is_auto_scaling_enabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

is_auto_scaling_for_storage_enabled bool

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

is_data_guard_enabled bool

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

is_dedicated bool

True if the database is on dedicated Exadata infrastructure.

is_free_tier bool

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

is_mtls_connection_required bool

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

is_preview bool

Indicates if the Autonomous Database version is a preview version.

is_preview_version_with_service_terms_accepted bool

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

is_reconnect_clone_enabled bool

Indicates if the refreshable clone can be reconnected to its source database.

is_refreshable_clone bool

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

is_shrink_only bool

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

key_history_entries AutonomousDatabaseKeyHistoryEntryArgs]

Key History Entry.

key_store_id str

The OCID of the key store.

key_store_wallet_name str

The wallet name for Oracle Key Vault.

kms_key_id str

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kms_key_lifecycle_details str

KMS key lifecycle details.

kms_key_version_id str

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

license_model str

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

lifecycle_details str

Additional information about the current lifecycle state.

max_cpu_core_count int

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

memory_per_oracle_compute_unit_in_gbs int

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

nsg_ids Sequence[str]

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
ocpu_count float

(Updatable) The number of OCPU cores to be made available to the database.

open_mode str

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

operations_insights_status str

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

peer_db_ids Sequence[str]

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

permission_level str

The Autonomous Database permission level. Restricted mode allows access only to admin users.

private_endpoint str

The private endpoint for the resource.

private_endpoint_ip str

The private endpoint Ip address for the resource.

private_endpoint_label str

(Updatable) The private endpoint label for the resource.

refreshable_mode str

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

refreshable_status str

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

role str

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

rotate_key_trigger bool

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

scheduled_operations AutonomousDatabaseScheduledOperationArgs]

(Updatable) list of scheduled operations

service_console_url str

The URL of the Service Console for the Autonomous Database.

source str

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

source_id str

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

standby_dbs AutonomousDatabaseStandbyDbArgs]

Autonomous Data Guard standby database details.

standby_whitelisted_ips Sequence[str]

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

state str

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

subnet_id str

(Updatable) The OCID of the subnet the resource is associated with.

supported_regions_to_clone_tos Sequence[str]

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

switchover_to str

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

switchover_to_remote_peer_id str

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

system_tags Mapping[str, Any]

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

time_created str

The date and time the Autonomous Database was created.

time_data_guard_role_changed str

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

time_deletion_of_free_autonomous_database str

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

time_local_data_guard_enabled str

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

time_maintenance_begin str

The date and time when maintenance will begin.

time_maintenance_end str

The date and time when maintenance will end.

time_of_last_failover str

The timestamp of the last failover operation.

time_of_last_refresh str

The date and time when last refresh happened.

time_of_last_refresh_point str

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

time_of_last_switchover str

The timestamp of the last switchover operation for the Autonomous Database.

time_of_next_refresh str

The date and time of next refresh.

time_reclamation_of_free_autonomous_database str

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

time_until_reconnect_clone_enabled str

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

timestamp str

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

used_data_storage_size_in_tbs int

The amount of storage that has been used, in terabytes.

vault_id str

The OCID of the Oracle Cloud Infrastructure vault.

whitelisted_ips Sequence[str]

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

actualUsedDataStorageSizeInTbs Number

The current amount of storage in use for user and system data, in terabytes (TB).

adminPassword String

(Updatable) The password must be between 12 and 30 characters long, and must contain at least 1 uppercase, 1 lowercase, and 1 numeric character. It cannot contain the double quote symbol (") or the username "admin", regardless of casing. The password is mandatory if source value is "BACKUP_FROM_ID", "BACKUP_FROM_TIMESTAMP", "DATABASE" or "NONE".

allocatedStorageSizeInTbs Number

The amount of storage currently allocated for the database tables and billed for, rounded up. When auto-scaling is not enabled, this value is equal to the dataStorageSizeInTBs value. You can compare this value to the actualUsedDataStorageSizeInTBs value to determine if a manual shrink operation is appropriate for your allocated storage.

apexDetails List<Property Map>

Information about Oracle APEX Application Development.

arePrimaryWhitelistedIpsUsed Boolean

(Updatable) This field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled. It's value would be TRUE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses primary IP access control list (ACL) for standby. It's value would be FALSE if Autonomous Database is Data Guard enabled and Access Control is enabled and if the Autonomous Database uses different IP access control list (ACL) for standby compared to primary.

autonomousContainerDatabaseId String

The Autonomous Container Database OCID.

autonomousDatabaseBackupId String

The OCID of the source Autonomous Database Backup that you will clone to create a new Autonomous Database.

autonomousDatabaseId String

The OCID of the source Autonomous Database that you will clone to create a new Autonomous Database.

autonomousMaintenanceScheduleType String

The maintenance schedule type of the Autonomous Database on shared Exadata infrastructure. The EARLY maintenance schedule of this Autonomous Database follows a schedule that applies patches prior to the REGULAR schedule.The REGULAR maintenance schedule of this Autonomous Database follows the normal cycle.

availableUpgradeVersions List<String>

List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.

backupConfigs List<Property Map>

Autonomous Database configuration details for storing manual backups in the Object Storage service.

cloneType String

The Autonomous Database clone type.

compartmentId String

(Updatable) The OCID of the compartment of the Autonomous Database.

connectionStrings List<Property Map>

The connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.

connectionUrls List<Property Map>

The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure. Example: {"sqlDevWebUrl": "https://<hostname>/ords...", "apexUrl", "https://<hostname>/ords..."}

cpuCoreCount Number

(Updatable) The number of OCPU cores to be made available to the database. For Autonomous Databases on dedicated Exadata infrastructure, the maximum number of cores is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

customerContacts List<Property Map>

(Updatable) Customer Contacts.

dataSafeStatus String

(Updatable) Status of the Data Safe registration for this Autonomous Database. Could be REGISTERED or NOT_REGISTERED.

dataStorageSizeInGb Number

(Updatable) The size, in gigabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. The maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

dataStorageSizeInTbs Number

(Updatable) The size, in terabytes, of the data volume that will be created and attached to the database. This storage can later be scaled up if needed. For Autonomous Databases on dedicated Exadata infrastructure, the maximum storage value is determined by the infrastructure shape. See Characteristics of Infrastructure Shapes for shape details.

databaseEdition String

(Updatable) The Oracle Database Edition that applies to the Autonomous databases.

databaseManagementStatus String

Status of Database Management for this Autonomous Database.

dataguardRegionType String

The Autonomous Data Guard region type of the Autonomous Database. For Autonomous Databases on shared Exadata infrastructure, Data Guard associations have designated primary and standby regions, and these region types do not change when the database changes roles. The standby regions in Data Guard associations can be the same region designated as the primary region, or they can be remote regions. Certain database administrative operations may be available only in the primary region of the Data Guard association, and cannot be performed when the database using the "primary" role is operating in a remote Data Guard standby region.

dbName String

The database name. The name must begin with an alphabetic character and can contain a maximum of 14 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

dbVersion String

(Updatable) A valid Oracle Database version for Autonomous Database.db_workload AJD and APEX are only supported for db_version 19c and above.

dbWorkload String

(Updatable) The Autonomous Database workload type. The following values are valid:

  • OLTP - indicates an Autonomous Transaction Processing database
  • DW - indicates an Autonomous Data Warehouse database
  • AJD - indicates an Autonomous JSON Database
  • APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type. *Note: db_workload can only be updated from AJD to OLTP or from a free OLTP to AJD.
definedTags Map<Any>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName String

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

failedDataRecoveryInSeconds Number

Indicates the number of seconds of data loss for a Data Guard failover.

freeformTags Map<Any>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

infrastructureType String

The infrastructure type this resource belongs to.

isAccessControlEnabled Boolean

(Updatable) Indicates if the database-level access control is enabled. If disabled, database access is defined by the network security rules. If enabled, database access is restricted to the IP addresses defined by the rules specified with the whitelistedIps property. While specifying whitelistedIps rules is optional, if database-level access control is enabled and no rules are specified, the database will become inaccessible. The rules can be added later using the UpdateAutonomousDatabase API operation or edit option in console. When creating a database clone, the desired access control setting should be specified. By default, database-level access control will be disabled for the clone.

isAutoScalingEnabled Boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database OCPU core count. The default value is FALSE.

isAutoScalingForStorageEnabled Boolean

(Updatable) Indicates if auto scaling is enabled for the Autonomous Database storage. The default value is FALSE.

isDataGuardEnabled Boolean

(Updatable) Indicates whether the Autonomous Database has local (in-region) Data Guard enabled. Not applicable to cross-region Autonomous Data Guard associations, or to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

isDedicated Boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier Boolean

(Updatable) Indicates if this is an Always Free resource. The default value is false. Note that Always Free Autonomous Databases have 1 CPU and 20GB of memory. For Always Free databases, memory and CPU cannot be scaled. When db_workload is AJD or APEX it cannot be true.

isMtlsConnectionRequired Boolean

(Updatable) Indicates whether the Autonomous Database requires mTLS connections.

isPreview Boolean

Indicates if the Autonomous Database version is a preview version.

isPreviewVersionWithServiceTermsAccepted Boolean

If set to TRUE, indicates that an Autonomous Database preview version is being provisioned, and that the preview version's terms of service have been accepted. Note that preview version software is only available for databases on shared Exadata infrastructure.

isReconnectCloneEnabled Boolean

Indicates if the refreshable clone can be reconnected to its source database.

isRefreshableClone Boolean

(Updatable) True for creating a refreshable clone and False for detaching the clone from source Autonomous Database. Detaching is one time operation and clone becomes a regular Autonomous Database.

isShrinkOnly Boolean

(Updatable) An optional property when enabled triggers the Shrinking of Autonomous Database once. To trigger Shrinking of ADB once again, this flag needs to be disabled and re-enabled again. It should not be passed during create database operation. It is only applicable on shared databases i.e. where is_dedicated is false.

keyHistoryEntries List<Property Map>

Key History Entry.

keyStoreId String

The OCID of the key store.

keyStoreWalletName String

The wallet name for Oracle Key Vault.

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyLifecycleDetails String

KMS key lifecycle details.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

licenseModel String

(Updatable) The Oracle license model that applies to the Oracle Autonomous Database. Bring your own license (BYOL) allows you to apply your current on-premises Oracle software licenses to equivalent, highly automated Oracle PaaS and IaaS services in the cloud. License Included allows you to subscribe to new Oracle Database software licenses and the Database service. Note that when provisioning an Autonomous Database on dedicated Exadata infrastructure, this attribute must be null because the attribute is already set at the Autonomous Exadata Infrastructure level. When using shared Exadata infrastructure, if a value is not specified, the system will supply the value of BRING_YOUR_OWN_LICENSE. It is a required field when db_workload is AJD and needs to be set to LICENSE_INCLUDED as AJD does not support default license_model value BRING_YOUR_OWN_LICENSE.

lifecycleDetails String

Additional information about the current lifecycle state.

maxCpuCoreCount Number

(Updatable) The number of Max OCPU cores to be made available to the autonomous database with auto scaling of cpu enabled.

memoryPerOracleComputeUnitInGbs Number

The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.

nsgIds List<String>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that this resource belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • Autonomous Databases with private access require at least 1 Network Security Group (NSG). The nsgIds array cannot be empty.
ocpuCount Number

(Updatable) The number of OCPU cores to be made available to the database.

openMode String

The DATABASE OPEN mode. You can open the database in READ_ONLY or READ_WRITE mode.

operationsInsightsStatus String

(Updatable) Status of Operations Insights for this Autonomous Database. Values supported are ENABLED and NOT_ENABLED

peerDbIds List<String>

The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for shared Exadata infrastructure, standby databases located in the same region as the source primary database do not have OCIDs.

permissionLevel String

The Autonomous Database permission level. Restricted mode allows access only to admin users.

privateEndpoint String

The private endpoint for the resource.

privateEndpointIp String

The private endpoint Ip address for the resource.

privateEndpointLabel String

(Updatable) The private endpoint label for the resource.

refreshableMode String

(Updatable) The refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.

refreshableStatus String

The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.

role String

The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.

rotateKeyTrigger Boolean

(Updatable) An optional property when flipped triggers rotation of KMS key. It is only applicable on dedicated databases i.e. where is_dedicated is true.

scheduledOperations List<Property Map>

(Updatable) list of scheduled operations

serviceConsoleUrl String

The URL of the Service Console for the Autonomous Database.

source String

The source of the database: Use NONE for creating a new Autonomous Database. Use DATABASE for creating a new Autonomous Database by cloning an existing Autonomous Database. Use CROSS_REGION_DATAGUARD to create a standby Data Guard database in another region.

sourceId String

The OCID of the source Autonomous Database that will be used to create a new standby database for the Data Guard association.

standbyDbs List<Property Map>

Autonomous Data Guard standby database details.

standbyWhitelistedIps List<String>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

state String

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

subnetId String

(Updatable) The OCID of the subnet the resource is associated with.

supportedRegionsToCloneTos List<String>

The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.

switchoverTo String

It is applicable only when is_data_guard_enabled is true. Could be set to PRIMARY or STANDBY. Default value is PRIMARY.

switchoverToRemotePeerId String

(Updatable) It is applicable only when dataguard_region_type and role are set, and is_dedicated is false. It takes the OCID of the remote peer to switchover to.

systemTags Map<Any>

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

timeCreated String

The date and time the Autonomous Database was created.

timeDataGuardRoleChanged String

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

timeDeletionOfFreeAutonomousDatabase String

The date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.

timeLocalDataGuardEnabled String

The date and time that Autonomous Data Guard was enabled for an Autonomous Database where the standby was provisioned in the same region as the primary database.

timeMaintenanceBegin String

The date and time when maintenance will begin.

timeMaintenanceEnd String

The date and time when maintenance will end.

timeOfLastFailover String

The timestamp of the last failover operation.

timeOfLastRefresh String

The date and time when last refresh happened.

timeOfLastRefreshPoint String

The refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.

timeOfLastSwitchover String

The timestamp of the last switchover operation for the Autonomous Database.

timeOfNextRefresh String

The date and time of next refresh.

timeReclamationOfFreeAutonomousDatabase String

The date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.

timeUntilReconnectCloneEnabled String

The time and date as an RFC3339 formatted string, e.g., 2022-01-01T12:00:00.000Z, to set the limit for a refreshable clone to be reconnected to its source database.

timestamp String

The timestamp specified for the point-in-time clone of the source Autonomous Database. The timestamp must be in the past.

usedDataStorageSizeInTbs Number

The amount of storage that has been used, in terabytes.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps List<String>

(Updatable) The client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance.

Supporting Types

AutonomousDatabaseApexDetail

ApexVersion string

The Oracle APEX Application Development version.

OrdsVersion string

The Oracle REST Data Services (ORDS) version.

ApexVersion string

The Oracle APEX Application Development version.

OrdsVersion string

The Oracle REST Data Services (ORDS) version.

apexVersion String

The Oracle APEX Application Development version.

ordsVersion String

The Oracle REST Data Services (ORDS) version.

apexVersion string

The Oracle APEX Application Development version.

ordsVersion string

The Oracle REST Data Services (ORDS) version.

apex_version str

The Oracle APEX Application Development version.

ords_version str

The Oracle REST Data Services (ORDS) version.

apexVersion String

The Oracle APEX Application Development version.

ordsVersion String

The Oracle REST Data Services (ORDS) version.

AutonomousDatabaseBackupConfig

ManualBackupBucketName string

Name of Object Storage bucket to use for storing manual backups.

ManualBackupType string

The manual backup destination type.

ManualBackupBucketName string

Name of Object Storage bucket to use for storing manual backups.

ManualBackupType string

The manual backup destination type.

manualBackupBucketName String

Name of Object Storage bucket to use for storing manual backups.

manualBackupType String

The manual backup destination type.

manualBackupBucketName string

Name of Object Storage bucket to use for storing manual backups.

manualBackupType string

The manual backup destination type.

manual_backup_bucket_name str

Name of Object Storage bucket to use for storing manual backups.

manual_backup_type str

The manual backup destination type.

manualBackupBucketName String

Name of Object Storage bucket to use for storing manual backups.

manualBackupType String

The manual backup destination type.

AutonomousDatabaseConnectionString

AllConnectionStrings Dictionary<string, object>

Returns all connection strings that can be used to connect to the Autonomous Database. For more information, please see Predefined Database Service Names for Autonomous Transaction Processing

Dedicated string

The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

High string

The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements.

Low string

The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

Medium string

The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements.

Profiles List<AutonomousDatabaseConnectionStringProfile>

A list of connection string profiles to allow clients to group, filter and select connection string values based on structured metadata.

AllConnectionStrings map[string]interface{}

Returns all connection strings that can be used to connect to the Autonomous Database. For more information, please see Predefined Database Service Names for Autonomous Transaction Processing

Dedicated string

The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

High string

The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements.

Low string

The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

Medium string

The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements.

Profiles []AutonomousDatabaseConnectionStringProfile

A list of connection string profiles to allow clients to group, filter and select connection string values based on structured metadata.

allConnectionStrings Map<String,Object>

Returns all connection strings that can be used to connect to the Autonomous Database. For more information, please see Predefined Database Service Names for Autonomous Transaction Processing

dedicated String

The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

high String

The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements.

low String

The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

medium String

The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements.

profiles List<AutonomousConnectionStringProfile>

A list of connection string profiles to allow clients to group, filter and select connection string values based on structured metadata.

allConnectionStrings {[key: string]: any}

Returns all connection strings that can be used to connect to the Autonomous Database. For more information, please see Predefined Database Service Names for Autonomous Transaction Processing

dedicated string

The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

high string

The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements.

low string

The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

medium string

The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements.

profiles AutonomousDatabaseConnectionStringProfile[]

A list of connection string profiles to allow clients to group, filter and select connection string values based on structured metadata.

all_connection_strings Mapping[str, Any]

Returns all connection strings that can be used to connect to the Autonomous Database. For more information, please see Predefined Database Service Names for Autonomous Transaction Processing

dedicated str

The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

high str

The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements.

low str

The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

medium str

The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements.

profiles AutonomousDatabaseConnectionStringProfile]

A list of connection string profiles to allow clients to group, filter and select connection string values based on structured metadata.

allConnectionStrings Map<Any>

Returns all connection strings that can be used to connect to the Autonomous Database. For more information, please see Predefined Database Service Names for Autonomous Transaction Processing

dedicated String

The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

high String

The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements.

low String

The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.

medium String

The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements.

profiles List<Property Map>

A list of connection string profiles to allow clients to group, filter and select connection string values based on structured metadata.

AutonomousDatabaseConnectionStringProfile

ConsumerGroup string

Consumer group used by the connection.

DisplayName string

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

HostFormat string

Host format used in connection string.

Protocol string

Protocol used by the connection.

SessionMode string

Specifies whether the listener performs a direct hand-off of the session, or redirects the session. In RAC deployments where SCAN is used, sessions are redirected to a Node VIP. Use DIRECT for direct hand-offs. Use REDIRECT to redirect the session.

SyntaxFormat string

Specifies whether the connection string is using the long (LONG), Easy Connect (EZCONNECT), or Easy Connect Plus (EZCONNECTPLUS) format. Autonomous Databases on shared Exadata infrastructure always use the long format.

TlsAuthentication string

Specifies whether the TLS handshake is using one-way (SERVER) or mutual (MUTUAL) authentication.

Value string

Connection string value.

ConsumerGroup string

Consumer group used by the connection.

DisplayName string

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

HostFormat string

Host format used in connection string.

Protocol string

Protocol used by the connection.

SessionMode string

Specifies whether the listener performs a direct hand-off of the session, or redirects the session. In RAC deployments where SCAN is used, sessions are redirected to a Node VIP. Use DIRECT for direct hand-offs. Use REDIRECT to redirect the session.

SyntaxFormat string

Specifies whether the connection string is using the long (LONG), Easy Connect (EZCONNECT), or Easy Connect Plus (EZCONNECTPLUS) format. Autonomous Databases on shared Exadata infrastructure always use the long format.

TlsAuthentication string

Specifies whether the TLS handshake is using one-way (SERVER) or mutual (MUTUAL) authentication.

Value string

Connection string value.

consumerGroup String

Consumer group used by the connection.

displayName String

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

hostFormat String

Host format used in connection string.

protocol String

Protocol used by the connection.

sessionMode String

Specifies whether the listener performs a direct hand-off of the session, or redirects the session. In RAC deployments where SCAN is used, sessions are redirected to a Node VIP. Use DIRECT for direct hand-offs. Use REDIRECT to redirect the session.

syntaxFormat String

Specifies whether the connection string is using the long (LONG), Easy Connect (EZCONNECT), or Easy Connect Plus (EZCONNECTPLUS) format. Autonomous Databases on shared Exadata infrastructure always use the long format.

tlsAuthentication String

Specifies whether the TLS handshake is using one-way (SERVER) or mutual (MUTUAL) authentication.

value String

Connection string value.

consumerGroup string

Consumer group used by the connection.

displayName string

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

hostFormat string

Host format used in connection string.

protocol string

Protocol used by the connection.

sessionMode string

Specifies whether the listener performs a direct hand-off of the session, or redirects the session. In RAC deployments where SCAN is used, sessions are redirected to a Node VIP. Use DIRECT for direct hand-offs. Use REDIRECT to redirect the session.

syntaxFormat string

Specifies whether the connection string is using the long (LONG), Easy Connect (EZCONNECT), or Easy Connect Plus (EZCONNECTPLUS) format. Autonomous Databases on shared Exadata infrastructure always use the long format.

tlsAuthentication string

Specifies whether the TLS handshake is using one-way (SERVER) or mutual (MUTUAL) authentication.

value string

Connection string value.

consumer_group str

Consumer group used by the connection.

display_name str

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

host_format str

Host format used in connection string.

protocol str

Protocol used by the connection.

session_mode str

Specifies whether the listener performs a direct hand-off of the session, or redirects the session. In RAC deployments where SCAN is used, sessions are redirected to a Node VIP. Use DIRECT for direct hand-offs. Use REDIRECT to redirect the session.

syntax_format str

Specifies whether the connection string is using the long (LONG), Easy Connect (EZCONNECT), or Easy Connect Plus (EZCONNECTPLUS) format. Autonomous Databases on shared Exadata infrastructure always use the long format.

tls_authentication str

Specifies whether the TLS handshake is using one-way (SERVER) or mutual (MUTUAL) authentication.

value str

Connection string value.

consumerGroup String

Consumer group used by the connection.

displayName String

(Updatable) The user-friendly name for the Autonomous Database. The name does not have to be unique.

hostFormat String

Host format used in connection string.

protocol String

Protocol used by the connection.

sessionMode String

Specifies whether the listener performs a direct hand-off of the session, or redirects the session. In RAC deployments where SCAN is used, sessions are redirected to a Node VIP. Use DIRECT for direct hand-offs. Use REDIRECT to redirect the session.

syntaxFormat String

Specifies whether the connection string is using the long (LONG), Easy Connect (EZCONNECT), or Easy Connect Plus (EZCONNECTPLUS) format. Autonomous Databases on shared Exadata infrastructure always use the long format.

tlsAuthentication String

Specifies whether the TLS handshake is using one-way (SERVER) or mutual (MUTUAL) authentication.

value String

Connection string value.

AutonomousDatabaseConnectionUrl

ApexUrl string

Oracle Application Express (APEX) URL.

GraphStudioUrl string

The URL of the Graph Studio for the Autonomous Database.

MachineLearningUserManagementUrl string

Oracle Machine Learning user management URL.

SqlDevWebUrl string

Oracle SQL Developer Web URL.

ApexUrl string

Oracle Application Express (APEX) URL.

GraphStudioUrl string

The URL of the Graph Studio for the Autonomous Database.

MachineLearningUserManagementUrl string

Oracle Machine Learning user management URL.

SqlDevWebUrl string

Oracle SQL Developer Web URL.

apexUrl String

Oracle Application Express (APEX) URL.

graphStudioUrl String

The URL of the Graph Studio for the Autonomous Database.

machineLearningUserManagementUrl String

Oracle Machine Learning user management URL.

sqlDevWebUrl String

Oracle SQL Developer Web URL.

apexUrl string

Oracle Application Express (APEX) URL.

graphStudioUrl string

The URL of the Graph Studio for the Autonomous Database.

machineLearningUserManagementUrl string

Oracle Machine Learning user management URL.

sqlDevWebUrl string

Oracle SQL Developer Web URL.

apex_url str

Oracle Application Express (APEX) URL.

graph_studio_url str

The URL of the Graph Studio for the Autonomous Database.

machine_learning_user_management_url str

Oracle Machine Learning user management URL.

sql_dev_web_url str

Oracle SQL Developer Web URL.

apexUrl String

Oracle Application Express (APEX) URL.

graphStudioUrl String

The URL of the Graph Studio for the Autonomous Database.

machineLearningUserManagementUrl String

Oracle Machine Learning user management URL.

sqlDevWebUrl String

Oracle SQL Developer Web URL.

AutonomousDatabaseCustomerContact

Email string

(Updatable) The email address used by Oracle to send notifications regarding databases and infrastructure.

Email string

(Updatable) The email address used by Oracle to send notifications regarding databases and infrastructure.

email String

(Updatable) The email address used by Oracle to send notifications regarding databases and infrastructure.

email string

(Updatable) The email address used by Oracle to send notifications regarding databases and infrastructure.

email str

(Updatable) The email address used by Oracle to send notifications regarding databases and infrastructure.

email String

(Updatable) The email address used by Oracle to send notifications regarding databases and infrastructure.

AutonomousDatabaseKeyHistoryEntry

Id string

The id of the Autonomous Database Vault service key management history entry.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

TimeActivated string

The date and time the kms key activated.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

Id string

The id of the Autonomous Database Vault service key management history entry.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

TimeActivated string

The date and time the kms key activated.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

id String

The id of the Autonomous Database Vault service key management history entry.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

timeActivated String

The date and time the kms key activated.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

id string

The id of the Autonomous Database Vault service key management history entry.

kmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

timeActivated string

The date and time the kms key activated.

vaultId string

The OCID of the Oracle Cloud Infrastructure vault.

id str

The id of the Autonomous Database Vault service key management history entry.

kms_key_version_id str

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

time_activated str

The date and time the kms key activated.

vault_id str

The OCID of the Oracle Cloud Infrastructure vault.

id String

The id of the Autonomous Database Vault service key management history entry.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

timeActivated String

The date and time the kms key activated.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

AutonomousDatabaseScheduledOperation

DayOfWeek AutonomousDatabaseScheduledOperationDayOfWeek

(Updatable) Day of the week.

ScheduledStartTime string

(Updatable) auto start time. value must be of ISO-8601 format "HH:mm"

ScheduledStopTime string

(Updatable) auto stop time. value must be of ISO-8601 format "HH:mm"

DayOfWeek AutonomousDatabaseScheduledOperationDayOfWeek

(Updatable) Day of the week.

ScheduledStartTime string

(Updatable) auto start time. value must be of ISO-8601 format "HH:mm"

ScheduledStopTime string

(Updatable) auto stop time. value must be of ISO-8601 format "HH:mm"

dayOfWeek AutonomousScheduledOperationDayOfWeek

(Updatable) Day of the week.

scheduledStartTime String

(Updatable) auto start time. value must be of ISO-8601 format "HH:mm"

scheduledStopTime String

(Updatable) auto stop time. value must be of ISO-8601 format "HH:mm"

dayOfWeek AutonomousDatabaseScheduledOperationDayOfWeek

(Updatable) Day of the week.

scheduledStartTime string

(Updatable) auto start time. value must be of ISO-8601 format "HH:mm"

scheduledStopTime string

(Updatable) auto stop time. value must be of ISO-8601 format "HH:mm"

day_of_week AutonomousDatabaseScheduledOperationDayOfWeek

(Updatable) Day of the week.

scheduled_start_time str

(Updatable) auto start time. value must be of ISO-8601 format "HH:mm"

scheduled_stop_time str

(Updatable) auto stop time. value must be of ISO-8601 format "HH:mm"

dayOfWeek Property Map

(Updatable) Day of the week.

scheduledStartTime String

(Updatable) auto start time. value must be of ISO-8601 format "HH:mm"

scheduledStopTime String

(Updatable) auto stop time. value must be of ISO-8601 format "HH:mm"

AutonomousDatabaseScheduledOperationDayOfWeek

Name string

(Updatable) Name of the day of the week.

Name string

(Updatable) Name of the day of the week.

name String

(Updatable) Name of the day of the week.

name string

(Updatable) Name of the day of the week.

name str

(Updatable) Name of the day of the week.

name String

(Updatable) Name of the day of the week.

AutonomousDatabaseStandbyDb

LagTimeInSeconds int

The amount of time, in seconds, that the data of the standby database lags the data of the primary database. Can be used to determine the potential data loss in the event of a failover.

LifecycleDetails string

Additional information about the current lifecycle state.

State string

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

TimeDataGuardRoleChanged string

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

LagTimeInSeconds int

The amount of time, in seconds, that the data of the standby database lags the data of the primary database. Can be used to determine the potential data loss in the event of a failover.

LifecycleDetails string

Additional information about the current lifecycle state.

State string

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

TimeDataGuardRoleChanged string

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

lagTimeInSeconds Integer

The amount of time, in seconds, that the data of the standby database lags the data of the primary database. Can be used to determine the potential data loss in the event of a failover.

lifecycleDetails String

Additional information about the current lifecycle state.

state String

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

timeDataGuardRoleChanged String

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

lagTimeInSeconds number

The amount of time, in seconds, that the data of the standby database lags the data of the primary database. Can be used to determine the potential data loss in the event of a failover.

lifecycleDetails string

Additional information about the current lifecycle state.

state string

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

timeDataGuardRoleChanged string

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

lag_time_in_seconds int

The amount of time, in seconds, that the data of the standby database lags the data of the primary database. Can be used to determine the potential data loss in the event of a failover.

lifecycle_details str

Additional information about the current lifecycle state.

state str

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

time_data_guard_role_changed str

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

lagTimeInSeconds Number

The amount of time, in seconds, that the data of the standby database lags the data of the primary database. Can be used to determine the potential data loss in the event of a failover.

lifecycleDetails String

Additional information about the current lifecycle state.

state String

(Updatable) The current state of the Autonomous Database. Could be set to AVAILABLE or STOPPED

timeDataGuardRoleChanged String

The date and time the Autonomous Data Guard role was switched for the Autonomous Database. For databases that have standbys in both the primary Data Guard region and a remote Data Guard standby region, this is the latest timestamp of either the database using the "primary" role in the primary Data Guard region, or database located in the remote Data Guard standby region.

Import

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

 $ pulumi import oci:Database/autonomousDatabase:AutonomousDatabase test_autonomous_database "id"

Package Details

Repository
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.