Oracle Cloud Infrastructure v0.20.1, Jun 6 23

Oracle Cloud Infrastructure v0.20.1 published on Tuesday, Jun 6, 2023 by Pulumi

oci.Database.AutonomousDatabase

Explore with Pulumi AI

Oracle Cloud Infrastructure v0.20.1 published on Tuesday, Jun 6, 2023 by Pulumi

Create 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,
                       character_set: Optional[str] = None,
                       clone_type: Optional[str] = None,
                       compartment_id: Optional[str] = None,
                       compute_count: Optional[float] = None,
                       compute_model: 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_local_data_guard_enabled: 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,
                       ncharacter_set: Optional[str] = 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_ip: Optional[str] = None,
                       private_endpoint_label: Optional[str] = None,
                       refreshable_mode: Optional[str] = None,
                       remote_disaster_recovery_type: Optional[str] = None,
                       rotate_key_trigger: Optional[bool] = None,
                       scheduled_operations: Optional[Sequence[_database.AutonomousDatabaseScheduledOperationArgs]] = None,
                       secret_id: Optional[str] = None,
                       secret_version_number: Optional[int] = 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,
                       use_latest_available_backup_time_stamp: Optional[bool] = 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

(Updatable) 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.

CharacterSet string

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

AL32UTF8, AR8ADOS710, AR8ADOS720, AR8APTEC715, AR8ARABICMACS, AR8ASMO8X, AR8ISO8859P6, AR8MSWIN1256, AR8MUSSAD768, AR8NAFITHA711, AR8NAFITHA721, AR8SAKHR706, AR8SAKHR707, AZ8ISO8859P9E, BG8MSWIN, BG8PC437S, BLT8CP921, BLT8ISO8859P13, BLT8MSWIN1257, BLT8PC775, BN8BSCII, CDN8PC863, CEL8ISO8859P14, CL8ISO8859P5, CL8ISOIR111, CL8KOI8R, CL8KOI8U, CL8MACCYRILLICS, CL8MSWIN1251, EE8ISO8859P2, EE8MACCES, EE8MACCROATIANS, EE8MSWIN1250, EE8PC852, EL8DEC, EL8ISO8859P7, EL8MACGREEKS, EL8MSWIN1253, EL8PC437S, EL8PC851, EL8PC869, ET8MSWIN923, HU8ABMOD, HU8CWI2, IN8ISCII, IS8PC861, IW8ISO8859P8, IW8MACHEBREWS, IW8MSWIN1255, IW8PC1507, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, JA16VMS, KO16KSC5601, KO16KSCCS, KO16MSWIN949, LA8ISO6937, LA8PASSPORT, LT8MSWIN921, LT8PC772, LT8PC774, LV8PC1117, LV8PC8LR, LV8RST104090, N8PC865, NE8ISO8859P10, NEE8ISO8859P4, RU8BESTA, RU8PC855, RU8PC866, SE8ISO8859P3, TH8MACTHAIS, TH8TISASCII, TR8DEC, TR8MACTURKISHS, TR8MSWIN1254, TR8PC857, US7ASCII, US8PC437, UTF8, VN8MSWIN1258, VN8VN3, WE8DEC, WE8DG, WE8ISO8859P1, WE8ISO8859P15, WE8ISO8859P9, WE8MACROMAN8S, WE8MSWIN1252, WE8NCR4970, WE8NEXTSTEP, WE8PC850, WE8PC858, WE8PC860, WE8ROMAN8, ZHS16CGB231280, ZHS16GBK, ZHT16BIG5, ZHT16CCDC, ZHT16DBT, ZHT16HKSCS, ZHT16MSWIN950, ZHT32EUC, ZHT32SOPS, ZHT32TRIS

CloneType string

The Autonomous Database clone type.

ComputeCount double

(Updatable) The compute amount available to the database. Minimum and maximum values depend on the compute model and whether the database is on Shared or Dedicated infrastructure. For an Autonomous Database on Shared infrastructure, the 'ECPU' compute model requires values in multiples of two. Required when using the computeModel parameter. When using cpuCoreCount parameter, it is an error to specify computeCount to a non-null value.

ComputeModel string

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

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. Note: This parameter cannot be used with the ocpuCount parameter.

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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.

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

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.

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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.

This cannot be updated in parallel with any of the following: licenseModel, dbEdition, cpuCoreCount, computeCount, computeModel, adminPassword, whitelistedIps, isMTLSConnectionRequired, privateEndpointLabel, nsgIds, dbVersion, isRefreshable, dbName, scheduledOperations, dbToolsDetails, isLocalDataGuardEnabled, or isFreeTier. *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.

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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) Deprecated. 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.

IsLocalDataGuardEnabled 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.

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.

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

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.

NcharacterSet string

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

NsgIds List<string>

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

OcpuCount double

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

OpenMode string

Indicates the Autonomous Database mode. The database can be opened 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 by admin users.

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.

RemoteDisasterRecoveryType string

Indicates the cross-region disaster recovery (DR) type of the standby Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.

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) The list of scheduled operations.

This cannot be updated in parallel with any of the following: licenseModel, dbEdition, cpuCoreCount, computeCount, computeModel, whitelistedIps, isMTLSConnectionRequired, openMode, permissionLevel, dbWorkload, privateEndpointLabel, nsgIds, dbVersion, isRefreshable, dbName, dbToolsDetails, isLocalDataGuardEnabled, or isFreeTier.

SecretId string

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

SecretVersionNumber int

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

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.

For Autonomous Databases on shared Exadata infrastructure, the following cloning options are available: Use BACKUP_FROM_ID for creating a new Autonomous Database from a specified backup. Use BACKUP_FROM_TIMESTAMP for creating a point-in-time Autonomous Database clone using backups. For more information, see Cloning and Moving an Autonomous Database.

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.

