autonomous_databases

Creates, updates, deletes, gets or lists an autonomous_databases resource.

Overview

Name	autonomous_databases
Type	Resource
Id	azure_isv.oracledatabase.autonomous_databases

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
actualUsedDataStorageSizeInTbs	number	The current amount of storage in use for user and system data, in terabytes (TB).
adminPassword	string	Admin password.
allocatedStorageSizeInTbs	number	The amount of storage currently allocated for the database tables and billed for, rounded up.
apexDetails	object	Information about Oracle APEX Application Development.
autonomousDatabaseId	string	Autonomous Database ID.
autonomousMaintenanceScheduleType	string	The maintenance schedule type of the Autonomous Database Serverless. Known values are: "Early" and "Regular". (Early, Regular)
availableUpgradeVersions	array	List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.
backupRetentionPeriodInDays	integer	Retention period, in days, for long-term backups.
characterSet	string	The character set for the autonomous database.
computeCount	number	The compute amount (CPUs) available to the database.
computeModel	string	The compute model of the Autonomous Database. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
connectionStrings	object	The connection string used to connect to the Autonomous Database.
connectionUrls	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.
cpuCoreCount	integer	The number of CPU cores to be made available to the database.
customerContacts	array	Customer Contacts.
dataBaseType	string	Database type to be created. Required. Known values are: "Regular", "Clone", "CloneFromBackupTimestamp", and "CrossRegionDisasterRecovery".
dataSafeStatus	string	Status of the Data Safe registration for this Autonomous Database. Known values are: "Registering", "Registered", "Deregistering", "NotRegistered", and "Failed". (Registering, Registered, Deregistering, NotRegistered, Failed)
dataStorageSizeInGbs	integer	The size, in gigabytes, of the data volume that will be created and attached to the database.
dataStorageSizeInTbs	integer	The quantity of data in the database, in terabytes.
databaseEdition	string	The Oracle Database Edition that applies to the Autonomous databases. Known values are: "StandardEdition" and "EnterpriseEdition". (StandardEdition, EnterpriseEdition)
dbVersion	string	A valid Oracle Database version for Autonomous Database.
dbWorkload	string	The Autonomous Database workload type. Known values are: "OLTP", "DW", "AJD", and "APEX". (OLTP, DW, AJD, APEX)
displayName	string	The user-friendly name for the Autonomous Database.
failedDataRecoveryInSeconds	integer	Indicates the number of seconds of data loss for a Data Guard failover.
inMemoryAreaInGbs	integer	The area assigned to In-Memory tables in Autonomous Database.
isAutoScalingEnabled	boolean	Indicates if auto scaling is enabled for the Autonomous Database CPU core count.
isAutoScalingForStorageEnabled	boolean	Indicates if auto scaling is enabled for the Autonomous Database storage.
isLocalDataGuardEnabled	boolean	Indicates whether the Autonomous Database has local or called in-region Data Guard enabled.
isMtlsConnectionRequired	boolean	Specifies if the Autonomous Database requires mTLS connections.
isPreview	boolean	Indicates if the Autonomous Database version is a preview version.
isPreviewVersionWithServiceTermsAccepted	boolean	Specifies if the Autonomous Database preview version is being provisioned.
isRemoteDataGuardEnabled	boolean	Indicates whether the Autonomous Database has Cross Region Data Guard enabled.
licenseModel	string	The Oracle license model that applies to the Oracle Autonomous Database. The default is LICENSE_INCLUDED. Known values are: "LicenseIncluded" and "BringYourOwnLicense". (LicenseIncluded, BringYourOwnLicense)
lifecycleDetails	string	Additional information about the current lifecycle state.
lifecycleState	string	Views lifecycleState. Known values are: "Provisioning", "Available", "Stopping", "Stopped", "Starting", "Terminating", "Terminated", "Unavailable", "RestoreInProgress", "RestoreFailed", "BackupInProgress", "ScaleInProgress", "AvailableNeedsAttention", "Updating", "MaintenanceInProgress", "Restarting", "Recreating", "RoleChangeInProgress", "Upgrading", "Inaccessible", and "Standby". (Provisioning, Available, Stopping, Stopped, Starting, Terminating, Terminated, Unavailable, RestoreInProgress, RestoreFailed, BackupInProgress, ScaleInProgress, AvailableNeedsAttention, Updating, MaintenanceInProgress, Restarting, Recreating, RoleChangeInProgress, Upgrading, Inaccessible, Standby)
localAdgAutoFailoverMaxDataLossLimit	integer	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.
localDisasterRecoveryType	string	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. Known values are: "Adg" and "BackupBased". (Adg, BackupBased)
localStandbyDb	object	Local Autonomous Disaster Recovery standby database details.
location	string	The geo-location where the resource lives. Required.
longTermBackupSchedule	object	Details for the long-term backup schedule.
memoryPerOracleComputeUnitInGbs	integer	The amount of memory (in GBs) enabled per ECPU or OCPU.
ncharacterSet	string	The character set for the Autonomous Database.
nextLongTermBackupTimeStamp	string (date-time)	The date and time when the next long-term backup would be created.
ociUrl	string	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
ocid	string	Database ocid.
openMode	string	Indicates the Autonomous Database mode. Known values are: "ReadOnly" and "ReadWrite". (ReadOnly, ReadWrite)
operationsInsightsStatus	string	Status of Operations Insights for this Autonomous Database. Known values are: "Enabling", "Enabled", "Disabling", "NotEnabled", "FailedEnabling", and "FailedDisabling". (Enabling, Enabled, Disabling, NotEnabled, FailedEnabling, FailedDisabling)
peerDbId	string	The Azure resource ID of the Disaster Recovery peer database, which is located in a different region from the current peer database.
peerDbIds	array	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.
permissionLevel	string	The Autonomous Database permission level. Known values are: "Restricted" and "Unrestricted". (Restricted, Unrestricted)
privateEndpoint	string	The private endpoint for the resource.
privateEndpointIp	string	The private endpoint Ip address for the resource.
privateEndpointLabel	string	The resource's private endpoint label.
provisionableCpus	array	An array of CPU values that an Autonomous Database can be scaled to.
provisioningState	string	Azure resource provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
remoteDisasterRecoveryConfiguration	object	Indicates remote disaster recovery configuration.
role	string	The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled. Known values are: "Primary", "Standby", "DisabledStandby", "BackupCopy", and "SnapshotStandby". (Primary, Standby, DisabledStandby, BackupCopy, SnapshotStandby)
scheduledOperationsList	array	The list of scheduled operations.
serviceConsoleUrl	string	The URL of the Service Console for the Autonomous Database.
sqlWebDeveloperUrl	string	The SQL Web Developer URL for the Oracle Autonomous Database.
subnetId	string	Client subnet.
supportedRegionsToCloneTo	array	The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
timeCreated	string (date-time)	The date and time that the database was created.
timeDataGuardRoleChanged	string	The date and time the Autonomous Data Guard role was switched for the Autonomous Database.
timeDeletionOfFreeAutonomousDatabase	string	The date and time the Always Free database will be automatically deleted because of inactivity.
timeDisasterRecoveryRoleChanged	string (date-time)	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 (date-time)	The date and time when maintenance will begin.
timeMaintenanceEnd	string (date-time)	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).
timeOfLastSwitchover	string	The timestamp of the last switchover operation for the Autonomous Database.
timeReclamationOfFreeAutonomousDatabase	string	The date and time the Always Free database will be stopped because of inactivity.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
usedDataStorageSizeInGbs	integer	The storage space consumed by Autonomous Database in GBs.
usedDataStorageSizeInTbs	integer	The amount of storage that has been used, in terabytes.
vnetId	string	VNET for network connectivity.
whitelistedIps	array	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'].

