Autonomous Databases - Create Or Update

Service:: Oracle Database

API Version:: 2025-03-01

Create a AutonomousDatabase

PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Oracle.Database/autonomousDatabases/{autonomousdatabasename}?api-version=2025-03-01

URI Parameters

Name	In	Required	Type	Description
autonomousdatabasename	path	True	string minLength: 1 maxLength: 30 pattern: .*	The database name.
resourceGroupName	path	True	string minLength: 1 maxLength: 90	The name of the resource group. The name is case insensitive.
subscriptionId	path	True	string (uuid)	The ID of the target subscription. The value must be an UUID.
api-version	query	True	string minLength: 1	The API version to use for this operation.

Request Body

Name	Required	Type	Description
location	True	string	The geo-location where the resource lives
properties.dataBaseType	True	DataBaseType	Database type to be created.
properties.adminPassword		string (password) minLength: 12 maxLength: 30	Admin password.
properties.autonomousDatabaseId		string (arm-id)	Autonomous Database ID
properties.autonomousMaintenanceScheduleType		AutonomousMaintenanceScheduleType	The maintenance schedule type of the Autonomous Database Serverless.
properties.backupRetentionPeriodInDays		integer (int32)	Retention period, in days, for long-term backups
properties.characterSet		string minLength: 1 maxLength: 255	The character set for the autonomous database.
properties.computeCount		number (float) minimum: 0.1 maximum: 512	The compute amount (CPUs) available to the database.
properties.computeModel		ComputeModel	The compute model of the Autonomous Database.
properties.cpuCoreCount		integer (int32) minimum: 1 maximum: 128	The number of CPU cores to be made available to the database.
properties.customerContacts		CustomerContact[]	Customer Contacts.
properties.dataStorageSizeInGbs		integer (int32) minimum: 20 maximum: 393216	The size, in gigabytes, of the data volume that will be created and attached to the database.
properties.dataStorageSizeInTbs		integer (int32) minimum: 1 maximum: 384	The quantity of data in the database, in terabytes.
properties.databaseEdition		DatabaseEditionType	The Oracle Database Edition that applies to the Autonomous databases.
properties.dbVersion		string minLength: 1 maxLength: 255	A valid Oracle Database version for Autonomous Database.
properties.dbWorkload		WorkloadType	The Autonomous Database workload type
properties.displayName		string minLength: 1 maxLength: 255	The user-friendly name for the Autonomous Database.
properties.isAutoScalingEnabled		boolean	Indicates if auto scaling is enabled for the Autonomous Database CPU core count.
properties.isAutoScalingForStorageEnabled		boolean	Indicates if auto scaling is enabled for the Autonomous Database storage.
properties.isLocalDataGuardEnabled		boolean	Indicates whether the Autonomous Database has local or called in-region Data Guard enabled.
properties.isMtlsConnectionRequired		boolean	Specifies if the Autonomous Database requires mTLS connections.
properties.isPreviewVersionWithServiceTermsAccepted		boolean	Specifies if the Autonomous Database preview version is being provisioned.
properties.licenseModel		LicenseModel	The Oracle license model that applies to the Oracle Autonomous Database. The default is LICENSE_INCLUDED.
properties.localAdgAutoFailoverMaxDataLossLimit		integer (int32) minimum: 0 maximum: 3600	Parameter that allows users to select an acceptable maximum data loss limit in seconds, up to which Automatic Failover will be triggered when necessary for a Local Autonomous Data Guard
properties.longTermBackupSchedule		LongTermBackUpScheduleDetails	Details for the long-term backup schedule.
properties.ncharacterSet		string minLength: 1 maxLength: 255	The character set for the Autonomous Database.
properties.openMode		OpenModeType	Indicates the Autonomous Database mode.
properties.peerDbId		string minLength: 1 maxLength: 255	The Azure resource ID of the Disaster Recovery peer database, which is located in a different region from the current peer database.
properties.permissionLevel		PermissionLevelType	The Autonomous Database permission level.
properties.privateEndpointIp		string	The private endpoint Ip address for the resource.
properties.privateEndpointLabel		string	The resource's private endpoint label.
properties.role		RoleType	The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.
properties.scheduledOperations		ScheduledOperationsType	The list of scheduled operations.
properties.subnetId		string (arm-id)	Client subnet
properties.vnetId		string (arm-id)	VNET for network connectivity
properties.whitelistedIps		string[] minLength: 1 maxLength: 1024	The client IP access control list (ACL). This is an array of CIDR notations and/or IP addresses. Values should be separate strings, separated by commas. Example: ['1.1.1.1','1.1.1.0/24','1.1.2.25']
tags		object	Resource tags.

Responses