For shared Exadata infrastructure, this is an array of CIDR (Classless Inter-Domain Routing) notations for a subnet or VCN OCID. Use a semicolon (;) as a deliminator between the VCN-specific subnets or IPs. Example: ["1.1.1.1","1.1.1.0/24","ocid1.vcn.oc1.sea.<unique_id>","ocid1.vcn.oc1.sea.<unique_id1>;1.1.1.1","ocid1.vcn.oc1.sea.<unique_id2>;1.1.0.0/16"] For Exadata Cloud@Customer, this is an array of IP addresses or CIDR (Classless Inter-Domain Routing) notations. Example: ["1.1.1.1","1.1.1.0/24","1.1.2.25"]

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the database.

These subnets are used by the Oracle Clusterware private interconnect on the database instance. Specifying an overlapping subnet will cause the private interconnect to malfunction. This restriction applies to both the client subnet and the backup subnet.

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.

UseLatestAvailableBackupTimeStamp bool

Clone from latest available backup timestamp.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

WhitelistedIps List<string>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

This cannot be updated in parallel with any of the following: licenseModel, dbEdition, cpuCoreCount, computeCount, computeModel, adminPassword, isMTLSConnectionRequired, openMode, permissionLevel, dbWorkload, dbVersion, isRefreshable, dbName, scheduledOperations, dbToolsDetails, isLocalDataGuardEnabled, or isFreeTier. To remove all whitelisted IPs, set the field to a list with an empty string [""].

CompartmentId string

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

DbName string

AdminPassword string

ArePrimaryWhitelistedIpsUsed bool

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

CharacterSet string

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

CloneType string

The Autonomous Database clone type.

ComputeCount float64

ComputeModel string

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

CpuCoreCount int

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

DataStorageSizeInTbs int

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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.

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{}

IsAccessControlEnabled bool

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

IsDedicated bool

True if the database is on dedicated Exadata infrastructure.

IsFreeTier bool

IsLocalDataGuardEnabled bool

IsMtlsConnectionRequired bool

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

IsPreviewVersionWithServiceTermsAccepted bool

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

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

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

MaxCpuCoreCount int

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

NcharacterSet string

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

NsgIds []string

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

OcpuCount float64

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

OpenMode string

Indicates the Autonomous Database mode. The database can be opened 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 by admin users.

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.

RemoteDisasterRecoveryType string

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) The list of scheduled operations.

SecretId string

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

SecretVersionNumber int

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

Source string

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

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the 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.

Timestamp string

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

UseLatestAvailableBackupTimeStamp bool

Clone from latest available backup timestamp.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

WhitelistedIps []string

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

compartmentId String

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

dbName String

adminPassword String

arePrimaryWhitelistedIpsUsed Boolean

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

characterSet String

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

cloneType String

The Autonomous Database clone type.

computeCount Double

computeModel String

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

cpuCoreCount Integer

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

dataStorageSizeInTbs Integer

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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.

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>

isAccessControlEnabled Boolean

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

isDedicated Boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier Boolean

isLocalDataGuardEnabled Boolean

isMtlsConnectionRequired Boolean

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

isPreviewVersionWithServiceTermsAccepted Boolean

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

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

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

maxCpuCoreCount Integer

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

ncharacterSet String

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

nsgIds List<String>

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

ocpuCount Double

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

openMode String

Indicates the Autonomous Database mode. The database can be opened 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 by admin users.

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.

remoteDisasterRecoveryType String

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) The list of scheduled operations.

secretId String

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

secretVersionNumber Integer

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

source String

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>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the 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.

timestamp String

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

useLatestAvailableBackupTimeStamp Boolean

Clone from latest available backup timestamp.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps List<String>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

compartmentId string

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

dbName string

adminPassword string

arePrimaryWhitelistedIpsUsed boolean

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

characterSet string

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

cloneType string

The Autonomous Database clone type.

computeCount number

computeModel string

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

cpuCoreCount number

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

dataStorageSizeInTbs number

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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.

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}

isAccessControlEnabled boolean

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

isDedicated boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier boolean

isLocalDataGuardEnabled boolean

isMtlsConnectionRequired boolean

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

isPreviewVersionWithServiceTermsAccepted boolean

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

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

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

maxCpuCoreCount number

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

ncharacterSet string

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

nsgIds string[]

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

ocpuCount number

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

openMode string

Indicates the Autonomous Database mode. The database can be opened 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 by admin users.

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.

remoteDisasterRecoveryType string

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) The list of scheduled operations.

secretId string

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

secretVersionNumber number

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

source string

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[]

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the 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.

timestamp string

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

useLatestAvailableBackupTimeStamp boolean

Clone from latest available backup timestamp.

vaultId string

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps string[]

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

compartment_id str

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

db_name str

admin_password str

are_primary_whitelisted_ips_used bool

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

character_set str

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

clone_type str

The Autonomous Database clone type.

compute_count float

compute_model str

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

cpu_core_count int

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

data_storage_size_in_tbs int

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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.

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]

is_access_control_enabled bool

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

is_dedicated bool

True if the database is on dedicated Exadata infrastructure.

is_free_tier bool

is_local_data_guard_enabled bool

is_mtls_connection_required bool

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

is_preview_version_with_service_terms_accepted bool

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

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

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

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.

ncharacter_set str

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

nsg_ids Sequence[str]

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

ocpu_count float

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

open_mode str

Indicates the Autonomous Database mode. The database can be opened 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 by admin users.

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.

remote_disaster_recovery_type str

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) The list of scheduled operations.

secret_id str

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

secret_version_number int

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

source str

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]

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the 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.

timestamp str

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

use_latest_available_backup_time_stamp bool

Clone from latest available backup timestamp.