list_by_resource_group

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
actualUsedDataStorageSizeInTbs	number	The current amount of storage in use for user and system data, in terabytes (TB).
adminPassword	string	Admin password.
allocatedStorageSizeInTbs	number	The amount of storage currently allocated for the database tables and billed for, rounded up.
apexDetails	object	Information about Oracle APEX Application Development.
autonomousDatabaseId	string	Autonomous Database ID.
autonomousMaintenanceScheduleType	string	The maintenance schedule type of the Autonomous Database Serverless. Known values are: "Early" and "Regular". (Early, Regular)
availableUpgradeVersions	array	List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.
backupRetentionPeriodInDays	integer	Retention period, in days, for long-term backups.
characterSet	string	The character set for the autonomous database.
computeCount	number	The compute amount (CPUs) available to the database.
computeModel	string	The compute model of the Autonomous Database. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
connectionStrings	object	The connection string used to connect to the Autonomous Database.
connectionUrls	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.
cpuCoreCount	integer	The number of CPU cores to be made available to the database.
customerContacts	array	Customer Contacts.
dataBaseType	string	Database type to be created. Required. Known values are: "Regular", "Clone", "CloneFromBackupTimestamp", and "CrossRegionDisasterRecovery".
dataSafeStatus	string	Status of the Data Safe registration for this Autonomous Database. Known values are: "Registering", "Registered", "Deregistering", "NotRegistered", and "Failed". (Registering, Registered, Deregistering, NotRegistered, Failed)
dataStorageSizeInGbs	integer	The size, in gigabytes, of the data volume that will be created and attached to the database.
dataStorageSizeInTbs	integer	The quantity of data in the database, in terabytes.
databaseEdition	string	The Oracle Database Edition that applies to the Autonomous databases. Known values are: "StandardEdition" and "EnterpriseEdition". (StandardEdition, EnterpriseEdition)
dbVersion	string	A valid Oracle Database version for Autonomous Database.
dbWorkload	string	The Autonomous Database workload type. Known values are: "OLTP", "DW", "AJD", and "APEX". (OLTP, DW, AJD, APEX)
displayName	string	The user-friendly name for the Autonomous Database.
failedDataRecoveryInSeconds	integer	Indicates the number of seconds of data loss for a Data Guard failover.
inMemoryAreaInGbs	integer	The area assigned to In-Memory tables in Autonomous Database.
isAutoScalingEnabled	boolean	Indicates if auto scaling is enabled for the Autonomous Database CPU core count.
isAutoScalingForStorageEnabled	boolean	Indicates if auto scaling is enabled for the Autonomous Database storage.
isLocalDataGuardEnabled	boolean	Indicates whether the Autonomous Database has local or called in-region Data Guard enabled.
isMtlsConnectionRequired	boolean	Specifies if the Autonomous Database requires mTLS connections.
isPreview	boolean	Indicates if the Autonomous Database version is a preview version.
isPreviewVersionWithServiceTermsAccepted	boolean	Specifies if the Autonomous Database preview version is being provisioned.
isRemoteDataGuardEnabled	boolean	Indicates whether the Autonomous Database has Cross Region Data Guard enabled.
licenseModel	string	The Oracle license model that applies to the Oracle Autonomous Database. The default is LICENSE_INCLUDED. Known values are: "LicenseIncluded" and "BringYourOwnLicense". (LicenseIncluded, BringYourOwnLicense)
lifecycleDetails	string	Additional information about the current lifecycle state.
lifecycleState	string	Views lifecycleState. Known values are: "Provisioning", "Available", "Stopping", "Stopped", "Starting", "Terminating", "Terminated", "Unavailable", "RestoreInProgress", "RestoreFailed", "BackupInProgress", "ScaleInProgress", "AvailableNeedsAttention", "Updating", "MaintenanceInProgress", "Restarting", "Recreating", "RoleChangeInProgress", "Upgrading", "Inaccessible", and "Standby". (Provisioning, Available, Stopping, Stopped, Starting, Terminating, Terminated, Unavailable, RestoreInProgress, RestoreFailed, BackupInProgress, ScaleInProgress, AvailableNeedsAttention, Updating, MaintenanceInProgress, Restarting, Recreating, RoleChangeInProgress, Upgrading, Inaccessible, Standby)
localAdgAutoFailoverMaxDataLossLimit	integer	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.
localDisasterRecoveryType	string	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. Known values are: "Adg" and "BackupBased". (Adg, BackupBased)
localStandbyDb	object	Local Autonomous Disaster Recovery standby database details.
location	string	The geo-location where the resource lives. Required.
longTermBackupSchedule	object	Details for the long-term backup schedule.
memoryPerOracleComputeUnitInGbs	integer	The amount of memory (in GBs) enabled per ECPU or OCPU.
ncharacterSet	string	The character set for the Autonomous Database.
nextLongTermBackupTimeStamp	string (date-time)	The date and time when the next long-term backup would be created.
ociUrl	string	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
ocid	string	Database ocid.
openMode	string	Indicates the Autonomous Database mode. Known values are: "ReadOnly" and "ReadWrite". (ReadOnly, ReadWrite)
operationsInsightsStatus	string	Status of Operations Insights for this Autonomous Database. Known values are: "Enabling", "Enabled", "Disabling", "NotEnabled", "FailedEnabling", and "FailedDisabling". (Enabling, Enabled, Disabling, NotEnabled, FailedEnabling, FailedDisabling)
peerDbId	string	The Azure resource ID of the Disaster Recovery peer database, which is located in a different region from the current peer database.
peerDbIds	array	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.
permissionLevel	string	The Autonomous Database permission level. Known values are: "Restricted" and "Unrestricted". (Restricted, Unrestricted)
privateEndpoint	string	The private endpoint for the resource.
privateEndpointIp	string	The private endpoint Ip address for the resource.
privateEndpointLabel	string	The resource's private endpoint label.
provisionableCpus	array	An array of CPU values that an Autonomous Database can be scaled to.
provisioningState	string	Azure resource provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
remoteDisasterRecoveryConfiguration	object	Indicates remote disaster recovery configuration.
role	string	The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled. Known values are: "Primary", "Standby", "DisabledStandby", "BackupCopy", and "SnapshotStandby". (Primary, Standby, DisabledStandby, BackupCopy, SnapshotStandby)
scheduledOperationsList	array	The list of scheduled operations.
serviceConsoleUrl	string	The URL of the Service Console for the Autonomous Database.
sqlWebDeveloperUrl	string	The SQL Web Developer URL for the Oracle Autonomous Database.
subnetId	string	Client subnet.
supportedRegionsToCloneTo	array	The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
timeCreated	string (date-time)	The date and time that the database was created.
timeDataGuardRoleChanged	string	The date and time the Autonomous Data Guard role was switched for the Autonomous Database.
timeDeletionOfFreeAutonomousDatabase	string	The date and time the Always Free database will be automatically deleted because of inactivity.
timeDisasterRecoveryRoleChanged	string (date-time)	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 (date-time)	The date and time when maintenance will begin.
timeMaintenanceEnd	string (date-time)	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).
timeOfLastSwitchover	string	The timestamp of the last switchover operation for the Autonomous Database.
timeReclamationOfFreeAutonomousDatabase	string	The date and time the Always Free database will be stopped because of inactivity.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
usedDataStorageSizeInGbs	integer	The storage space consumed by Autonomous Database in GBs.
usedDataStorageSizeInTbs	integer	The amount of storage that has been used, in terabytes.
vnetId	string	VNET for network connectivity.
whitelistedIps	array	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'].

