Gets a list of Autonomous Database.

GET {{baseUrl}}/autonomousDatabases?compartmentId=<string>&autonomousContainerDatabaseId=<string>&limit=10&page=<string>&sortBy=TIMECREATED&sortOrder=ASC&infrastructureType=<string>&lifecycleState=<string>&dbWorkload=<string>&dbVersion=<string>&isFreeTier=<boolean>&displayName=<string>&isRefreshableClone=<boolean>&isDataGuardEnabled=<boolean>&isResourcePoolLeader=<boolean>&resourcePoolLeaderId=<string>

Gets a list of Autonomous Databases based on the query parameters specified.

Request Params

Note: If you do not include the availability domain filter, the resources are grouped by availability domain, then sorted. | | sortOrder | string | | The sort order to use, either ascending (ASC) or descending (DESC). | | infrastructureType | string | | A filter to return only resources that match the given Infrastructure Type. | | lifecycleState | string | | A filter to return only resources that match the given lifecycle state exactly. | | dbWorkload | string | | A filter to return only autonomous database resources that match the specified workload type. | | dbVersion | string | | A filter to return only autonomous database resources that match the specified dbVersion. | | isFreeTier | string | | Filter on the value of the resource's 'isFreeTier' property. A value of true returns only Always Free resources. A value of false excludes Always Free resources from the returned results. Omitting this parameter returns both Always Free and paid resources. | | displayName | string | | A filter to return only resources that match the entire display name given. The match is not case sensitive. | | isRefreshableClone | string | | Filter on the value of the resource's 'isRefreshableClone' property. A value of true returns only refreshable clones. A value of false excludes refreshable clones from the returned results. Omitting this parameter returns both refreshable clones and databases that are not refreshable clones. | | isDataGuardEnabled | string | | A filter to return only resources that have Data Guard enabled. | | isResourcePoolLeader | string | | Filter if the resource is the resource pool leader. A value of true returns only resource pool leader. | | resourcePoolLeaderId | string | | The database OCID of the resourcepool Leader Autonomous Database. |

HEADERS

RESPONSES

status: OK