vault_id str

The OCID of the Oracle Cloud Infrastructure vault.

whitelisted_ips Sequence[str]

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

compartmentId String

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

dbName String

adminPassword String

arePrimaryWhitelistedIpsUsed Boolean

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

characterSet String

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

cloneType String

The Autonomous Database clone type.

computeCount Number

computeModel String

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

cpuCoreCount Number

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

dataStorageSizeInTbs Number

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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.

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>

isAccessControlEnabled Boolean

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

isDedicated Boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier Boolean

isLocalDataGuardEnabled Boolean

isMtlsConnectionRequired Boolean

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

isPreviewVersionWithServiceTermsAccepted Boolean

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

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

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

maxCpuCoreCount Number

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

ncharacterSet String

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

nsgIds List<String>

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

ocpuCount Number

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

openMode String

Indicates the Autonomous Database mode. The database can be opened 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 by admin users.

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.

remoteDisasterRecoveryType String

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) The list of scheduled operations.

secretId String

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

secretVersionNumber Number

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

source String

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>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the 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.

timestamp String

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

useLatestAvailableBackupTimeStamp Boolean

Clone from latest available backup timestamp.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps List<String>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.
BackupRetentionPeriodInDays int: Retention period, in days, for backups.
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.
DisasterRecoveryRegionType string: The disaster recovery (DR) region type of the Autonomous Database. For Shared Autonomous Databases, DR associations have designated primary and standby regions. These region types do not change when the database changes roles. The standby region in DR associations can be the same region as the primary region, or they can be in a remote regions. Some database administration operations may be available only in the primary region of the DR association, and cannot be performed when the database using the primary role is operating in a remote 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.
IsRemoteDataGuardEnabled bool: Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.
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.
LocalDisasterRecoveryType string: Indicates the local disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.
LocalStandbyDbs List<AutonomousDatabaseLocalStandbyDb>: Autonomous Data Guard standby database details.
LongTermBackupSchedules List<AutonomousDatabaseLongTermBackupSchedule>: Details for the long-term backup schedule.
MemoryPerOracleComputeUnitInGbs int: The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.
NextLongTermBackupTimeStamp string: The date and time when the next long-term backup would be created.
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.
ProvisionableCpuses List<double>: An array of CPU values that an Autonomous Database can be scaled to.
RefreshableStatus string: The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.
RemoteDisasterRecoveryConfigurations List<AutonomousDatabaseRemoteDisasterRecoveryConfiguration>: Configurations of a Disaster Recovery.
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>: Deprecated 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.
TimeDisasterRecoveryRoleChanged string: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.
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.
TotalBackupStorageSizeInGbs double: The backup storage to the database.
UsedDataStorageSizeInGbs int: The storage space consumed by Autonomous Database in GBs.
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.
BackupRetentionPeriodInDays int: Retention period, in days, for backups.
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.
DisasterRecoveryRegionType string: The disaster recovery (DR) region type of the Autonomous Database. For Shared Autonomous Databases, DR associations have designated primary and standby regions. These region types do not change when the database changes roles. The standby region in DR associations can be the same region as the primary region, or they can be in a remote regions. Some database administration operations may be available only in the primary region of the DR association, and cannot be performed when the database using the primary role is operating in a remote 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.
IsRemoteDataGuardEnabled bool: Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.
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.
LocalDisasterRecoveryType string: Indicates the local disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.
LocalStandbyDbs []AutonomousDatabaseLocalStandbyDb: Autonomous Data Guard standby database details.
LongTermBackupSchedules []AutonomousDatabaseLongTermBackupSchedule: Details for the long-term backup schedule.
MemoryPerOracleComputeUnitInGbs int: The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.
NextLongTermBackupTimeStamp string: The date and time when the next long-term backup would be created.
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.
ProvisionableCpuses []float64: An array of CPU values that an Autonomous Database can be scaled to.
RefreshableStatus string: The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.
RemoteDisasterRecoveryConfigurations []AutonomousDatabaseRemoteDisasterRecoveryConfiguration: Configurations of a Disaster Recovery.
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: Deprecated 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.
TimeDisasterRecoveryRoleChanged string: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.
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.
TotalBackupStorageSizeInGbs float64: The backup storage to the database.
UsedDataStorageSizeInGbs int: The storage space consumed by Autonomous Database in GBs.
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.
backupRetentionPeriodInDays Integer: Retention period, in days, for backups.
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.
disasterRecoveryRegionType String: The disaster recovery (DR) region type of the Autonomous Database. For Shared Autonomous Databases, DR associations have designated primary and standby regions. These region types do not change when the database changes roles. The standby region in DR associations can be the same region as the primary region, or they can be in a remote regions. Some database administration operations may be available only in the primary region of the DR association, and cannot be performed when the database using the primary role is operating in a remote 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.
isRemoteDataGuardEnabled Boolean: Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.
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.
localDisasterRecoveryType String: Indicates the local disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.
localStandbyDbs List<AutonomousLocalStandbyDb>: Autonomous Data Guard standby database details.
longTermBackupSchedules List<AutonomousLongTermBackupSchedule>: Details for the long-term backup schedule.
memoryPerOracleComputeUnitInGbs Integer: The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.
nextLongTermBackupTimeStamp String: The date and time when the next long-term backup would be created.
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.
provisionableCpuses List<Double>: An array of CPU values that an Autonomous Database can be scaled to.
refreshableStatus String: The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.
remoteDisasterRecoveryConfigurations List<AutonomousRemoteDisasterRecoveryConfiguration>: Configurations of a Disaster Recovery.
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>: Deprecated 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.
timeDisasterRecoveryRoleChanged String: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.
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.
totalBackupStorageSizeInGbs Double: The backup storage to the database.
usedDataStorageSizeInGbs Integer: The storage space consumed by Autonomous Database in GBs.
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.
backupRetentionPeriodInDays number: Retention period, in days, for backups.
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.
disasterRecoveryRegionType string: The disaster recovery (DR) region type of the Autonomous Database. For Shared Autonomous Databases, DR associations have designated primary and standby regions. These region types do not change when the database changes roles. The standby region in DR associations can be the same region as the primary region, or they can be in a remote regions. Some database administration operations may be available only in the primary region of the DR association, and cannot be performed when the database using the primary role is operating in a remote 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.
isRemoteDataGuardEnabled boolean: Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.
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.
localDisasterRecoveryType string: Indicates the local disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.
localStandbyDbs AutonomousDatabaseLocalStandbyDb[]: Autonomous Data Guard standby database details.
longTermBackupSchedules AutonomousDatabaseLongTermBackupSchedule[]: Details for the long-term backup schedule.
memoryPerOracleComputeUnitInGbs number: The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.
nextLongTermBackupTimeStamp string: The date and time when the next long-term backup would be created.
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.
provisionableCpuses number[]: An array of CPU values that an Autonomous Database can be scaled to.
refreshableStatus string: The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.
remoteDisasterRecoveryConfigurations AutonomousDatabaseRemoteDisasterRecoveryConfiguration[]: Configurations of a Disaster Recovery.
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[]: Deprecated 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.
timeDisasterRecoveryRoleChanged string: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.
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.
totalBackupStorageSizeInGbs number: The backup storage to the database.
usedDataStorageSizeInGbs number: The storage space consumed by Autonomous Database in GBs.
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.
backup_retention_period_in_days int: Retention period, in days, for backups.
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.
disaster_recovery_region_type str: The disaster recovery (DR) region type of the Autonomous Database. For Shared Autonomous Databases, DR associations have designated primary and standby regions. These region types do not change when the database changes roles. The standby region in DR associations can be the same region as the primary region, or they can be in a remote regions. Some database administration operations may be available only in the primary region of the DR association, and cannot be performed when the database using the primary role is operating in a remote 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.
is_remote_data_guard_enabled bool: Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.
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.
local_disaster_recovery_type str: Indicates the local disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.
local_standby_dbs AutonomousDatabaseLocalStandbyDb]: Autonomous Data Guard standby database details.
long_term_backup_schedules AutonomousDatabaseLongTermBackupSchedule]: Details for the long-term backup schedule.
memory_per_oracle_compute_unit_in_gbs int: The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.
next_long_term_backup_time_stamp str: The date and time when the next long-term backup would be created.
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.
provisionable_cpuses Sequence[float]: An array of CPU values that an Autonomous Database can be scaled to.
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.
remote_disaster_recovery_configurations AutonomousDatabaseRemoteDisasterRecoveryConfiguration]: Configurations of a Disaster Recovery.
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]: Deprecated 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_disaster_recovery_role_changed str: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.
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.
total_backup_storage_size_in_gbs float: The backup storage to the database.
used_data_storage_size_in_gbs int: The storage space consumed by Autonomous Database in GBs.
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.
backupRetentionPeriodInDays Number: Retention period, in days, for backups.
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.
disasterRecoveryRegionType String: The disaster recovery (DR) region type of the Autonomous Database. For Shared Autonomous Databases, DR associations have designated primary and standby regions. These region types do not change when the database changes roles. The standby region in DR associations can be the same region as the primary region, or they can be in a remote regions. Some database administration operations may be available only in the primary region of the DR association, and cannot be performed when the database using the primary role is operating in a remote 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.
isRemoteDataGuardEnabled Boolean: Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.
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.
localDisasterRecoveryType String: Indicates the local disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.
localStandbyDbs List<Property Map>: Autonomous Data Guard standby database details.
longTermBackupSchedules List<Property Map>: Details for the long-term backup schedule.
memoryPerOracleComputeUnitInGbs Number: The amount of memory (in GBs) enabled per each OCPU core in Autonomous VM Cluster.
nextLongTermBackupTimeStamp String: The date and time when the next long-term backup would be created.
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.
provisionableCpuses List<Number>: An array of CPU values that an Autonomous Database can be scaled to.
refreshableStatus String: The refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.
remoteDisasterRecoveryConfigurations List<Property Map>: Configurations of a Disaster Recovery.
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>: Deprecated 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.
timeDisasterRecoveryRoleChanged String: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.
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.
totalBackupStorageSizeInGbs Number: The backup storage to the database.
usedDataStorageSizeInGbs Number: The storage space consumed by Autonomous Database in GBs.
usedDataStorageSizeInTbs Number: The amount of storage that has been used, in terabytes.