list_by_subscription

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
actualUsedDataStorageSizeInTbs	number	The current amount of storage in use for user and system data, in terabytes (TB).
adminPassword	string	Admin password.
allocatedStorageSizeInTbs	number	The amount of storage currently allocated for the database tables and billed for, rounded up.
apexDetails	object	Information about Oracle APEX Application Development.
autonomousDatabaseId	string	Autonomous Database ID.
autonomousMaintenanceScheduleType	string	The maintenance schedule type of the Autonomous Database Serverless. Known values are: "Early" and "Regular". (Early, Regular)
availableUpgradeVersions	array	List of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.
backupRetentionPeriodInDays	integer	Retention period, in days, for long-term backups.
characterSet	string	The character set for the autonomous database.
computeCount	number	The compute amount (CPUs) available to the database.
computeModel	string	The compute model of the Autonomous Database. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
connectionStrings	object	The connection string used to connect to the Autonomous Database.
connectionUrls	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.
cpuCoreCount	integer	The number of CPU cores to be made available to the database.
customerContacts	array	Customer Contacts.
dataBaseType	string	Database type to be created. Required. Known values are: "Regular", "Clone", "CloneFromBackupTimestamp", and "CrossRegionDisasterRecovery".
dataSafeStatus	string	Status of the Data Safe registration for this Autonomous Database. Known values are: "Registering", "Registered", "Deregistering", "NotRegistered", and "Failed". (Registering, Registered, Deregistering, NotRegistered, Failed)
dataStorageSizeInGbs	integer	The size, in gigabytes, of the data volume that will be created and attached to the database.
dataStorageSizeInTbs	integer	The quantity of data in the database, in terabytes.
databaseEdition	string	The Oracle Database Edition that applies to the Autonomous databases. Known values are: "StandardEdition" and "EnterpriseEdition". (StandardEdition, EnterpriseEdition)
dbVersion	string	A valid Oracle Database version for Autonomous Database.
dbWorkload	string	The Autonomous Database workload type. Known values are: "OLTP", "DW", "AJD", and "APEX". (OLTP, DW, AJD, APEX)
displayName	string	The user-friendly name for the Autonomous Database.
failedDataRecoveryInSeconds	integer	Indicates the number of seconds of data loss for a Data Guard failover.
inMemoryAreaInGbs	integer	The area assigned to In-Memory tables in Autonomous Database.
isAutoScalingEnabled	boolean	Indicates if auto scaling is enabled for the Autonomous Database CPU core count.
isAutoScalingForStorageEnabled	boolean	Indicates if auto scaling is enabled for the Autonomous Database storage.
isLocalDataGuardEnabled	boolean	Indicates whether the Autonomous Database has local or called in-region Data Guard enabled.
isMtlsConnectionRequired	boolean	Specifies if the Autonomous Database requires mTLS connections.
isPreview	boolean	Indicates if the Autonomous Database version is a preview version.
isPreviewVersionWithServiceTermsAccepted	boolean	Specifies if the Autonomous Database preview version is being provisioned.
isRemoteDataGuardEnabled	boolean	Indicates whether the Autonomous Database has Cross Region Data Guard enabled.
licenseModel	string	The Oracle license model that applies to the Oracle Autonomous Database. The default is LICENSE_INCLUDED. Known values are: "LicenseIncluded" and "BringYourOwnLicense". (LicenseIncluded, BringYourOwnLicense)
lifecycleDetails	string	Additional information about the current lifecycle state.
lifecycleState	string	Views lifecycleState. Known values are: "Provisioning", "Available", "Stopping", "Stopped", "Starting", "Terminating", "Terminated", "Unavailable", "RestoreInProgress", "RestoreFailed", "BackupInProgress", "ScaleInProgress", "AvailableNeedsAttention", "Updating", "MaintenanceInProgress", "Restarting", "Recreating", "RoleChangeInProgress", "Upgrading", "Inaccessible", and "Standby". (Provisioning, Available, Stopping, Stopped, Starting, Terminating, Terminated, Unavailable, RestoreInProgress, RestoreFailed, BackupInProgress, ScaleInProgress, AvailableNeedsAttention, Updating, MaintenanceInProgress, Restarting, Recreating, RoleChangeInProgress, Upgrading, Inaccessible, Standby)
localAdgAutoFailoverMaxDataLossLimit	integer	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.
localDisasterRecoveryType	string	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. Known values are: "Adg" and "BackupBased". (Adg, BackupBased)
localStandbyDb	object	Local Autonomous Disaster Recovery standby database details.
location	string	The geo-location where the resource lives. Required.
longTermBackupSchedule	object	Details for the long-term backup schedule.
memoryPerOracleComputeUnitInGbs	integer	The amount of memory (in GBs) enabled per ECPU or OCPU.
ncharacterSet	string	The character set for the Autonomous Database.
nextLongTermBackupTimeStamp	string (date-time)	The date and time when the next long-term backup would be created.
ociUrl	string	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
ocid	string	Database ocid.
openMode	string	Indicates the Autonomous Database mode. Known values are: "ReadOnly" and "ReadWrite". (ReadOnly, ReadWrite)
operationsInsightsStatus	string	Status of Operations Insights for this Autonomous Database. Known values are: "Enabling", "Enabled", "Disabling", "NotEnabled", "FailedEnabling", and "FailedDisabling". (Enabling, Enabled, Disabling, NotEnabled, FailedEnabling, FailedDisabling)
peerDbId	string	The Azure resource ID of the Disaster Recovery peer database, which is located in a different region from the current peer database.
peerDbIds	array	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.
permissionLevel	string	The Autonomous Database permission level. Known values are: "Restricted" and "Unrestricted". (Restricted, Unrestricted)
privateEndpoint	string	The private endpoint for the resource.
privateEndpointIp	string	The private endpoint Ip address for the resource.
privateEndpointLabel	string	The resource's private endpoint label.
provisionableCpus	array	An array of CPU values that an Autonomous Database can be scaled to.
provisioningState	string	Azure resource provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
remoteDisasterRecoveryConfiguration	object	Indicates remote disaster recovery configuration.
role	string	The Data Guard role of the Autonomous Container Database or Autonomous Database, if Autonomous Data Guard is enabled. Known values are: "Primary", "Standby", "DisabledStandby", "BackupCopy", and "SnapshotStandby". (Primary, Standby, DisabledStandby, BackupCopy, SnapshotStandby)
scheduledOperationsList	array	The list of scheduled operations.
serviceConsoleUrl	string	The URL of the Service Console for the Autonomous Database.
sqlWebDeveloperUrl	string	The SQL Web Developer URL for the Oracle Autonomous Database.
subnetId	string	Client subnet.
supportedRegionsToCloneTo	array	The list of regions that support the creation of an Autonomous Database clone or an Autonomous Data Guard standby database.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
timeCreated	string (date-time)	The date and time that the database was created.
timeDataGuardRoleChanged	string	The date and time the Autonomous Data Guard role was switched for the Autonomous Database.
timeDeletionOfFreeAutonomousDatabase	string	The date and time the Always Free database will be automatically deleted because of inactivity.
timeDisasterRecoveryRoleChanged	string (date-time)	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 (date-time)	The date and time when maintenance will begin.
timeMaintenanceEnd	string (date-time)	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).
timeOfLastSwitchover	string	The timestamp of the last switchover operation for the Autonomous Database.
timeReclamationOfFreeAutonomousDatabase	string	The date and time the Always Free database will be stopped because of inactivity.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
usedDataStorageSizeInGbs	integer	The storage space consumed by Autonomous Database in GBs.
usedDataStorageSizeInTbs	integer	The amount of storage that has been used, in terabytes.
vnetId	string	VNET for network connectivity.
whitelistedIps	array	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'].

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, autonomousdatabasename, subscription_id		Get a AutonomousDatabase.
list_by_resource_group	select	resource_group_name, subscription_id		List AutonomousDatabase resources by resource group.
list_by_subscription	select	subscription_id		List AutonomousDatabase resources by subscription ID.
create_or_update	insert	resource_group_name, autonomousdatabasename, subscription_id, location		Create a AutonomousDatabase.
update	update	resource_group_name, autonomousdatabasename, subscription_id		Update a AutonomousDatabase.
create_or_update	replace	resource_group_name, autonomousdatabasename, subscription_id, location		Create a AutonomousDatabase.
delete	delete	resource_group_name, autonomousdatabasename, subscription_id		Delete a AutonomousDatabase.
switchover	exec	resource_group_name, autonomousdatabasename, subscription_id		Perform switchover action on Autonomous Database.
failover	exec	resource_group_name, autonomousdatabasename, subscription_id		Perform failover action on Autonomous Database.
generate_wallet	exec	resource_group_name, autonomousdatabasename, subscription_id, password		Generate wallet action on Autonomous Database.
restore	exec	resource_group_name, autonomousdatabasename, subscription_id, timestamp		Restores an Autonomous Database based on the provided request parameters.
shrink	exec	resource_group_name, autonomousdatabasename, subscription_id		This operation shrinks the current allocated storage down to the current actual used data storage.
change_disaster_recovery_configuration	exec	resource_group_name, autonomousdatabasename, subscription_id		Perform ChangeDisasterRecoveryConfiguration action on Autonomous Database.
action	exec	resource_group_name, autonomousdatabasename, subscription_id, action		Perform Lifecycle Management Action on Autonomous Database.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
autonomousdatabasename	string	The database name. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
subscription_id	string

