Oracle.Database (stable:2024-06-01)

2025/09/23 • 9 updated methods

AutonomousDatabases_ListBySubscription (updated)
Description List AutonomousDatabase resources by subscription ID
Reference Link ¶

⚶ Changes

{
  "#id": "AutonomousDatabases_ListBySubscription",
  "$responses": {
    "200": {
      "$properties": {
        "value": {
          "Description": {
            "new": "Autonomous Database resource model.",
            "old": "Autonomous Database  resource model."
          }
        }
      }
    }
  }
}

⚼ Request

GET:  /subscriptions/{subscriptionId}/providers/Oracle.Database/autonomousDatabases
{
api-version: string ,
subscriptionId: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
AutonomousDatabases_ListByResourceGroup (updated)
Description List AutonomousDatabase resources by resource group
Reference Link ¶

⚶ Changes

{
  "#id": "AutonomousDatabases_ListByResourceGroup",
  "$responses": {
    "200": {
      "$properties": {
        "value": {
          "Description": {
            "new": "Autonomous Database resource model.",
            "old": "Autonomous Database  resource model."
          }
        }
      }
    }
  }
}

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Oracle.Database/autonomousDatabases
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
AutonomousDatabases_Get (updated)
Description Get a AutonomousDatabase
Reference Link ¶

⚶ Changes

{
  "#id": "AutonomousDatabases_Get",
  "$responses": {
    "200": {
      "Description": {
        "new": "Autonomous Database resource model.",
        "old": "Autonomous Database  resource model."
      }
    }
  }
}

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Oracle.Database/autonomousDatabases/{autonomousdatabasename}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
autonomousdatabasename: string ,
}

⚐ Response (200)