Name	Type	Description
200 OK	AutonomousDatabase	Resource 'AutonomousDatabase' update operation succeeded
201 Created	AutonomousDatabase	Resource 'AutonomousDatabase' create operation succeeded Headers Azure-AsyncOperation: string Retry-After: integer
Other Status Codes	ErrorResponse	An unexpected error response.

Name

Type

Description

200 OK

AutonomousDatabase

Resource 'AutonomousDatabase' update operation succeeded

201 Created

AutonomousDatabase

Resource 'AutonomousDatabase' create operation succeeded

Headers

Azure-AsyncOperation: string
Retry-After: integer

Other Status Codes

ErrorResponse

An unexpected error response.

Security

azure_auth

Azure Active Directory OAuth2 Flow.

Type: oauth2
Flow: implicit
Authorization URL: https://login.microsoftonline.com/common/oauth2/authorize

Scopes

Name	Description
user_impersonation	impersonate your user account

Examples

AutonomousDatabases_CreateOrUpdate

AutonomousDatabases_CreateOrUpdate_clone

AutonomousDatabases_CreateOrUpdate_CrossRegionPeer

Create Autonomous Database

Create clone Autonomous Database

AutonomousDatabases_CreateOrUpdate

Sample request

HTTP

PUT https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1?api-version=2025-03-01

{
  "properties": {
    "dataBaseType": "Regular",
    "displayName": "example_autonomous_databasedb1",
    "computeModel": "ECPU",
    "computeCount": 2,
    "dataStorageSizeInTbs": 1,
    "adminPassword": "********",
    "dbVersion": "18.4.0.0",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1"
  },
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  }
}

Sample response

Status code:: 200

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "customerContacts": null,
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "Regular",
    "dbVersion": "18.4.0.0",
    "displayName": "example_autonomous_databasedb1",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Succeeded",
    "lifecycleDetails": "success",
    "privateEndpointIp": null,
    "privateEndpointLabel": null,
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Succeeded",
    "ociUrl": "https://fake",
    "timeCreated": "2024-01-09T20:44:09.466Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

Status code:: 201

Retry-After: 100000000

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "customerContacts": null,
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "Regular",
    "dbVersion": "18.4.0.0",
    "displayName": "example_autonomous_databasedb1",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Succeeded",
    "lifecycleDetails": "success",
    "privateEndpointIp": null,
    "privateEndpointLabel": null,
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Succeeded",
    "ociUrl": "https://fake",
    "timeCreated": "2024-01-09T20:44:09.466Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

AutonomousDatabases_CreateOrUpdate_clone

Sample request

HTTP

PUT https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1?api-version=2025-03-01

{
  "properties": {
    "dataBaseType": "Clone",
    "sourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "cloneType": "Full",
    "displayName": "example_autonomous_databasedb1_clone",
    "computeModel": "ECPU",
    "computeCount": 2,
    "dataStorageSizeInTbs": 1,
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "adminPassword": "********",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1"
  },
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  }
}

Sample response

Status code:: 200

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1Clone",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "customerContacts": null,
    "cloneType": "Full",
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "Clone",
    "dbVersion": "18.4.0.0",
    "displayName": "example_autonomous_databasedb1",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Succeeded",
    "lifecycleDetails": "success",
    "privateEndpointIp": null,
    "privateEndpointLabel": null,
    "sourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Succeeded",
    "ociUrl": "https://fake",
    "timeCreated": "2024-01-09T20:44:09.466Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

Status code:: 201

Retry-After: 100000000

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1Clone",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "cloneType": "Full",
    "customerContacts": null,
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "Clone",
    "dbVersion": "18.4.0.0",
    "displayName": "example_autonomous_databasedb1",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Succeeded",
    "lifecycleDetails": "success",
    "privateEndpointIp": null,
    "privateEndpointLabel": null,
    "sourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Succeeded",
    "ociUrl": "https://fake",
    "timeCreated": "2024-01-09T20:44:09.466Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

AutonomousDatabases_CreateOrUpdate_CrossRegionPeer

Sample request

HTTP

PUT https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1?api-version=2025-03-01

{
  "properties": {
    "dataBaseType": "CrossRegionDisasterRecovery",
    "source": "CrossRegionDisasterRecovery",
    "sourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "sourceOcid": "ocid1..aaaaa",
    "sourceLocation": "germanywestcentral",
    "remoteDisasterRecoveryType": "Adg",
    "isReplicateAutomaticBackups": false,
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1"
  },
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  }
}

Sample response

Status code:: 200

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "customerContacts": null,
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "CrossRegionDisasterRecovery",
    "dbVersion": "19c",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Provisioning",
    "lifecycleDetails": null,
    "privateEndpointIp": null,
    "privateEndpointLabel": "r8dm9hhc",
    "remoteDisasterRecoveryType": "Adg",
    "isReplicateAutomaticBackups": false,
    "sourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Provisioning",
    "ociUrl": "https://fake",
    "timeCreated": "2024-07-12T18:06:08.810Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