SELECT examples

get

Get a AutonomousDatabase.

SELECT
id,
name,
actualUsedDataStorageSizeInTbs,
adminPassword,
allocatedStorageSizeInTbs,
apexDetails,
autonomousDatabaseId,
autonomousMaintenanceScheduleType,
availableUpgradeVersions,
backupRetentionPeriodInDays,
characterSet,
computeCount,
computeModel,
connectionStrings,
connectionUrls,
cpuCoreCount,
customerContacts,
dataBaseType,
dataSafeStatus,
dataStorageSizeInGbs,
dataStorageSizeInTbs,
databaseEdition,
dbVersion,
dbWorkload,
displayName,
failedDataRecoveryInSeconds,
inMemoryAreaInGbs,
isAutoScalingEnabled,
isAutoScalingForStorageEnabled,
isLocalDataGuardEnabled,
isMtlsConnectionRequired,
isPreview,
isPreviewVersionWithServiceTermsAccepted,
isRemoteDataGuardEnabled,
licenseModel,
lifecycleDetails,
lifecycleState,
localAdgAutoFailoverMaxDataLossLimit,
localDisasterRecoveryType,
localStandbyDb,
location,
longTermBackupSchedule,
memoryPerOracleComputeUnitInGbs,
ncharacterSet,
nextLongTermBackupTimeStamp,
ociUrl,
ocid,
openMode,
operationsInsightsStatus,
peerDbId,
peerDbIds,
permissionLevel,
privateEndpoint,
privateEndpointIp,
privateEndpointLabel,
provisionableCpus,
provisioningState,
remoteDisasterRecoveryConfiguration,
role,
scheduledOperationsList,
serviceConsoleUrl,
sqlWebDeveloperUrl,
subnetId,
supportedRegionsToCloneTo,
systemData,
tags,
timeCreated,
timeDataGuardRoleChanged,
timeDeletionOfFreeAutonomousDatabase,
timeDisasterRecoveryRoleChanged,
timeLocalDataGuardEnabled,
timeMaintenanceBegin,
timeMaintenanceEnd,
timeOfLastFailover,
timeOfLastRefresh,
timeOfLastRefreshPoint,
timeOfLastSwitchover,
timeReclamationOfFreeAutonomousDatabase,
type,
usedDataStorageSizeInGbs,
usedDataStorageSizeInTbs,
vnetId,
whitelistedIps
FROM azure_isv.oracledatabase.autonomous_databases
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND autonomousdatabasename = '{{ autonomousdatabasename }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_resource_group