Look up 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,
        backup_retention_period_in_days: Optional[int] = None,
        character_set: Optional[str] = None,
        clone_type: Optional[str] = None,
        compartment_id: Optional[str] = None,
        compute_count: Optional[float] = None,
        compute_model: 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,
        disaster_recovery_region_type: Optional[str] = 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_local_data_guard_enabled: 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_remote_data_guard_enabled: 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,
        local_disaster_recovery_type: Optional[str] = None,
        local_standby_dbs: Optional[Sequence[_database.AutonomousDatabaseLocalStandbyDbArgs]] = None,
        long_term_backup_schedules: Optional[Sequence[_database.AutonomousDatabaseLongTermBackupScheduleArgs]] = None,
        max_cpu_core_count: Optional[int] = None,
        memory_per_oracle_compute_unit_in_gbs: Optional[int] = None,
        ncharacter_set: Optional[str] = None,
        next_long_term_backup_time_stamp: Optional[str] = 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,
        provisionable_cpuses: Optional[Sequence[float]] = None,
        refreshable_mode: Optional[str] = None,
        refreshable_status: Optional[str] = None,
        remote_disaster_recovery_configurations: Optional[Sequence[_database.AutonomousDatabaseRemoteDisasterRecoveryConfigurationArgs]] = None,
        remote_disaster_recovery_type: Optional[str] = None,
        role: Optional[str] = None,
        rotate_key_trigger: Optional[bool] = None,
        scheduled_operations: Optional[Sequence[_database.AutonomousDatabaseScheduledOperationArgs]] = None,
        secret_id: Optional[str] = None,
        secret_version_number: Optional[int] = 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_disaster_recovery_role_changed: 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,
        total_backup_storage_size_in_gbs: Optional[float] = None,
        use_latest_available_backup_time_stamp: Optional[bool] = None,
        used_data_storage_size_in_gbs: Optional[int] = 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

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

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

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.