Status code:: 201

Retry-After: 100000000

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1Clone",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "customerContacts": null,
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "CrossRegionDisasterRecovery",
    "dbVersion": "18.4.0.0",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Provisioning",
    "lifecycleDetails": null,
    "privateEndpointIp": null,
    "privateEndpointLabel": "r8dm9hhc",
    "remoteDisasterRecoveryType": "Adg",
    "sourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Provisioning",
    "ociUrl": "https://fake",
    "timeCreated": "2024-07-12T18:06:08.810Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

Create Autonomous Database

Sample request

HTTP

PUT https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1?api-version=2025-03-01

{
  "properties": {
    "dataBaseType": "Regular",
    "displayName": "example_autonomous_databasedb1",
    "computeModel": "ECPU",
    "computeCount": 2,
    "dataStorageSizeInTbs": 1,
    "adminPassword": "********",
    "dbVersion": "18.4.0.0",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1"
  },
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  }
}

Sample response

Status code:: 200

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "customerContacts": null,
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "Regular",
    "dbVersion": "18.4.0.0",
    "displayName": "example_autonomous_databasedb1",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Succeeded",
    "lifecycleDetails": "success",
    "privateEndpointIp": null,
    "privateEndpointLabel": null,
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Succeeded",
    "ociUrl": "https://fake",
    "timeCreated": "2024-01-09T20:44:09.466Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

Status code:: 201

Retry-After: 100000000

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "customerContacts": null,
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "Regular",
    "dbVersion": "18.4.0.0",
    "displayName": "example_autonomous_databasedb1",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Succeeded",
    "lifecycleDetails": "success",
    "privateEndpointIp": null,
    "privateEndpointLabel": null,
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Succeeded",
    "ociUrl": "https://fake",
    "timeCreated": "2024-01-09T20:44:09.466Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

Create clone Autonomous Database

Sample request

HTTP

PUT https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1?api-version=2025-03-01

{
  "properties": {
    "dataBaseType": "Clone",
    "sourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "cloneType": "Full",
    "displayName": "example_autonomous_databasedb1_clone",
    "computeModel": "ECPU",
    "computeCount": 2,
    "dataStorageSizeInTbs": 1,
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "adminPassword": "********",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1"
  },
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  }
}

Sample response

Status code:: 200

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1Clone",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "customerContacts": null,
    "cloneType": "Full",
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "Clone",
    "dbVersion": "18.4.0.0",
    "displayName": "example_autonomous_databasedb1",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Succeeded",
    "lifecycleDetails": "success",
    "privateEndpointIp": null,
    "privateEndpointLabel": null,
    "sourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Succeeded",
    "ociUrl": "https://fake",
    "timeCreated": "2024-01-09T20:44:09.466Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

Status code:: 201

Retry-After: 100000000

{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
  "type": "Oracle.Database/autonomousDatabases",
  "location": "eastus",
  "tags": {
    "tagK1": "tagV1"
  },
  "properties": {
    "autonomousDatabaseId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1Clone",
    "actualUsedDataStorageSizeInTbs": null,
    "autonomousMaintenanceScheduleType": "Regular",
    "characterSet": "AL32UTF8",
    "ncharacterSet": "AL16UTF16",
    "computeCount": 2,
    "computeModel": "ECPU",
    "cpuCoreCount": 1,
    "cloneType": "Full",
    "customerContacts": null,
    "dataStorageSizeInGbs": 1024,
    "dataStorageSizeInTbs": 1,
    "databaseEdition": "EnterpriseEdition",
    "dataBaseType": "Clone",
    "dbVersion": "18.4.0.0",
    "displayName": "example_autonomous_databasedb1",
    "isAutoScalingEnabled": false,
    "isAutoScalingForStorageEnabled": false,
    "isLocalDataGuardEnabled": false,
    "isMtlsConnectionRequired": true,
    "licenseModel": "BringYourOwnLicense",
    "lifecycleState": "Succeeded",
    "lifecycleDetails": "success",
    "privateEndpointIp": null,
    "privateEndpointLabel": null,
    "sourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Oracle.Database/autonomousDatabases/databasedb1",
    "subnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    "vnetId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg000/providers/Microsoft.Network/virtualNetworks/vnet1",
    "provisioningState": "Succeeded",
    "ociUrl": "https://fake",
    "timeCreated": "2024-01-09T20:44:09.466Z",
    "timeMaintenanceBegin": null,
    "timeMaintenanceEnd": null,
    "usedDataStorageSizeInGbs": null,
    "usedDataStorageSizeInTbs": null,
    "ocid": "ocid1..aaaaa",
    "whitelistedIps": [
      "1.1.1.1",
      "1.1.1.0/24",
      "1.1.2.25"
    ]
  }
}