List AutonomousDatabase resources by resource group.

SELECT
id,
name,
actualUsedDataStorageSizeInTbs,
adminPassword,
allocatedStorageSizeInTbs,
apexDetails,
autonomousDatabaseId,
autonomousMaintenanceScheduleType,
availableUpgradeVersions,
backupRetentionPeriodInDays,
characterSet,
computeCount,
computeModel,
connectionStrings,
connectionUrls,
cpuCoreCount,
customerContacts,
dataBaseType,
dataSafeStatus,
dataStorageSizeInGbs,
dataStorageSizeInTbs,
databaseEdition,
dbVersion,
dbWorkload,
displayName,
failedDataRecoveryInSeconds,
inMemoryAreaInGbs,
isAutoScalingEnabled,
isAutoScalingForStorageEnabled,
isLocalDataGuardEnabled,
isMtlsConnectionRequired,
isPreview,
isPreviewVersionWithServiceTermsAccepted,
isRemoteDataGuardEnabled,
licenseModel,
lifecycleDetails,
lifecycleState,
localAdgAutoFailoverMaxDataLossLimit,
localDisasterRecoveryType,
localStandbyDb,
location,
longTermBackupSchedule,
memoryPerOracleComputeUnitInGbs,
ncharacterSet,
nextLongTermBackupTimeStamp,
ociUrl,
ocid,
openMode,
operationsInsightsStatus,
peerDbId,
peerDbIds,
permissionLevel,
privateEndpoint,
privateEndpointIp,
privateEndpointLabel,
provisionableCpus,
provisioningState,
remoteDisasterRecoveryConfiguration,
role,
scheduledOperationsList,
serviceConsoleUrl,
sqlWebDeveloperUrl,
subnetId,
supportedRegionsToCloneTo,
systemData,
tags,
timeCreated,
timeDataGuardRoleChanged,
timeDeletionOfFreeAutonomousDatabase,
timeDisasterRecoveryRoleChanged,
timeLocalDataGuardEnabled,
timeMaintenanceBegin,
timeMaintenanceEnd,
timeOfLastFailover,
timeOfLastRefresh,
timeOfLastRefreshPoint,
timeOfLastSwitchover,
timeReclamationOfFreeAutonomousDatabase,
type,
usedDataStorageSizeInGbs,
usedDataStorageSizeInTbs,
vnetId,
whitelistedIps
FROM azure_isv.oracledatabase.autonomous_databases
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_subscription