BackupRetentionPeriodInDays int

Retention period, in days, for backups.

CharacterSet string

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

CloneType string

The Autonomous Database clone type.

CompartmentId string

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

ComputeCount double

ComputeModel string

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

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

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

DataStorageSizeInTbs int

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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

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.

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.

DisasterRecoveryRegionType string

The disaster recovery (DR) region type of the Autonomous Database. For Shared Autonomous Databases, DR associations have designated primary and standby regions. These region types do not change when the database changes roles. The standby region in DR associations can be the same region as the primary region, or they can be in a remote regions. Some database administration operations may be available only in the primary region of the DR association, and cannot be performed when the database using the primary role is operating in a remote region.

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>

InfrastructureType string

The infrastructure type this resource belongs to.

IsAccessControlEnabled bool

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

IsDedicated bool

True if the database is on dedicated Exadata infrastructure.

IsFreeTier bool

IsLocalDataGuardEnabled bool

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

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.

IsRemoteDataGuardEnabled bool

Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

IsShrinkOnly bool

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

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

LifecycleDetails string

Additional information about the current lifecycle state.

LocalDisasterRecoveryType string

Indicates the local disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.

LocalStandbyDbs List<AutonomousDatabaseLocalStandbyDbArgs>

Autonomous Data Guard standby database details.

LongTermBackupSchedules List<AutonomousDatabaseLongTermBackupScheduleArgs>

Details for the long-term backup schedule.

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.

NcharacterSet string

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

NextLongTermBackupTimeStamp string

The date and time when the next long-term backup would be created.

NsgIds List<string>

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

OcpuCount double

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

OpenMode string

Indicates the Autonomous Database mode. The database can be opened 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 by 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.

ProvisionableCpuses List<double>

An array of CPU values that an Autonomous Database can be scaled to.

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.

RemoteDisasterRecoveryConfigurations List<AutonomousDatabaseRemoteDisasterRecoveryConfigurationArgs>

Configurations of a Disaster Recovery.

RemoteDisasterRecoveryType string

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) The list of scheduled operations.

SecretId string

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

SecretVersionNumber int

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

ServiceConsoleUrl string

The URL of the Service Console for the Autonomous Database.

Source string

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>

Deprecated Autonomous Data Guard standby database details.

StandbyWhitelistedIps List<string>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the database.

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.

TimeDisasterRecoveryRoleChanged string

The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.

TotalBackupStorageSizeInGbs double

The backup storage to the database.

UseLatestAvailableBackupTimeStamp bool

Clone from latest available backup timestamp.

UsedDataStorageSizeInGbs int

The storage space consumed by Autonomous Database in GBs.

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>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

ActualUsedDataStorageSizeInTbs float64

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

AdminPassword string

AllocatedStorageSizeInTbs float64

ApexDetails []AutonomousDatabaseApexDetailArgs

Information about Oracle APEX Application Development.

ArePrimaryWhitelistedIpsUsed bool

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

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.

BackupRetentionPeriodInDays int

Retention period, in days, for backups.

CharacterSet string

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

CloneType string

The Autonomous Database clone type.

CompartmentId string

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

ComputeCount float64

ComputeModel string

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

ConnectionStrings []AutonomousDatabaseConnectionStringArgs

ConnectionUrls []AutonomousDatabaseConnectionUrlArgs

CpuCoreCount int

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

DataStorageSizeInTbs int

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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

DbName string

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.

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.

DisasterRecoveryRegionType string

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{}

InfrastructureType string

The infrastructure type this resource belongs to.

IsAccessControlEnabled bool

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

IsDedicated bool

True if the database is on dedicated Exadata infrastructure.

IsFreeTier bool

IsLocalDataGuardEnabled bool

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

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.

IsRemoteDataGuardEnabled bool

Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

IsShrinkOnly bool

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

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

LicenseModel string

LifecycleDetails string

Additional information about the current lifecycle state.

LocalDisasterRecoveryType string

LocalStandbyDbs []AutonomousDatabaseLocalStandbyDbArgs

Autonomous Data Guard standby database details.

LongTermBackupSchedules []AutonomousDatabaseLongTermBackupScheduleArgs

Details for the long-term backup schedule.

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.

NcharacterSet string

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

NextLongTermBackupTimeStamp string

The date and time when the next long-term backup would be created.

NsgIds []string

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

OcpuCount float64

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

OpenMode string

Indicates the Autonomous Database mode. The database can be opened 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

PermissionLevel string

The Autonomous Database permission level. Restricted mode allows access only by 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.

ProvisionableCpuses []float64

An array of CPU values that an Autonomous Database can be scaled to.

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.

RemoteDisasterRecoveryConfigurations []AutonomousDatabaseRemoteDisasterRecoveryConfigurationArgs

Configurations of a Disaster Recovery.

RemoteDisasterRecoveryType string

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) The list of scheduled operations.

SecretId string

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

SecretVersionNumber int

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

ServiceConsoleUrl string

The URL of the Service Console for the Autonomous Database.