Definitions

Name	Description
AllConnectionStringType	The connection string profile to allow clients to group, filter and select connection string values based on structured metadata.
ApexDetailsType	Information about Oracle APEX Application Development.
AutonomousDatabase	Autonomous Database resource model.
AutonomousDatabaseLifecycleState	Autonomous database lifecycle state enum
AutonomousDatabaseStandbySummary	Autonomous Disaster Recovery standby database details.
AutonomousMaintenanceScheduleType	Autonomous database maintenance schedule type enum.
AzureResourceProvisioningState	Azure Resource Provisioning State enum
ComputeModel	Compute model enum
ConnectionStringType	Connection strings to connect to an Oracle Autonomous Database.
ConnectionUrlType	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.
ConsumerGroup	Consumer group enum.
createdByType	The type of identity that created the resource.
CustomerContact	CustomerContact resource properties
DatabaseEditionType	Database edition type enum.
DataBaseType	Database type enum
DataSafeStatusType	DataSafe status type enum.
DayOfWeek	DayOfWeek resource properties
DayOfWeekName	DayOfWeekName enum
DisasterRecoveryConfigurationDetails	Configurations of a Disaster Recovery Details
DisasterRecoveryType	Disaster recovery type enum.
ErrorAdditionalInfo	The resource management error additional info.
ErrorDetail	The error detail.
ErrorResponse	Error response
HostFormatType	Host format type enum.
LicenseModel	LicenseModel enum
LongTermBackUpScheduleDetails	Details for the long-term backup schedule.
OpenModeType	Open mode type enum.
OperationsInsightsStatusType	Operations Insights status type enum.
PermissionLevelType	Permission level type enum.
ProfileType	The connection string profile to allow clients to group, filter and select connection string values based on structured metadata.
ProtocolType	Protocol type enum.
RepeatCadenceType	Repeat cadence type enum
RoleType	Role type enum.
ScheduledOperationsType	The list of scheduled operations.
SessionModeType	Session mode type enum.
SyntaxFormatType	Syntax format type enum.
systemData	Metadata pertaining to creation and last modification of the resource.
TlsAuthenticationType	TLS authentication type enum.
WorkloadType	WorkloadType enum

AllConnectionStringType

Object

The connection string profile to allow clients to group, filter and select connection string values based on structured metadata.

Name	Type	Description
high	string minLength: 10 maxLength: 255	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 minLength: 10 maxLength: 255	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 minLength: 10 maxLength: 255	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.

ApexDetailsType

Object

Information about Oracle APEX Application Development.

Name	Type	Description
apexVersion	string	The Oracle APEX Application Development version.
ordsVersion	string	The Oracle REST Data Services (ORDS) version.

AutonomousDatabase

Object

Autonomous Database resource model.