List AutonomousDatabase resources by subscription ID.

SELECT
id,
name,
actualUsedDataStorageSizeInTbs,
adminPassword,
allocatedStorageSizeInTbs,
apexDetails,
autonomousDatabaseId,
autonomousMaintenanceScheduleType,
availableUpgradeVersions,
backupRetentionPeriodInDays,
characterSet,
computeCount,
computeModel,
connectionStrings,
connectionUrls,
cpuCoreCount,
customerContacts,
dataBaseType,
dataSafeStatus,
dataStorageSizeInGbs,
dataStorageSizeInTbs,
databaseEdition,
dbVersion,
dbWorkload,
displayName,
failedDataRecoveryInSeconds,
inMemoryAreaInGbs,
isAutoScalingEnabled,
isAutoScalingForStorageEnabled,
isLocalDataGuardEnabled,
isMtlsConnectionRequired,
isPreview,
isPreviewVersionWithServiceTermsAccepted,
isRemoteDataGuardEnabled,
licenseModel,
lifecycleDetails,
lifecycleState,
localAdgAutoFailoverMaxDataLossLimit,
localDisasterRecoveryType,
localStandbyDb,
location,
longTermBackupSchedule,
memoryPerOracleComputeUnitInGbs,
ncharacterSet,
nextLongTermBackupTimeStamp,
ociUrl,
ocid,
openMode,
operationsInsightsStatus,
peerDbId,
peerDbIds,
permissionLevel,
privateEndpoint,
privateEndpointIp,
privateEndpointLabel,
provisionableCpus,
provisioningState,
remoteDisasterRecoveryConfiguration,
role,
scheduledOperationsList,
serviceConsoleUrl,
sqlWebDeveloperUrl,
subnetId,
supportedRegionsToCloneTo,
systemData,
tags,
timeCreated,
timeDataGuardRoleChanged,
timeDeletionOfFreeAutonomousDatabase,
timeDisasterRecoveryRoleChanged,
timeLocalDataGuardEnabled,
timeMaintenanceBegin,
timeMaintenanceEnd,
timeOfLastFailover,
timeOfLastRefresh,
timeOfLastRefreshPoint,
timeOfLastSwitchover,
timeReclamationOfFreeAutonomousDatabase,
type,
usedDataStorageSizeInGbs,
usedDataStorageSizeInTbs,
vnetId,
whitelistedIps
FROM azure_isv.oracledatabase.autonomous_databases
WHERE subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

create_or_update

Create a AutonomousDatabase.

INSERT INTO azure_isv.oracledatabase.autonomous_databases (
tags,
location,
properties,
resource_group_name,
autonomousdatabasename,
subscription_id
)
SELECT 
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ autonomousdatabasename }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

Manifest