Source string

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

Deprecated Autonomous Data Guard standby database details.

StandbyWhitelistedIps []string

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the database.

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

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.

TimeDisasterRecoveryRoleChanged string

The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.

TotalBackupStorageSizeInGbs float64

The backup storage to the database.

UseLatestAvailableBackupTimeStamp bool

Clone from latest available backup timestamp.

UsedDataStorageSizeInGbs int

The storage space consumed by Autonomous Database in GBs.

UsedDataStorageSizeInTbs int

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

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

WhitelistedIps []string

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

actualUsedDataStorageSizeInTbs Double

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

adminPassword String

allocatedStorageSizeInTbs Double

apexDetails List<AutonomousApexDetailArgs>

Information about Oracle APEX Application Development.

arePrimaryWhitelistedIpsUsed Boolean

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

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.

backupRetentionPeriodInDays Integer

Retention period, in days, for backups.

characterSet String

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

cloneType String

The Autonomous Database clone type.

compartmentId String

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

computeCount Double

computeModel String

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

connectionStrings List<AutonomousConnectionStringArgs>

connectionUrls List<AutonomousConnectionUrlArgs>

cpuCoreCount Integer

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

dataStorageSizeInTbs Integer

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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

dbName String

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.

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.

disasterRecoveryRegionType String

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>

infrastructureType String

The infrastructure type this resource belongs to.

isAccessControlEnabled Boolean

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

isDedicated Boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier Boolean

isLocalDataGuardEnabled Boolean

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

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.

isRemoteDataGuardEnabled Boolean

Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

isShrinkOnly Boolean

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

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

licenseModel String

lifecycleDetails String

Additional information about the current lifecycle state.

localDisasterRecoveryType String

localStandbyDbs List<AutonomousLocalStandbyDbArgs>

Autonomous Data Guard standby database details.

longTermBackupSchedules List<AutonomousLongTermBackupScheduleArgs>

Details for the long-term backup schedule.

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.

ncharacterSet String

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

nextLongTermBackupTimeStamp String

The date and time when the next long-term backup would be created.

nsgIds List<String>

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

ocpuCount Double

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

openMode String

Indicates the Autonomous Database mode. The database can be opened 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>

permissionLevel String

The Autonomous Database permission level. Restricted mode allows access only by 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.

provisionableCpuses List<Double>

An array of CPU values that an Autonomous Database can be scaled to.

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.

remoteDisasterRecoveryConfigurations List<AutonomousRemoteDisasterRecoveryConfigurationArgs>

Configurations of a Disaster Recovery.

remoteDisasterRecoveryType String

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) The list of scheduled operations.

secretId String

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

secretVersionNumber Integer

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

serviceConsoleUrl String

The URL of the Service Console for the Autonomous Database.

source String

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>

Deprecated Autonomous Data Guard standby database details.

standbyWhitelistedIps List<String>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the database.

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

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.

timeDisasterRecoveryRoleChanged String

The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.

totalBackupStorageSizeInGbs Double

The backup storage to the database.

useLatestAvailableBackupTimeStamp Boolean

Clone from latest available backup timestamp.

usedDataStorageSizeInGbs Integer

The storage space consumed by Autonomous Database in GBs.

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>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

actualUsedDataStorageSizeInTbs number

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

adminPassword string

allocatedStorageSizeInTbs number

apexDetails AutonomousDatabaseApexDetailArgs[]

Information about Oracle APEX Application Development.

arePrimaryWhitelistedIpsUsed boolean

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

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.

backupRetentionPeriodInDays number

Retention period, in days, for backups.

characterSet string

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

cloneType string

The Autonomous Database clone type.

compartmentId string

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

computeCount number

computeModel string

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

connectionStrings AutonomousDatabaseConnectionStringArgs[]

connectionUrls AutonomousDatabaseConnectionUrlArgs[]

cpuCoreCount number

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

dataStorageSizeInTbs number

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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

dbName string

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.

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.

disasterRecoveryRegionType string

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}

infrastructureType string

The infrastructure type this resource belongs to.

isAccessControlEnabled boolean

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

isDedicated boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier boolean

isLocalDataGuardEnabled boolean

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

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.

isRemoteDataGuardEnabled boolean

Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

isShrinkOnly boolean

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

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

licenseModel string

lifecycleDetails string

Additional information about the current lifecycle state.

localDisasterRecoveryType string

localStandbyDbs AutonomousDatabaseLocalStandbyDbArgs[]

Autonomous Data Guard standby database details.

longTermBackupSchedules AutonomousDatabaseLongTermBackupScheduleArgs[]

Details for the long-term backup schedule.

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.

ncharacterSet string

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

nextLongTermBackupTimeStamp string

The date and time when the next long-term backup would be created.

nsgIds string[]

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

ocpuCount number

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

openMode string

Indicates the Autonomous Database mode. The database can be opened 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[]

permissionLevel string

The Autonomous Database permission level. Restricted mode allows access only by 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.

provisionableCpuses number[]

An array of CPU values that an Autonomous Database can be scaled to.

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.

remoteDisasterRecoveryConfigurations AutonomousDatabaseRemoteDisasterRecoveryConfigurationArgs[]

Configurations of a Disaster Recovery.

remoteDisasterRecoveryType string

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) The list of scheduled operations.

secretId string

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

secretVersionNumber number

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

serviceConsoleUrl string

The URL of the Service Console for the Autonomous Database.

source string

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[]

Deprecated Autonomous Data Guard standby database details.

standbyWhitelistedIps string[]

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the database.

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

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.

timeDisasterRecoveryRoleChanged string

The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.

totalBackupStorageSizeInGbs number

The backup storage to the database.

useLatestAvailableBackupTimeStamp boolean

Clone from latest available backup timestamp.