{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
AutonomousDatabases_CreateOrUpdate (updated)
Description Create a AutonomousDatabase
Reference Link ¶

⚶ Changes

{
  "#id": "AutonomousDatabases_CreateOrUpdate",
  "$parameters": {
    "resource": {
      "Description": {
        "new": "Autonomous Database resource model.",
        "old": "Autonomous Database  resource model."
      }
    }
  },
  "$responses": {
    "200": {
      "Description": {
        "new": "Autonomous Database resource model.",
        "old": "Autonomous Database  resource model."
      }
    },
    "201": {
      "Description": {
        "new": "Autonomous Database resource model.",
        "old": "Autonomous Database  resource model."
      }
    }
  }
}

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Oracle.Database/autonomousDatabases/{autonomousdatabasename}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
autonomousdatabasename: string ,
resource:
{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}

⚐ Response (201)

{
$headers:
{
azure-asyncoperation: string ,
retry-after: integer ,
}
,
$schema:
{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
AutonomousDatabases_Update (updated)
Description Update a AutonomousDatabase
Reference Link ¶

⚶ Changes

{
  "#id": "AutonomousDatabases_Update",
  "$responses": {
    "200": {
      "Description": {
        "new": "Autonomous Database resource model.",
        "old": "Autonomous Database  resource model."
      }
    }
  }
}

⚼ Request

PATCH:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Oracle.Database/autonomousDatabases/{autonomousdatabasename}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
autonomousdatabasename: string ,
properties:
{
tags: object ,
properties:
{
adminPassword: string ,
autonomousMaintenanceScheduleType: enum ,
computeCount: number ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isMtlsConnectionRequired: boolean ,
licenseModel: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
databaseEdition: enum ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
localAdgAutoFailoverMaxDataLossLimit: integer ,
openMode: enum ,
permissionLevel: enum ,
role: enum ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}

⚐ Response (202)

{
location: string ,
retry-after: integer ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
AutonomousDatabases_Failover (updated)
Description Perform failover action on Autonomous Database
Reference Link ¶

⚶ Changes

{
  "#id": "AutonomousDatabases_Failover",
  "$responses": {
    "200": {
      "Description": {
        "new": "Autonomous Database resource model.",
        "old": "Autonomous Database  resource model."
      }
    }
  }
}

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Oracle.Database/autonomousDatabases/{autonomousdatabasename}/failover
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
autonomousdatabasename: string ,
body:
{
peerDbId: string ,
}
,
}

⚐ Response (200)

{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}

⚐ Response (202)

{
location: string ,
retry-after: integer ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
AutonomousDatabases_Restore (updated)
Description Restores an Autonomous Database based on the provided request parameters.
Reference Link ¶

⚶ Changes

{
  "#id": "AutonomousDatabases_Restore",
  "$responses": {
    "200": {
      "Description": {
        "new": "Autonomous Database resource model.",
        "old": "Autonomous Database  resource model."
      }
    }
  }
}

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Oracle.Database/autonomousDatabases/{autonomousdatabasename}/restore
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
autonomousdatabasename: string ,
body:
{
timestamp: string ,
}
,
}

⚐ Response (200)

{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}

⚐ Response (202)

{
location: string ,
retry-after: integer ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
AutonomousDatabases_Shrink (updated)
Description This operation shrinks the current allocated storage down to the current actual used data storage.
Reference Link ¶

⚶ Changes

{
  "#id": "AutonomousDatabases_Shrink",
  "$responses": {
    "200": {
      "Description": {
        "new": "Autonomous Database resource model.",
        "old": "Autonomous Database  resource model."
      }
    }
  }
}

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Oracle.Database/autonomousDatabases/{autonomousdatabasename}/shrink
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
autonomousdatabasename: string ,
}

⚐ Response (200)

{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}

⚐ Response (202)

{
location: string ,
retry-after: integer ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
AutonomousDatabases_Switchover (updated)
Description Perform switchover action on Autonomous Database
Reference Link ¶

⚶ Changes

{
  "#id": "AutonomousDatabases_Switchover",
  "$responses": {
    "200": {
      "Description": {
        "new": "Autonomous Database resource model.",
        "old": "Autonomous Database  resource model."
      }
    }
  }
}

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Oracle.Database/autonomousDatabases/{autonomousdatabasename}/switchover
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
autonomousdatabasename: string ,
body:
{
peerDbId: string ,
}
,
}

⚐ Response (200)

{
properties:
{
adminPassword: string ,
dataBaseType: enum ,
autonomousMaintenanceScheduleType: enum ,
characterSet: string ,
computeCount: number ,
computeModel: enum ,
cpuCoreCount: integer ,
customerContacts:
[
{
email: string ,
}
,
]
,
dataStorageSizeInTbs: integer ,
dataStorageSizeInGbs: integer ,
dbVersion: string ,
dbWorkload: enum ,
displayName: string ,
isAutoScalingEnabled: boolean ,
isAutoScalingForStorageEnabled: boolean ,
peerDbIds:
[
string ,
]
,
peerDbId: string ,
isLocalDataGuardEnabled: boolean ,
isRemoteDataGuardEnabled: boolean ,
localDisasterRecoveryType: enum ,
localStandbyDb:
{
lagTimeInSeconds: integer ,
lifecycleState: enum ,
lifecycleDetails: string ,
timeDataGuardRoleChanged: string ,
timeDisasterRecoveryRoleChanged: string ,
}
,
failedDataRecoveryInSeconds: integer ,
isMtlsConnectionRequired: boolean ,
isPreviewVersionWithServiceTermsAccepted: boolean ,
licenseModel: enum ,
ncharacterSet: string ,
lifecycleDetails: string ,
provisioningState: enum ,
lifecycleState: enum ,
scheduledOperations:
{
dayOfWeek:
{
name: enum ,
}
,
scheduledStartTime: string ,
scheduledStopTime: string ,
}
,
privateEndpointIp: string ,
privateEndpointLabel: string ,
ociUrl: string ,
subnetId: string ,
vnetId: string ,
timeCreated: string ,
timeMaintenanceBegin: string ,
timeMaintenanceEnd: string ,
actualUsedDataStorageSizeInTbs: number ,
allocatedStorageSizeInTbs: number ,
apexDetails:
{
apexVersion: string ,
ordsVersion: string ,
}
,
availableUpgradeVersions:
[
string ,
]
,
connectionStrings:
{
allConnectionStrings:
{
high: string ,
low: string ,
medium: string ,
}
,
dedicated: string ,
high: string ,
low: string ,
medium: string ,
profiles:
[
{
consumerGroup: enum ,
displayName: string ,
hostFormat: enum ,
isRegional: boolean ,
protocol: enum ,
sessionMode: enum ,
syntaxFormat: enum ,
tlsAuthentication: enum ,
value: string ,
}
,
]
,
}
,
connectionUrls:
{
apexUrl: string ,
databaseTransformsUrl: string ,
graphStudioUrl: string ,
machineLearningNotebookUrl: string ,
mongoDbUrl: string ,
ordsUrl: string ,
sqlDevWebUrl: string ,
}
,
dataSafeStatus: enum ,
databaseEdition: enum ,
autonomousDatabaseId: string ,
inMemoryAreaInGbs: integer ,
nextLongTermBackupTimeStamp: string ,
longTermBackupSchedule:
{
repeatCadence: enum ,
timeOfBackup: string ,
retentionPeriodInDays: integer ,
isDisabled: boolean ,
}
,
isPreview: boolean ,
localAdgAutoFailoverMaxDataLossLimit: integer ,
memoryPerOracleComputeUnitInGbs: integer ,
openMode: enum ,
operationsInsightsStatus: enum ,
permissionLevel: enum ,
privateEndpoint: string ,
provisionableCpus:
[
integer ,
]
,
role: enum ,
serviceConsoleUrl: string ,
sqlWebDeveloperUrl: string ,
supportedRegionsToCloneTo:
[
string ,
]
,
timeDataGuardRoleChanged: string ,
timeDeletionOfFreeAutonomousDatabase: string ,
timeLocalDataGuardEnabled: string ,
timeOfLastFailover: string ,
timeOfLastRefresh: string ,
timeOfLastRefreshPoint: string ,
timeOfLastSwitchover: string ,
timeReclamationOfFreeAutonomousDatabase: string ,
usedDataStorageSizeInGbs: integer ,
usedDataStorageSizeInTbs: integer ,
ocid: string ,
backupRetentionPeriodInDays: integer ,
whitelistedIps:
[
string ,
]
,
}
,
}

⚐ Response (202)

{
location: string ,
retry-after: integer ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}