Name	Type	Description
id	string (arm-id)	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
location	string	The geo-location where the resource lives
name	string	The name of the resource
properties.actualUsedDataStorageSizeInTbs	number (double)	The current amount of storage in use for user and system data, in terabytes (TB).
properties.adminPassword	string (password) minLength: 12 maxLength: 30	Admin password.
properties.allocatedStorageSizeInTbs	number (double)	The amount of storage currently allocated for the database tables and billed for, rounded up.
properties.apexDetails	ApexDetailsType	Information about Oracle APEX Application Development.
properties.autonomousDatabaseId	string (arm-id)	Autonomous Database ID
properties.autonomousMaintenanceScheduleType	AutonomousMaintenanceScheduleType	The maintenance schedule type of the Autonomous Database Serverless.
properties.availableUpgradeVersions	string[]	List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.
properties.backupRetentionPeriodInDays	integer (int32)	Retention period, in days, for long-term backups
properties.characterSet	string minLength: 1 maxLength: 255	The character set for the autonomous database.
properties.computeCount	number (float) minimum: 0.1 maximum: 512	The compute amount (CPUs) available to the database.
properties.computeModel	ComputeModel	The compute model of the Autonomous Database.
properties.connectionStrings	ConnectionStringType	The connection string used to connect to the Autonomous Database.
properties.connectionUrls	ConnectionUrlType	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.
properties.cpuCoreCount	integer (int32) minimum: 1 maximum: 128	The number of CPU cores to be made available to the database.
properties.customerContacts	CustomerContact[]	Customer Contacts.
properties.dataBaseType	DataBaseType	Database type to be created.
properties.dataSafeStatus	DataSafeStatusType	Status of the Data Safe registration for this Autonomous Database.
properties.dataStorageSizeInGbs	integer (int32) minimum: 20 maximum: 393216	The size, in gigabytes, of the data volume that will be created and attached to the database.
properties.dataStorageSizeInTbs	integer (int32) minimum: 1 maximum: 384	The quantity of data in the database, in terabytes.
properties.databaseEdition	DatabaseEditionType	The Oracle Database Edition that applies to the Autonomous databases.
properties.dbVersion	string minLength: 1 maxLength: 255	A valid Oracle Database version for Autonomous Database.
properties.dbWorkload	WorkloadType	The Autonomous Database workload type
properties.displayName	string minLength: 1 maxLength: 255	The user-friendly name for the Autonomous Database.
properties.failedDataRecoveryInSeconds	integer (int32)	Indicates the number of seconds of data loss for a Data Guard failover.
properties.inMemoryAreaInGbs	integer (int32)	The area assigned to In-Memory tables in Autonomous Database.
properties.isAutoScalingEnabled	boolean	Indicates if auto scaling is enabled for the Autonomous Database CPU core count.
properties.isAutoScalingForStorageEnabled	boolean	Indicates if auto scaling is enabled for the Autonomous Database storage.
properties.isLocalDataGuardEnabled	boolean	Indicates whether the Autonomous Database has local or called in-region Data Guard enabled.
properties.isMtlsConnectionRequired	boolean	Specifies if the Autonomous Database requires mTLS connections.
properties.isPreview	boolean	Indicates if the Autonomous Database version is a preview version.
properties.isPreviewVersionWithServiceTermsAccepted	boolean	Specifies if the Autonomous Database preview version is being provisioned.
properties.isRemoteDataGuardEnabled	boolean	Indicates whether the Autonomous Database has Cross Region Data Guard enabled.
properties.licenseModel	LicenseModel	The Oracle license model that applies to the Oracle Autonomous Database. The default is LICENSE_INCLUDED.
properties.lifecycleDetails	string	Additional information about the current lifecycle state.
properties.lifecycleState	AutonomousDatabaseLifecycleState	Views lifecycleState
properties.localAdgAutoFailoverMaxDataLossLimit	integer (int32) minimum: 0 maximum: 3600	Parameter that allows users to select an acceptable maximum data loss limit in seconds, up to which Automatic Failover will be triggered when necessary for a Local Autonomous Data Guard
properties.localDisasterRecoveryType	DisasterRecoveryType	Indicates the local disaster recovery (DR) type of the Autonomous Database Serverless instance.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.
properties.localStandbyDb	AutonomousDatabaseStandbySummary	Local Autonomous Disaster Recovery standby database details.
properties.longTermBackupSchedule	LongTermBackUpScheduleDetails	Details for the long-term backup schedule.
properties.memoryPerOracleComputeUnitInGbs	integer (int32)	The amount of memory (in GBs) enabled per ECPU or OCPU.
properties.ncharacterSet	string minLength: 1 maxLength: 255	The character set for the Autonomous Database.
properties.nextLongTermBackupTimeStamp	string (date-time)	The date and time when the next long-term backup would be created.
properties.ociUrl	string	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
properties.ocid	string minLength: 1 maxLength: 255	Database ocid
properties.openMode	OpenModeType	Indicates the Autonomous Database mode.
properties.operationsInsightsStatus	OperationsInsightsStatusType	Status of Operations Insights for this Autonomous Database.
properties.peerDbId	string minLength: 1 maxLength: 255	The Azure resource ID of the Disaster Recovery peer database, which is located in a different region from the current peer database.
properties.peerDbIds	string[]	The list of Azure resource IDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. Note that for Autonomous Database Serverless instances, standby databases located in the same region as the source primary database do not have Azure IDs.
properties.permissionLevel	PermissionLevelType	The Autonomous Database permission level.
properties.privateEndpoint	string	The private endpoint for the resource.
properties.privateEndpointIp	string	The private endpoint Ip address for the resource.
properties.privateEndpointLabel	string	The resource's private endpoint label.
properties.provisionableCpus	integer[] (int32)	An array of CPU values that an Autonomous Database can be scaled to.
properties.provisioningState	AzureResourceProvisioningState	Azure resource provisioning state.
properties.remoteDisasterRecoveryConfiguration	DisasterRecoveryConfigurationDetails	Indicates remote disaster recovery configuration
properties.role	RoleType	The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled.
properties.scheduledOperations	ScheduledOperationsType	The list of scheduled operations.
properties.serviceConsoleUrl	string minLength: 10 maxLength: 255	The URL of the Service Console for the Autonomous Database.
properties.sqlWebDeveloperUrl	string minLength: 10 maxLength: 2048	The SQL Web Developer URL for the Oracle Autonomous Database.
properties.subnetId	string (arm-id)	Client subnet
properties.supportedRegionsToCloneTo	string[]	The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.
properties.timeCreated	string (date-time)	The date and time that the database was created.
properties.timeDataGuardRoleChanged	string	The date and time the Autonomous Data Guard role was switched for the Autonomous Database.
properties.timeDeletionOfFreeAutonomousDatabase	string	The date and time the Always Free database will be automatically deleted because of inactivity.
properties.timeDisasterRecoveryRoleChanged	string (date-time)	The date and time the Disaster Recovery role was switched for the standby Autonomous Database.
properties.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.
properties.timeMaintenanceBegin	string (date-time)	The date and time when maintenance will begin.
properties.timeMaintenanceEnd	string (date-time)	The date and time when maintenance will end.
properties.timeOfLastFailover	string	The timestamp of the last failover operation.
properties.timeOfLastRefresh	string	The date and time when last refresh happened.
properties.timeOfLastRefreshPoint	string	The refresh point timestamp (UTC).
properties.timeOfLastSwitchover	string	The timestamp of the last switchover operation for the Autonomous Database.
properties.timeReclamationOfFreeAutonomousDatabase	string	The date and time the Always Free database will be stopped because of inactivity.
properties.usedDataStorageSizeInGbs	integer (int32)	The storage space consumed by Autonomous Database in GBs.
properties.usedDataStorageSizeInTbs	integer (int32)	The amount of storage that has been used, in terabytes.
properties.vnetId	string (arm-id)	VNET for network connectivity
properties.whitelistedIps	string[] minLength: 1 maxLength: 1024	The client IP access control list (ACL). This is an array of CIDR notations and/or IP addresses. Values should be separate strings, separated by commas. Example: ['1.1.1.1','1.1.1.0/24','1.1.2.25']
systemData	systemData	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