usedDataStorageSizeInGbs number

The storage space consumed by Autonomous Database in GBs.

usedDataStorageSizeInTbs number

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

vaultId string

The OCID of the Oracle Cloud Infrastructure vault.

whitelistedIps string[]

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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

allocated_storage_size_in_tbs float

apex_details AutonomousDatabaseApexDetailArgs]

Information about Oracle APEX Application Development.

are_primary_whitelisted_ips_used bool

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

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.

backup_retention_period_in_days int

Retention period, in days, for backups.

character_set str

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

clone_type str

The Autonomous Database clone type.

compartment_id str

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

compute_count float

compute_model str

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

connection_strings AutonomousDatabaseConnectionStringArgs]

connection_urls AutonomousDatabaseConnectionUrlArgs]

cpu_core_count int

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

data_storage_size_in_tbs int

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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

db_name str

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.

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.

disaster_recovery_region_type str

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]

infrastructure_type str

The infrastructure type this resource belongs to.

is_access_control_enabled bool

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

is_dedicated bool

True if the database is on dedicated Exadata infrastructure.

is_free_tier bool

is_local_data_guard_enabled bool

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

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_remote_data_guard_enabled bool

Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

is_shrink_only bool

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

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

license_model str

lifecycle_details str

Additional information about the current lifecycle state.

local_disaster_recovery_type str

local_standby_dbs AutonomousDatabaseLocalStandbyDbArgs]

Autonomous Data Guard standby database details.

long_term_backup_schedules AutonomousDatabaseLongTermBackupScheduleArgs]

Details for the long-term backup schedule.

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.

ncharacter_set str

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

next_long_term_backup_time_stamp str

The date and time when the next long-term backup would be created.

nsg_ids Sequence[str]

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

ocpu_count float

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

open_mode str

Indicates the Autonomous Database mode. The database can be opened 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]

permission_level str

The Autonomous Database permission level. Restricted mode allows access only by 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.

provisionable_cpuses Sequence[float]

An array of CPU values that an Autonomous Database can be scaled to.

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.

remote_disaster_recovery_configurations AutonomousDatabaseRemoteDisasterRecoveryConfigurationArgs]

Configurations of a Disaster Recovery.

remote_disaster_recovery_type str

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) The list of scheduled operations.

secret_id str

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

secret_version_number int

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

service_console_url str

The URL of the Service Console for the Autonomous Database.

source str

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]

Deprecated Autonomous Data Guard standby database details.

standby_whitelisted_ips Sequence[str]

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the database.

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

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_disaster_recovery_role_changed str

The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.

total_backup_storage_size_in_gbs float

The backup storage to the database.

use_latest_available_backup_time_stamp bool

Clone from latest available backup timestamp.

used_data_storage_size_in_gbs int

The storage space consumed by Autonomous Database in GBs.

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]

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

actualUsedDataStorageSizeInTbs Number

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

adminPassword String

allocatedStorageSizeInTbs Number

apexDetails List<Property Map>

Information about Oracle APEX Application Development.

arePrimaryWhitelistedIpsUsed Boolean

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

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.

backupRetentionPeriodInDays Number

Retention period, in days, for backups.

characterSet String

The character set for the autonomous database. The default is AL32UTF8. Allowed values for an Autonomous Database on shared infrastructure as as returned by List Autonomous Database Character Sets

For an Autonomous Database on dedicated infrastructure, the allowed values are:

cloneType String

The Autonomous Database clone type.

compartmentId String

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

computeCount Number

computeModel String

The compute model of the Autonomous Database. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value.

connectionStrings List<Property Map>

connectionUrls List<Property Map>

cpuCoreCount Number

The data type must be an integer.
The minimum number of cores for all types of autonomous database is 1
The maximum number of cores is as follows:
Autonomous Databases on shared Exadata infrastructure: The maximum number of cores is 128.
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

Notes

This parameter is only supported for dedicated Exadata infrastructure.
This parameter cannot be used with the dataStorageSizeInTBs parameter.

dataStorageSizeInTbs Number

Note: This parameter cannot be used with the dataStorageSizeInGBs parameter. This input is ignored for Always Free resources.

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

dbName String

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.

definedTags Map<Any>

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

disasterRecoveryRegionType String

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>

infrastructureType String

The infrastructure type this resource belongs to.

isAccessControlEnabled Boolean

This property is applicable only to Autonomous Databases on the Exadata Cloud@Customer platform.

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

isDedicated Boolean

True if the database is on dedicated Exadata infrastructure.

isFreeTier Boolean

isLocalDataGuardEnabled Boolean

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

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.

isRemoteDataGuardEnabled Boolean

Indicates whether the Autonomous Database has Cross Region Data Guard enabled. Not applicable to Autonomous Databases using dedicated Exadata infrastructure or Exadata Cloud@Customer infrastructure.

isShrinkOnly Boolean

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

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

licenseModel String

lifecycleDetails String

Additional information about the current lifecycle state.

localDisasterRecoveryType String

localStandbyDbs List<Property Map>

Autonomous Data Guard standby database details.

longTermBackupSchedules List<Property Map>

Details for the long-term backup schedule.

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.

ncharacterSet String

The national character set for the autonomous database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

nextLongTermBackupTimeStamp String

The date and time when the next long-term backup would be created.

nsgIds List<String>

A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.

ocpuCount Number

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

The following points apply:

For Autonomous Databases on dedicated Exadata infrastructure, to provision less than 1 core, enter a fractional value in an increment of 0.1. For example, you can provision 0.3 or 0.4 cores, but not 0.35 cores. (Note that fractional OCPU values are not supported for Autonomous Databasese on shared Exadata infrastructure.)
To provision 1 or more cores, you must enter an integer between 1 and the maximum number of cores available for the infrastructure shape. For example, you can provision 2 cores or 3 cores, but not 2.5 cores. This applies to Autonomous Databases on both shared and dedicated Exadata infrastructure.

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.