[{"id":"\u003cstring\u003e","compartmentId":"\u003cstring\u003e","lifecycleState":"STOPPING","dbName":"\u003cstring\u003e","cpuCoreCount":"\u003cinteger\u003e","dataStorageSizeInTBs":"\u003cinteger\u003e","actualUsedDataStorageSizeInTBs":"\u003cdouble\u003e","allocatedStorageSizeInTBs":"\u003cdouble\u003e","apexDetails":{"apexVersion":"\u003cstring\u003e","ordsVersion":"\u003cstring\u003e"},"arePrimaryWhitelistedIpsUsed":"\u003cboolean\u003e","autoRefreshFrequencyInSeconds":"\u003cinteger\u003e","autoRefreshPointLagInSeconds":"\u003cinteger\u003e","autonomousContainerDatabaseId":"\u003cstring\u003e","autonomousMaintenanceScheduleType":"REGULAR","availableUpgradeVersions":["\u003cstring\u003e"],"backupConfig":{"manualBackupBucketName":"\u003cstring\u003e","manualBackupType":"NONE"},"characterSet":"\u003cstring\u003e","computeCount":"\u003cfloat\u003e","computeModel":"OCPU","connectionStrings":{"allConnectionStrings":{"exercitation_d":"\u003cstring\u003e","minim4ed":"\u003cstring\u003e","mollita":"\u003cstring\u003e"},"dedicated":"\u003cstring\u003e","high":"\u003cstring\u003e","low":"\u003cstring\u003e","medium":"\u003cstring\u003e","profiles":[{"displayName":"\u003cstring\u003e","value":"\u003cstring\u003e","protocol":"TCP","hostFormat":"IP","sessionMode":"REDIRECT","syntaxFormat":"EZCONNECTPLUS","consumerGroup":"TP","isRegional":"\u003cboolean\u003e","tlsAuthentication":"MUTUAL"}]},"connectionUrls":{"apexUrl":"\u003cstring\u003e","databaseTransformsUrl":"\u003cstring\u003e","graphStudioUrl":"\u003cstring\u003e","machineLearningNotebookUrl":"\u003cstring\u003e","machineLearningUserManagementUrl":"\u003cstring\u003e","mongoDbUrl":"\u003cstring\u003e","ordsUrl":"\u003cstring\u003e","sqlDevWebUrl":"\u003cstring\u003e"},"customerContacts":[{"email":"\u003cstring\u003e"}],"dataSafeStatus":"FAILED","dataStorageSizeInGBs":"\u003cinteger\u003e","databaseEdition":"ENTERPRISE_EDITION","dataguardRegionType":"REMOTE_STANDBY_DG_REGION","dbToolsDetails":[{"name":"DATA_TRANSFORMS","isEnabled":false}],"dbVersion":"\u003cstring\u003e","dbWorkload":"DW","definedTags":{"ipsum7":{"in_3a8":{},"veniam_718":{}},"exa4e":{"pariatur_c4":{}},"est_e51":{"exercitation_3d":{},"sed_d50":{},"enim__1":{},"Duisa":{},"Excepteur_64":{}}},"disasterRecoveryRegionType":"REMOTE","displayName":"\u003cstring\u003e","failedDataRecoveryInSeconds":"\u003cinteger\u003e","freeformTags":{"minim9":"\u003cstring\u003e","consequat33c":"\u003cstring\u003e"},"inMemoryAreaInGBs":"\u003cinteger\u003e","inMemoryPercentage":"\u003cinteger\u003e","infrastructureType":"CLOUD","isAccessControlEnabled":"\u003cboolean\u003e","isAutoScalingEnabled":"\u003cboolean\u003e","isAutoScalingForStorageEnabled":"\u003cboolean\u003e","isDataGuardEnabled":"\u003cboolean\u003e","isDedicated":"\u003cboolean\u003e","isDevTier":false,"isFreeTier":false,"isLocalDataGuardEnabled":"\u003cboolean\u003e","isMtlsConnectionRequired":"\u003cboolean\u003e","isPreview":"\u003cboolean\u003e","isReconnectCloneEnabled":"\u003cboolean\u003e","isRefreshableClone":"\u003cboolean\u003e","isRemoteDataGuardEnabled":"\u003cboolean\u003e","keyHistoryEntry":[{"id":"\u003cstring\u003e","timeActivated":"\u003cdateTime\u003e","vaultId":"\u003cstring\u003e"}],"keyStoreId":"\u003cstring\u003e","keyStoreWalletName":"\u003cstring\u003e","kmsKeyId":"\u003cstring\u003e","kmsKeyLifecycleDetails":"\u003cstring\u003e","licenseModel":"LICENSE_INCLUDED","lifecycleDetails":"\u003cstring\u003e","localAdgAutoFailoverMaxDataLossLimit":"\u003cinteger\u003e","localDisasterRecoveryType":"\u003cstring\u003e","localStandbyDb":{"lagTimeInSeconds":"\u003cinteger\u003e","lifecycleDetails":"\u003cstring\u003e","lifecycleState":"STOPPING","timeDataGuardRoleChanged":"\u003cdateTime\u003e","timeDisasterRecoveryRoleChanged":"\u003cdateTime\u003e"},"longTermBackupSchedule":{"isDisabled":false,"repeatCadence":"WEEKLY","retentionPeriodInDays":"\u003cinteger\u003e","timeOfBackup":"\u003cdateTime\u003e"},"memoryPerOracleComputeUnitInGBs":"\u003cinteger\u003e","ncharacterSet":"\u003cstring\u003e","netServicesArchitecture":"DEDICATED","nextLongTermBackupTimeStamp":"\u003cdateTime\u003e","nsgIds":["\u003cstring\u003e"],"ocpuCount":"\u003cfloat\u003e","openMode":"READ_ONLY","operationsInsightsStatus":"FAILED_ENABLING","peerDbIds":["\u003cstring\u003e"],"permissionLevel":"RESTRICTED","privateEndpoint":"\u003cstring\u003e","privateEndpointIp":"\u003cstring\u003e","privateEndpointLabel":"\u003cstring\u003e","provisionableCpus":["\u003cfloat\u003e"],"refreshableMode":"AUTOMATIC","refreshableStatus":"REFRESHING","remoteDisasterRecoveryConfiguration":{"disasterRecoveryType":"BACKUP_BASED","isReplicateAutomaticBackups":"\u003cboolean\u003e","isSnapshotStandby":"\u003cboolean\u003e","timeSnapshotStandbyEnabledTill":"\u003cdateTime\u003e"},"resourcePoolLeaderId":"\u003cstring\u003e","resourcePoolSummary":{"isDisabled":"\u003cboolean\u003e","poolSize":"\u003cinteger\u003e"},"role":"SNAPSHOT_STANDBY","scheduledOperations":[{"dayOfWeek":{"name":"TUESDAY"},"scheduledStartTime":"\u003cstring\u003e","scheduledStopTime":"\u003cstring\u003e"}],"serviceConsoleUrl":"\u003cstring\u003e","sourceId":"\u003cstring\u003e","sqlWebDeveloperUrl":"\u003cstring\u003e","standbyDb":{"lagTimeInSeconds":"\u003cinteger\u003e","lifecycleDetails":"\u003cstring\u003e","lifecycleState":"RESTARTING","timeDataGuardRoleChanged":"\u003cdateTime\u003e","timeDisasterRecoveryRoleChanged":"\u003cdateTime\u003e"},"standbyWhitelistedIps":["\u003cstring\u003e"],"subnetId":"\u003cstring\u003e","supportedRegionsToCloneTo":["\u003cstring\u003e"],"systemTags":{"dolor44":{"incididunt_8b":{}}},"timeCreated":"\u003cdateTime\u003e","timeDataGuardRoleChanged":"\u003cdateTime\u003e","timeDeletionOfFreeAutonomousDatabase":"\u003cdateTime\u003e","timeDisasterRecoveryRoleChanged":"\u003cdateTime\u003e","timeLocalDataGuardEnabled":"\u003cdateTime\u003e","timeMaintenanceBegin":"\u003cdateTime\u003e","timeMaintenanceEnd":"\u003cdateTime\u003e","timeOfAutoRefreshStart":"\u003cdateTime\u003e","timeOfJoiningResourcePool":"\u003cdateTime\u003e","timeOfLastFailover":"\u003cdateTime\u003e","timeOfLastRefresh":"\u003cdateTime\u003e","timeOfLastRefreshPoint":"\u003cdateTime\u003e","timeOfLastSwitchover":"\u003cdateTime\u003e","timeOfNextRefresh":"\u003cdateTime\u003e","timeReclamationOfFreeAutonomousDatabase":"\u003cdateTime\u003e","timeUntilReconnectCloneEnabled":"\u003cdateTime\u003e","usedDataStorageSizeInGBs":"\u003cinteger\u003e","usedDataStorageSizeInTBs":"\u003cinteger\u003e","vaultId":"\u003cstring\u003e","whitelistedIps":["\u003cstring\u003e"]}]