AutonomousDatabaseLifecycleState

Enumeration

Autonomous database lifecycle state enum

Value	Description
Available	Indicates that resource in Available state
AvailableNeedsAttention	Indicates that resource is available but needs attention
BackupInProgress	Indicates that resource in BackupInProgress state
Inaccessible	IIndicates that resource in Inaccessible state
MaintenanceInProgress	Indicates that resource maintenance in progress state
Provisioning	Indicates that resource in Provisioning state
Recreating	Indicates that resource in Recreating state
Restarting	Indicates that resource in Restarting state
RestoreFailed	Indicates that resource in RestoreFailed state
RestoreInProgress	Indicates that resource in RestoreInProgress state
RoleChangeInProgress	Indicates that resource role change in progress state
ScaleInProgress	Indicates that resource in ScaleInProgress state
Standby	Indicates that resource in Standby state
Starting	Indicates that resource in Starting state
Stopped	Indicates that resource in Stopped state
Stopping	Indicates that resource in Stopping state
Terminated	Indicates that resource in Terminated state
Terminating	Indicates that resource in Terminating state
Unavailable	Indicates that resource in Unavailable state
Updating	Indicates that resource in Updating state
Upgrading	Indicates that resource in Upgrading state

AutonomousDatabaseStandbySummary

Object

Autonomous Disaster Recovery standby database details.

Name	Type	Description
lagTimeInSeconds	integer (int32)	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.
lifecycleState	AutonomousDatabaseLifecycleState	The current state of the Autonomous Database.
timeDataGuardRoleChanged	string	The date and time the Autonomous Data Guard role was switched for the standby Autonomous Database.
timeDisasterRecoveryRoleChanged	string	The date and time the Disaster Recovery role was switched for the standby Autonomous Database.

AutonomousMaintenanceScheduleType

Enumeration

Autonomous database maintenance schedule type enum.

Value	Description
Early	Early maintenance schedule
Regular	Regular maintenance schedule

AzureResourceProvisioningState

Enumeration

Azure Resource Provisioning State enum

Value	Description
Canceled	Resource creation was canceled.
Failed	Resource creation failed.
Provisioning	Indicates that resource in Provisioning state
Succeeded	Resource has been created.

ComputeModel

Enumeration

Compute model enum

Value	Description
ECPU	ECPU model type
OCPU	OCPU model type

ConnectionStringType

Object

Connection strings to connect to an Oracle Autonomous Database.

Name	Type	Description
allConnectionStrings	AllConnectionStringType	Returns all connection strings that can be used to connect to the Autonomous Database.
dedicated	string minLength: 10 maxLength: 255	The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements.
high	string minLength: 10 maxLength: 255	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 minLength: 10 maxLength: 255	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 minLength: 10 maxLength: 255	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	ProfileType[]	A list of connection string profiles to allow clients to group, filter and select connection string values based on structured metadata.

ConnectionUrlType

Object

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.