# Description fields are for documentation purposes
- name: autonomous_databases
props:
  - name: resource_group_name
    value: "{{ resource_group_name }}"
    description: Required parameter for the autonomous_databases resource.
  - name: autonomousdatabasename
    value: "{{ autonomousdatabasename }}"
    description: Required parameter for the autonomous_databases resource.
  - name: subscription_id
    value: "{{ subscription_id }}"
    description: Required parameter for the autonomous_databases resource.
  - name: tags
    value: "{{ tags }}"
    description: |
      Resource tags.
  - name: location
    value: "{{ location }}"
    description: |
      The geo-location where the resource lives. Required.
  - name: properties
    description: |
      The resource-specific properties for this resource.
    value:
      adminPassword: "{{ adminPassword }}"
      dataBaseType: "{{ dataBaseType }}"
      autonomousMaintenanceScheduleType: "{{ autonomousMaintenanceScheduleType }}"
      characterSet: "{{ characterSet }}"
      computeCount: {{ computeCount }}
      computeModel: "{{ computeModel }}"
      cpuCoreCount: {{ cpuCoreCount }}
      customerContacts:
        - email: "{{ email }}"
      dataStorageSizeInTbs: {{ dataStorageSizeInTbs }}
      dataStorageSizeInGbs: {{ dataStorageSizeInGbs }}
      dbVersion: "{{ dbVersion }}"
      dbWorkload: "{{ dbWorkload }}"
      displayName: "{{ displayName }}"
      isAutoScalingEnabled: {{ isAutoScalingEnabled }}
      isAutoScalingForStorageEnabled: {{ isAutoScalingForStorageEnabled }}
      peerDbIds:
        - "{{ peerDbIds }}"
      peerDbId: "{{ peerDbId }}"
      isLocalDataGuardEnabled: {{ isLocalDataGuardEnabled }}
      isRemoteDataGuardEnabled: {{ isRemoteDataGuardEnabled }}
      localDisasterRecoveryType: "{{ localDisasterRecoveryType }}"
      timeDisasterRecoveryRoleChanged: "{{ timeDisasterRecoveryRoleChanged }}"
      remoteDisasterRecoveryConfiguration:
        disasterRecoveryType: "{{ disasterRecoveryType }}"
        timeSnapshotStandbyEnabledTill: "{{ timeSnapshotStandbyEnabledTill }}"
        isSnapshotStandby: {{ isSnapshotStandby }}
        isReplicateAutomaticBackups: {{ isReplicateAutomaticBackups }}
      localStandbyDb:
        lagTimeInSeconds: {{ lagTimeInSeconds }}
        lifecycleState: "{{ lifecycleState }}"
        lifecycleDetails: "{{ lifecycleDetails }}"
        timeDataGuardRoleChanged: "{{ timeDataGuardRoleChanged }}"
        timeDisasterRecoveryRoleChanged: "{{ timeDisasterRecoveryRoleChanged }}"
      failedDataRecoveryInSeconds: {{ failedDataRecoveryInSeconds }}
      isMtlsConnectionRequired: {{ isMtlsConnectionRequired }}
      isPreviewVersionWithServiceTermsAccepted: {{ isPreviewVersionWithServiceTermsAccepted }}
      licenseModel: "{{ licenseModel }}"
      ncharacterSet: "{{ ncharacterSet }}"
      lifecycleDetails: "{{ lifecycleDetails }}"
      provisioningState: "{{ provisioningState }}"
      lifecycleState: "{{ lifecycleState }}"
      scheduledOperationsList:
        - dayOfWeek:
            name: "{{ name }}"
          scheduledStartTime: "{{ scheduledStartTime }}"
          scheduledStopTime: "{{ scheduledStopTime }}"
      privateEndpointIp: "{{ privateEndpointIp }}"
      privateEndpointLabel: "{{ privateEndpointLabel }}"
      ociUrl: "{{ ociUrl }}"
      subnetId: "{{ subnetId }}"
      vnetId: "{{ vnetId }}"
      timeCreated: "{{ timeCreated }}"
      timeMaintenanceBegin: "{{ timeMaintenanceBegin }}"
      timeMaintenanceEnd: "{{ timeMaintenanceEnd }}"
      actualUsedDataStorageSizeInTbs: {{ actualUsedDataStorageSizeInTbs }}
      allocatedStorageSizeInTbs: {{ allocatedStorageSizeInTbs }}
      apexDetails:
        apexVersion: "{{ apexVersion }}"
        ordsVersion: "{{ ordsVersion }}"
      availableUpgradeVersions:
        - "{{ availableUpgradeVersions }}"
      connectionStrings:
        allConnectionStrings:
          high: "{{ high }}"
          low: "{{ low }}"
          medium: "{{ medium }}"
        dedicated: "{{ dedicated }}"
        high: "{{ high }}"
        low: "{{ low }}"
        medium: "{{ medium }}"
        profiles:
          - consumerGroup: "{{ consumerGroup }}"
            displayName: "{{ displayName }}"
            hostFormat: "{{ hostFormat }}"
            isRegional: {{ isRegional }}
            protocol: "{{ protocol }}"
            sessionMode: "{{ sessionMode }}"
            syntaxFormat: "{{ syntaxFormat }}"
            tlsAuthentication: "{{ tlsAuthentication }}"
            value: "{{ value }}"
      connectionUrls:
        apexUrl: "{{ apexUrl }}"
        databaseTransformsUrl: "{{ databaseTransformsUrl }}"
        graphStudioUrl: "{{ graphStudioUrl }}"
        machineLearningNotebookUrl: "{{ machineLearningNotebookUrl }}"
        mongoDbUrl: "{{ mongoDbUrl }}"
        ordsUrl: "{{ ordsUrl }}"
        sqlDevWebUrl: "{{ sqlDevWebUrl }}"
      dataSafeStatus: "{{ dataSafeStatus }}"
      databaseEdition: "{{ databaseEdition }}"
      autonomousDatabaseId: "{{ autonomousDatabaseId }}"
      inMemoryAreaInGbs: {{ inMemoryAreaInGbs }}
      nextLongTermBackupTimeStamp: "{{ nextLongTermBackupTimeStamp }}"
      longTermBackupSchedule:
        repeatCadence: "{{ repeatCadence }}"
        timeOfBackup: "{{ timeOfBackup }}"
        retentionPeriodInDays: {{ retentionPeriodInDays }}
        isDisabled: {{ isDisabled }}
      isPreview: {{ isPreview }}
      localAdgAutoFailoverMaxDataLossLimit: {{ localAdgAutoFailoverMaxDataLossLimit }}
      memoryPerOracleComputeUnitInGbs: {{ memoryPerOracleComputeUnitInGbs }}
      openMode: "{{ openMode }}"
      operationsInsightsStatus: "{{ operationsInsightsStatus }}"
      permissionLevel: "{{ permissionLevel }}"
      privateEndpoint: "{{ privateEndpoint }}"
      provisionableCpus:
        - {{ provisionableCpus }}
      role: "{{ role }}"
      serviceConsoleUrl: "{{ serviceConsoleUrl }}"
      sqlWebDeveloperUrl: "{{ sqlWebDeveloperUrl }}"
      supportedRegionsToCloneTo:
        - "{{ supportedRegionsToCloneTo }}"
      timeDataGuardRoleChanged: "{{ timeDataGuardRoleChanged }}"
      timeDeletionOfFreeAutonomousDatabase: "{{ timeDeletionOfFreeAutonomousDatabase }}"
      timeLocalDataGuardEnabled: "{{ timeLocalDataGuardEnabled }}"
      timeOfLastFailover: "{{ timeOfLastFailover }}"
      timeOfLastRefresh: "{{ timeOfLastRefresh }}"
      timeOfLastRefreshPoint: "{{ timeOfLastRefreshPoint }}"
      timeOfLastSwitchover: "{{ timeOfLastSwitchover }}"
      timeReclamationOfFreeAutonomousDatabase: "{{ timeReclamationOfFreeAutonomousDatabase }}"
      usedDataStorageSizeInGbs: {{ usedDataStorageSizeInGbs }}
      usedDataStorageSizeInTbs: {{ usedDataStorageSizeInTbs }}
      ocid: "{{ ocid }}"
      backupRetentionPeriodInDays: {{ backupRetentionPeriodInDays }}
      whitelistedIps:
        - "{{ whitelistedIps }}"