Note: This parameter cannot be used with the cpuCoreCount parameter.

openMode String

Indicates the Autonomous Database mode. The database can be opened 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>

permissionLevel String

The Autonomous Database permission level. Restricted mode allows access only by 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.

provisionableCpuses List<Number>

An array of CPU values that an Autonomous Database can be scaled to.

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.

remoteDisasterRecoveryConfigurations List<Property Map>

Configurations of a Disaster Recovery.

remoteDisasterRecoveryType String

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) The list of scheduled operations.

secretId String

(Updatable) The Oracle Cloud Infrastructure vault secret [/Content/General/Concepts/identifiers.htm]OCID.

secretVersionNumber Number

(Updatable) The version of the vault secret. If no version is specified, the latest version will be used.

serviceConsoleUrl String

The URL of the Service Console for the Autonomous Database.

source String

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>

Deprecated Autonomous Data Guard standby database details.

standbyWhitelistedIps List<String>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

Subnet Restrictions:

For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28.
For Exadata and virtual machine 2-node RAC systems, do not use a subnet that overlaps with 192.168.128.0/20.
For Autonomous Database, setting this will disable public secure access to the database.

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

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.

timeDisasterRecoveryRoleChanged String

The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.

totalBackupStorageSizeInGbs Number

The backup storage to the database.

useLatestAvailableBackupTimeStamp Boolean

Clone from latest available backup timestamp.

usedDataStorageSizeInGbs Number

The storage space consumed by Autonomous Database in GBs.

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>

For an update operation, if you want to delete all the IPs in the ACL, use an array with a single empty string entry.

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.

AutonomousDatabaseLocalStandbyDb

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.
TimeDisasterRecoveryRoleChanged string: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.
TimeDisasterRecoveryRoleChanged string: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.
timeDisasterRecoveryRoleChanged String: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.
timeDisasterRecoveryRoleChanged string: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.
time_disaster_recovery_role_changed str: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

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.
timeDisasterRecoveryRoleChanged String: The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

AutonomousDatabaseLongTermBackupSchedule

IsDisabled bool: Indicates if the long-term backup schedule should be deleted. The default value is FALSE.
RepeatCadence string: The frequency of the long-term backup schedule
RetentionPeriodInDays int: Retention period, in days, for long-term backups
TimeOfBackup string: The timestamp for the long-term backup schedule. For a MONTHLY cadence, months having fewer days than the provided date will have the backup taken on the last day of that month.

IsDisabled bool: Indicates if the long-term backup schedule should be deleted. The default value is FALSE.
RepeatCadence string: The frequency of the long-term backup schedule
RetentionPeriodInDays int: Retention period, in days, for long-term backups
TimeOfBackup string: The timestamp for the long-term backup schedule. For a MONTHLY cadence, months having fewer days than the provided date will have the backup taken on the last day of that month.

isDisabled Boolean: Indicates if the long-term backup schedule should be deleted. The default value is FALSE.
repeatCadence String: The frequency of the long-term backup schedule
retentionPeriodInDays Integer: Retention period, in days, for long-term backups
timeOfBackup String: The timestamp for the long-term backup schedule. For a MONTHLY cadence, months having fewer days than the provided date will have the backup taken on the last day of that month.

isDisabled boolean: Indicates if the long-term backup schedule should be deleted. The default value is FALSE.
repeatCadence string: The frequency of the long-term backup schedule
retentionPeriodInDays number: Retention period, in days, for long-term backups
timeOfBackup string: The timestamp for the long-term backup schedule. For a MONTHLY cadence, months having fewer days than the provided date will have the backup taken on the last day of that month.

is_disabled bool: Indicates if the long-term backup schedule should be deleted. The default value is FALSE.
repeat_cadence str: The frequency of the long-term backup schedule
retention_period_in_days int: Retention period, in days, for long-term backups
time_of_backup str: The timestamp for the long-term backup schedule. For a MONTHLY cadence, months having fewer days than the provided date will have the backup taken on the last day of that month.

isDisabled Boolean: Indicates if the long-term backup schedule should be deleted. The default value is FALSE.
repeatCadence String: The frequency of the long-term backup schedule
retentionPeriodInDays Number: Retention period, in days, for long-term backups
timeOfBackup String: The timestamp for the long-term backup schedule. For a MONTHLY cadence, months having fewer days than the provided date will have the backup taken on the last day of that month.

AutonomousDatabaseRemoteDisasterRecoveryConfiguration

DisasterRecoveryType string: Indicates the disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.

DisasterRecoveryType string: Indicates the disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.

disasterRecoveryType String: Indicates the disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.

disasterRecoveryType string: Indicates the disaster recovery (DR) type of the Shared Autonomous Database. Autonomous Data Guard (ADG) DR type provides business critical DR with a faster recovery time objective (RTO) during failover or switchover. Backup-based DR type provides lower cost DR with a slower RTO during failover or switchover.

oci.Database.AutonomousDatabase

On this page

On this page

Create AutonomousDatabase Resource

AutonomousDatabase Resource Properties

Inputs

Outputs

Look up Existing AutonomousDatabase Resource

Supporting Types

AutonomousDatabaseApexDetail

AutonomousDatabaseBackupConfig

AutonomousDatabaseConnectionString

AutonomousDatabaseConnectionStringProfile

AutonomousDatabaseConnectionUrl

AutonomousDatabaseCustomerContact

AutonomousDatabaseKeyHistoryEntry

AutonomousDatabaseLocalStandbyDb

AutonomousDatabaseLongTermBackupSchedule

AutonomousDatabaseRemoteDisasterRecoveryConfiguration