Name	Type	Description
apexUrl	string minLength: 10 maxLength: 512	Oracle Application Express (APEX) URL.
databaseTransformsUrl	string minLength: 10 maxLength: 512	The URL of the Database Transforms for the Autonomous Database.
graphStudioUrl	string minLength: 10 maxLength: 512	The URL of the Graph Studio for the Autonomous Database.
machineLearningNotebookUrl	string minLength: 10 maxLength: 512	The URL of the Oracle Machine Learning (OML) Notebook for the Autonomous Database.
mongoDbUrl	string minLength: 10 maxLength: 512	The URL of the MongoDB API for the Autonomous Database.
ordsUrl	string minLength: 10 maxLength: 512	The Oracle REST Data Services (ORDS) URL of the Web Access for the Autonomous Database.
sqlDevWebUrl	string minLength: 10 maxLength: 512	Oracle SQL Developer Web URL.

ConsumerGroup

Enumeration

Consumer group enum.

Value	Description
High	High group
Low	Low group
Medium	Medium group
Tp	TP group
Tpurgent	TPurgent group

createdByType

Enumeration

The type of identity that created the resource.

Value	Description
Application
Key
ManagedIdentity
User

CustomerContact

Object

CustomerContact resource properties

Name	Type	Description
email	string minLength: 1 maxLength: 320	The email address used by Oracle to send notifications regarding databases and infrastructure.

DatabaseEditionType

Enumeration

Database edition type enum.

Value	Description
EnterpriseEdition	Enterprise edition
StandardEdition	Standard edition

DataBaseType

Enumeration

Database type enum

Value	Description
Clone	Clone DB
CloneFromBackupTimestamp	Clone DB from backup timestamp
CrossRegionDisasterRecovery	Cross Region Disaster Recovery
Regular	Regular DB

DataSafeStatusType

Enumeration

DataSafe status type enum.

Value	Description
Deregistering	Deregistering status
Failed	Failed status
NotRegistered	NotRegistered status
Registered	Registered status
Registering	Registering status

DayOfWeek

Object

DayOfWeek resource properties

Name	Type	Description
name	DayOfWeekName	Name of the day of the week.

DayOfWeekName

Enumeration

DayOfWeekName enum

Value	Description
Friday	Friday value
Monday	Monday value
Saturday	Saturday value
Sunday	Sunday value
Thursday	Thursday value
Tuesday	Tuesday value
Wednesday	Wednesday value

DisasterRecoveryConfigurationDetails

Object

Configurations of a Disaster Recovery Details

Name	Type	Description
disasterRecoveryType	DisasterRecoveryType	Indicates the disaster recovery (DR) type of the Autonomous Database Serverless instance. 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.
isReplicateAutomaticBackups	boolean	If true, 7 days worth of backups are replicated across regions for Cross-Region ADB or Backup-Based DR between Primary and Standby. If false, the backups taken on the Primary are not replicated to the Standby database.
isSnapshotStandby	boolean	Indicates if user wants to convert to a snapshot standby. For example, true would set a standby database to snapshot standby database. False would set a snapshot standby database back to regular standby database.
timeSnapshotStandbyEnabledTill	string (date-time)	Time and date stored as an RFC 3339 formatted timestamp string. For example, 2022-01-01T12:00:00.000Z would set a limit for the snapshot standby to be converted back to a cross-region standby database.

DisasterRecoveryType

Enumeration

Disaster recovery type enum.

Value	Description
Adg	ADG type
BackupBased	Backup based type

ErrorAdditionalInfo

Object

The resource management error additional info.

Name	Type	Description
info	object	The additional info.
type	string	The additional info type.

ErrorDetail

Object

The error detail.

Name	Type	Description
additionalInfo	ErrorAdditionalInfo[]	The error additional info.
code	string	The error code.
details	ErrorDetail[]	The error details.
message	string	The error message.
target	string	The error target.

ErrorResponse

Object

Error response

Name	Type	Description
error	ErrorDetail	The error object.

HostFormatType

Enumeration

Host format type enum.

Value	Description
Fqdn	FQDN format
Ip	IP format

LicenseModel

Enumeration

LicenseModel enum

Value	Description
BringYourOwnLicense	Bring Your Own License
LicenseIncluded	License included

LongTermBackUpScheduleDetails

Object

Details for the long-term backup schedule.

Name	Type	Description
isDisabled	boolean	Indicates if the long-term backup schedule should be deleted. The default value is `FALSE`.
repeatCadence	RepeatCadenceType	The frequency of the long-term backup schedule
retentionPeriodInDays	integer (int32) minimum: 90 maximum: 2558	Retention period, in days, for backups.
timeOfBackup	string (date-time)	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.

OpenModeType

Enumeration

Open mode type enum.

Value	Description
ReadOnly	ReadOnly mode
ReadWrite	ReadWrite mode

OperationsInsightsStatusType

Enumeration

Operations Insights status type enum.

Value	Description
Disabling	Disabling status
Enabled	Enabled status
Enabling	Enabling status
FailedDisabling	FailedDisabling status
FailedEnabling	FailedEnabling status
NotEnabled	NotEnabled status

PermissionLevelType

