ListDatabases
GET {{baseUrl}}/databases?compartmentId=<string>&dbHomeId=<string>&systemId=<string>&limit=10&page=<string>&sortBy=TIMECREATED&sortOrder=ASC&lifecycleState=<string>&dbName=<string>
Gets a list of the databases in the specified Database Home.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
compartmentId | string | (Required) The compartment OCID. | |
dbHomeId | string | A Database Home OCID. | |
systemId | string | The OCID of the Exadata DB system that you want to filter the database results by. Applies only to Exadata DB systems. | |
limit | number | The maximum number of items to return per page. | |
page | string | The pagination token to continue listing from. | |
sortBy | string | The field to sort by. You can provide one sort order (sortOrder ). Default order for TIMECREATED is descending. Default order for DBNAME is ascending. The DBNAME sort order is case sensitive. | |
sortOrder | string | The sort order to use, either ascending (ASC ) or descending (DESC ). | |
lifecycleState | string | A filter to return only resources that match the given lifecycle state exactly. | |
dbName | string | A filter to return only resources that match the entire database name given. The match is not case sensitive. |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Accept | string |
RESPONSES
status: OK
[{"id":"\u003cstring\u003e","compartmentId":"\u003cstring\u003e","lifecycleState":"PROVISIONING","dbName":"\u003cstring\u003e","dbUniqueName":"\u003cstring\u003e","characterSet":"\u003cstring\u003e","connectionStrings":{"allConnectionStrings":{"uta7":"\u003cstring\u003e","irure_c":"\u003cstring\u003e"},"cdbDefault":"\u003cstring\u003e","cdbIpDefault":"\u003cstring\u003e"},"databaseManagementConfig":{"managementStatus":"ENABLED","managementType":"BASIC"},"databaseSoftwareImageId":"\u003cstring\u003e","dbBackupConfig":{"autoBackupEnabled":"\u003cboolean\u003e","autoBackupWindow":"SLOT_ONE","autoFullBackupDay":"SUNDAY","autoFullBackupWindow":"SLOT_NINE","backupDeletionPolicy":"DELETE_IMMEDIATELY","backupDestinationDetails":[{"type":"RECOVERY_APPLIANCE","dbrsPolicyId":"\u003cstring\u003e","id":"\u003cstring\u003e","internetProxy":"\u003cstring\u003e","vpcPassword":"\u003cstring\u003e","vpcUser":"\u003cstring\u003e"},{"type":"OBJECT_STORE","dbrsPolicyId":"\u003cstring\u003e","id":"\u003cstring\u003e","internetProxy":"\u003cstring\u003e","vpcPassword":"\u003cstring\u003e","vpcUser":"\u003cstring\u003e"}],"recoveryWindowInDays":"\u003cinteger\u003e","runImmediateFullBackup":true},"dbHomeId":"\u003cstring\u003e","dbSystemId":"\u003cstring\u003e","dbWorkload":"\u003cstring\u003e","definedTags":{"consequat__6":{"minim31":{},"minim10_":{}},"aute_80":{"adipisicingc8":{},"laboruma":{},"nostrudc":{},"Excepteurb40":{}},"amet_":{"id_c4":{},"utbb7":{},"Excepteur5":{}},"ex_cf3":{"dolore_18":{},"aliqua3da":{},"sunt_8e":{}}},"freeformTags":{"consequata":"\u003cstring\u003e","dolor8":"\u003cstring\u003e","veniam__8":"\u003cstring\u003e"},"isCdb":"\u003cboolean\u003e","kmsKeyId":"\u003cstring\u003e","kmsKeyVersionId":"\u003cstring\u003e","lastBackupDurationInSeconds":"\u003cinteger\u003e","lastBackupTimestamp":"\u003cdateTime\u003e","lastFailedBackupTimestamp":"\u003cdateTime\u003e","lifecycleDetails":"\u003cstring\u003e","ncharacterSet":"\u003cstring\u003e","pdbName":"\u003cstring\u003e","sidPrefix":"\u003cstring\u003e","sourceDatabasePointInTimeRecoveryTimestamp":"\u003cdateTime\u003e","timeCreated":"\u003cdateTime\u003e","vaultId":"\u003cstring\u003e","vmClusterId":"\u003cstring\u003e"},{"id":"\u003cstring\u003e","compartmentId":"\u003cstring\u003e","lifecycleState":"FAILED","dbName":"\u003cstring\u003e","dbUniqueName":"\u003cstring\u003e","characterSet":"\u003cstring\u003e","connectionStrings":{"allConnectionStrings":{"pariatur1":"\u003cstring\u003e","cillum_55":"\u003cstring\u003e"},"cdbDefault":"\u003cstring\u003e","cdbIpDefault":"\u003cstring\u003e"},"databaseManagementConfig":{"managementStatus":"FAILED_ENABLING","managementType":"BASIC"},"databaseSoftwareImageId":"\u003cstring\u003e","dbBackupConfig":{"autoBackupEnabled":"\u003cboolean\u003e","autoBackupWindow":"SLOT_TEN","autoFullBackupDay":"SUNDAY","autoFullBackupWindow":"SLOT_ONE","backupDeletionPolicy":"DELETE_IMMEDIATELY","backupDestinationDetails":[{"type":"NFS","dbrsPolicyId":"\u003cstring\u003e","id":"\u003cstring\u003e","internetProxy":"\u003cstring\u003e","vpcPassword":"\u003cstring\u003e","vpcUser":"\u003cstring\u003e"},{"type":"DBRS","dbrsPolicyId":"\u003cstring\u003e","id":"\u003cstring\u003e","internetProxy":"\u003cstring\u003e","vpcPassword":"\u003cstring\u003e","vpcUser":"\u003cstring\u003e"}],"recoveryWindowInDays":"\u003cinteger\u003e","runImmediateFullBackup":true},"dbHomeId":"\u003cstring\u003e","dbSystemId":"\u003cstring\u003e","dbWorkload":"\u003cstring\u003e","definedTags":{"quisc84":{"dolor_4":{},"eiusmod_3":{}},"eu_15":{"consectetur735":{},"culpae_9":{},"ad_ff":{}},"aliquipa4":{"anime":{},"minime9":{}},"non35":{"sunt3_f":{},"et98":{}},"commodo_10":{"in_439":{},"ex486":{}}},"freeformTags":{"tempor_5":"\u003cstring\u003e","adipisicingf":"\u003cstring\u003e","autedce":"\u003cstring\u003e","ipsum_ce5":"\u003cstring\u003e"},"isCdb":"\u003cboolean\u003e","kmsKeyId":"\u003cstring\u003e","kmsKeyVersionId":"\u003cstring\u003e","lastBackupDurationInSeconds":"\u003cinteger\u003e","lastBackupTimestamp":"\u003cdateTime\u003e","lastFailedBackupTimestamp":"\u003cdateTime\u003e","lifecycleDetails":"\u003cstring\u003e","ncharacterSet":"\u003cstring\u003e","pdbName":"\u003cstring\u003e","sidPrefix":"\u003cstring\u003e","sourceDatabasePointInTimeRecoveryTimestamp":"\u003cdateTime\u003e","timeCreated":"\u003cdateTime\u003e","vaultId":"\u003cstring\u003e","vmClusterId":"\u003cstring\u003e"}]