UPDATE examples

update

Update a AutonomousDatabase.

UPDATE azure_isv.oracledatabase.autonomous_databases
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND autonomousdatabasename = '{{ autonomousdatabasename }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

REPLACE examples

create_or_update

Create a AutonomousDatabase.

REPLACE azure_isv.oracledatabase.autonomous_databases
SET 
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND autonomousdatabasename = '{{ autonomousdatabasename }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

delete

Delete a AutonomousDatabase.

DELETE FROM azure_isv.oracledatabase.autonomous_databases
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND autonomousdatabasename = '{{ autonomousdatabasename }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

switchover

Perform switchover action on Autonomous Database.

EXEC azure_isv.oracledatabase.autonomous_databases.switchover 
@resource_group_name='{{ resource_group_name }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"peerDbId": "{{ peerDbId }}", 
"peerDbOcid": "{{ peerDbOcid }}", 
"peerDbLocation": "{{ peerDbLocation }}"
}'
;

failover

Perform failover action on Autonomous Database.

EXEC azure_isv.oracledatabase.autonomous_databases.failover 
@resource_group_name='{{ resource_group_name }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"peerDbId": "{{ peerDbId }}", 
"peerDbOcid": "{{ peerDbOcid }}", 
"peerDbLocation": "{{ peerDbLocation }}"
}'
;

generate_wallet

Generate wallet action on Autonomous Database.

EXEC azure_isv.oracledatabase.autonomous_databases.generate_wallet 
@resource_group_name='{{ resource_group_name }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"generateType": "{{ generateType }}", 
"isRegional": {{ isRegional }}, 
"password": "{{ password }}"
}'
;

restore

Restores an Autonomous Database based on the provided request parameters.

EXEC azure_isv.oracledatabase.autonomous_databases.restore 
@resource_group_name='{{ resource_group_name }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"timestamp": "{{ timestamp }}"
}'
;

shrink

This operation shrinks the current allocated storage down to the current actual used data storage.

EXEC azure_isv.oracledatabase.autonomous_databases.shrink 
@resource_group_name='{{ resource_group_name }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required, 
@subscription_id='{{ subscription_id }}' --required
;

change_disaster_recovery_configuration

Perform ChangeDisasterRecoveryConfiguration action on Autonomous Database.

EXEC azure_isv.oracledatabase.autonomous_databases.change_disaster_recovery_configuration 
@resource_group_name='{{ resource_group_name }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"disasterRecoveryType": "{{ disasterRecoveryType }}", 
"timeSnapshotStandbyEnabledTill": "{{ timeSnapshotStandbyEnabledTill }}", 
"isSnapshotStandby": {{ isSnapshotStandby }}, 
"isReplicateAutomaticBackups": {{ isReplicateAutomaticBackups }}
}'
;

action

Perform Lifecycle Management Action on Autonomous Database.

EXEC azure_isv.oracledatabase.autonomous_databases.action 
@resource_group_name='{{ resource_group_name }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"action": "{{ action }}"
}'
;