Enumeration

Permission level type enum.

Value	Description
Restricted	Restricted permission level
Unrestricted	Unrestricted permission level

ProfileType

Object

The connection string profile to allow clients to group, filter and select connection string values based on structured metadata.

Name	Type	Description
consumerGroup	ConsumerGroup	Consumer group used by the connection.
displayName	string minLength: 1 maxLength: 255	A user-friendly name for the connection.
hostFormat	HostFormatType	Host format used in connection string.
isRegional	boolean	True for a regional connection string, applicable to cross-region DG only.
protocol	ProtocolType	Protocol used by the connection.
sessionMode	SessionModeType	Specifies whether the listener performs a direct hand-off of the session, or redirects the session.
syntaxFormat	SyntaxFormatType	Specifies whether the connection string is using the long (LONG), Easy Connect (EZCONNECT), or Easy Connect Plus (EZCONNECTPLUS) format.
tlsAuthentication	TlsAuthenticationType	Specifies whether the TLS handshake is using one-way (SERVER) or mutual (MUTUAL) authentication.
value	string	Connection string value.

ProtocolType

Enumeration

Protocol type enum.

Value	Description
TCP	TCP protocol
TCPS	TCPS protocol

RepeatCadenceType

Enumeration

Repeat cadence type enum

Value	Description
Monthly	Repeat monthly
OneTime	Repeat one time
Weekly	Repeat weekly
Yearly	Repeat yearly

RoleType

Enumeration

Role type enum.

Value	Description
BackupCopy	BackupCopy role
DisabledStandby	DisabledStandby role
Primary	Primary role
SnapshotStandby	SnapshotStandby role
Standby	Standby role

ScheduledOperationsType

Object

The list of scheduled operations.

Name	Type	Description
dayOfWeek	DayOfWeek	Day of week
scheduledStartTime	string minLength: 1 maxLength: 50	auto start time. value must be of ISO-8601 format HH:mm
scheduledStopTime	string minLength: 1 maxLength: 50	auto stop time. value must be of ISO-8601 format HH:mm

SessionModeType

Enumeration

Session mode type enum.

Value	Description
Direct	Direct session mode
Redirect	Redirect session mode

SyntaxFormatType

Enumeration

Syntax format type enum.

Value	Description
Ezconnect	Ezconnect format
Ezconnectplus	Ezconnectplus format
Long	Long format

systemData

Object

Metadata pertaining to creation and last modification of the resource.

Name	Type	Description
createdAt	string (date-time)	The timestamp of resource creation (UTC).
createdBy	string	The identity that created the resource.
createdByType	createdByType	The type of identity that created the resource.
lastModifiedAt	string (date-time)	The timestamp of resource last modification (UTC)
lastModifiedBy	string	The identity that last modified the resource.
lastModifiedByType	createdByType	The type of identity that last modified the resource.

TlsAuthenticationType

Enumeration

TLS authentication type enum.

Value	Description
Mutual	Mutual TLS
Server	Server authentication

WorkloadType

Enumeration

WorkloadType enum

Value	Description
AJD	AJD - indicates an Autonomous JSON Database
APEX	APEX - indicates an Autonomous Database with the Oracle APEX Application Development workload type.
DW	DW - indicates an Autonomous Data Warehouse database
OLTP	OLTP - indicates an Autonomous Transaction Processing database

Share via

Autonomous Databases - Create Or Update

URI Parameters

Request Body

Responses

Security

azure_auth

Scopes

Examples

AutonomousDatabases_CreateOrUpdate

Sample request

Sample response

AutonomousDatabases_CreateOrUpdate_clone

Sample request

Sample response

AutonomousDatabases_CreateOrUpdate_CrossRegionPeer

Sample request

Sample response

Create Autonomous Database

Sample request

Sample response

Create clone Autonomous Database

Sample request

Sample response

Definitions

AllConnectionStringType

ApexDetailsType

AutonomousDatabase

AutonomousDatabaseLifecycleState

AutonomousDatabaseStandbySummary

AutonomousMaintenanceScheduleType

AzureResourceProvisioningState

ComputeModel

ConnectionStringType

ConnectionUrlType

ConsumerGroup

createdByType

CustomerContact

DatabaseEditionType

DataBaseType

DataSafeStatusType

DayOfWeek

DayOfWeekName

DisasterRecoveryConfigurationDetails

DisasterRecoveryType

ErrorAdditionalInfo

ErrorDetail

ErrorResponse

HostFormatType

LicenseModel

LongTermBackUpScheduleDetails

OpenModeType

OperationsInsightsStatusType

PermissionLevelType

ProfileType

ProtocolType

RepeatCadenceType

RoleType

ScheduledOperationsType

SessionModeType

SyntaxFormatType

systemData

TlsAuthenticationType

WorkloadType