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

KeyDatatypeRequiredDescription
compartmentIdstring(Required) The compartment OCID.
dbHomeIdstringA Database Home OCID.
systemIdstringThe OCID of the Exadata DB system that you want to filter the database results by. Applies only to Exadata DB systems.
limitnumberThe maximum number of items to return per page.
pagestringThe pagination token to continue listing from.
sortBystringThe 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.
sortOrderstringThe sort order to use, either ascending (ASC) or descending (DESC).
lifecycleStatestringA filter to return only resources that match the given lifecycle state exactly.
dbNamestringA filter to return only resources that match the entire database name given. The match is not case sensitive.

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleState&quot;:&quot;PROVISIONING&quot;,&quot;dbName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbUniqueName&quot;:&quot;\u003cstring\u003e&quot;,&quot;characterSet&quot;:&quot;\u003cstring\u003e&quot;,&quot;connectionStrings&quot;:{&quot;allConnectionStrings&quot;:{&quot;uta7&quot;:&quot;\u003cstring\u003e&quot;,&quot;irure_c&quot;:&quot;\u003cstring\u003e&quot;},&quot;cdbDefault&quot;:&quot;\u003cstring\u003e&quot;,&quot;cdbIpDefault&quot;:&quot;\u003cstring\u003e&quot;},&quot;databaseManagementConfig&quot;:{&quot;managementStatus&quot;:&quot;ENABLED&quot;,&quot;managementType&quot;:&quot;BASIC&quot;},&quot;databaseSoftwareImageId&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbBackupConfig&quot;:{&quot;autoBackupEnabled&quot;:&quot;\u003cboolean\u003e&quot;,&quot;autoBackupWindow&quot;:&quot;SLOT_ONE&quot;,&quot;autoFullBackupDay&quot;:&quot;SUNDAY&quot;,&quot;autoFullBackupWindow&quot;:&quot;SLOT_NINE&quot;,&quot;backupDeletionPolicy&quot;:&quot;DELETE_IMMEDIATELY&quot;,&quot;backupDestinationDetails&quot;:[{&quot;type&quot;:&quot;RECOVERY_APPLIANCE&quot;,&quot;dbrsPolicyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;internetProxy&quot;:&quot;\u003cstring\u003e&quot;,&quot;vpcPassword&quot;:&quot;\u003cstring\u003e&quot;,&quot;vpcUser&quot;:&quot;\u003cstring\u003e&quot;},{&quot;type&quot;:&quot;OBJECT_STORE&quot;,&quot;dbrsPolicyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;internetProxy&quot;:&quot;\u003cstring\u003e&quot;,&quot;vpcPassword&quot;:&quot;\u003cstring\u003e&quot;,&quot;vpcUser&quot;:&quot;\u003cstring\u003e&quot;}],&quot;recoveryWindowInDays&quot;:&quot;\u003cinteger\u003e&quot;,&quot;runImmediateFullBackup&quot;:true},&quot;dbHomeId&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbSystemId&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbWorkload&quot;:&quot;\u003cstring\u003e&quot;,&quot;definedTags&quot;:{&quot;consequat__6&quot;:{&quot;minim31&quot;:{},&quot;minim10_&quot;:{}},&quot;aute_80&quot;:{&quot;adipisicingc8&quot;:{},&quot;laboruma&quot;:{},&quot;nostrudc&quot;:{},&quot;Excepteurb40&quot;:{}},&quot;amet_&quot;:{&quot;id_c4&quot;:{},&quot;utbb7&quot;:{},&quot;Excepteur5&quot;:{}},&quot;ex_cf3&quot;:{&quot;dolore_18&quot;:{},&quot;aliqua3da&quot;:{},&quot;sunt_8e&quot;:{}}},&quot;freeformTags&quot;:{&quot;consequata&quot;:&quot;\u003cstring\u003e&quot;,&quot;dolor8&quot;:&quot;\u003cstring\u003e&quot;,&quot;veniam__8&quot;:&quot;\u003cstring\u003e&quot;},&quot;isCdb&quot;:&quot;\u003cboolean\u003e&quot;,&quot;kmsKeyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;kmsKeyVersionId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastBackupDurationInSeconds&quot;:&quot;\u003cinteger\u003e&quot;,&quot;lastBackupTimestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;lastFailedBackupTimestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;ncharacterSet&quot;:&quot;\u003cstring\u003e&quot;,&quot;pdbName&quot;:&quot;\u003cstring\u003e&quot;,&quot;sidPrefix&quot;:&quot;\u003cstring\u003e&quot;,&quot;sourceDatabasePointInTimeRecoveryTimestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;vaultId&quot;:&quot;\u003cstring\u003e&quot;,&quot;vmClusterId&quot;:&quot;\u003cstring\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleState&quot;:&quot;FAILED&quot;,&quot;dbName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbUniqueName&quot;:&quot;\u003cstring\u003e&quot;,&quot;characterSet&quot;:&quot;\u003cstring\u003e&quot;,&quot;connectionStrings&quot;:{&quot;allConnectionStrings&quot;:{&quot;pariatur1&quot;:&quot;\u003cstring\u003e&quot;,&quot;cillum_55&quot;:&quot;\u003cstring\u003e&quot;},&quot;cdbDefault&quot;:&quot;\u003cstring\u003e&quot;,&quot;cdbIpDefault&quot;:&quot;\u003cstring\u003e&quot;},&quot;databaseManagementConfig&quot;:{&quot;managementStatus&quot;:&quot;FAILED_ENABLING&quot;,&quot;managementType&quot;:&quot;BASIC&quot;},&quot;databaseSoftwareImageId&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbBackupConfig&quot;:{&quot;autoBackupEnabled&quot;:&quot;\u003cboolean\u003e&quot;,&quot;autoBackupWindow&quot;:&quot;SLOT_TEN&quot;,&quot;autoFullBackupDay&quot;:&quot;SUNDAY&quot;,&quot;autoFullBackupWindow&quot;:&quot;SLOT_ONE&quot;,&quot;backupDeletionPolicy&quot;:&quot;DELETE_IMMEDIATELY&quot;,&quot;backupDestinationDetails&quot;:[{&quot;type&quot;:&quot;NFS&quot;,&quot;dbrsPolicyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;internetProxy&quot;:&quot;\u003cstring\u003e&quot;,&quot;vpcPassword&quot;:&quot;\u003cstring\u003e&quot;,&quot;vpcUser&quot;:&quot;\u003cstring\u003e&quot;},{&quot;type&quot;:&quot;DBRS&quot;,&quot;dbrsPolicyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;internetProxy&quot;:&quot;\u003cstring\u003e&quot;,&quot;vpcPassword&quot;:&quot;\u003cstring\u003e&quot;,&quot;vpcUser&quot;:&quot;\u003cstring\u003e&quot;}],&quot;recoveryWindowInDays&quot;:&quot;\u003cinteger\u003e&quot;,&quot;runImmediateFullBackup&quot;:true},&quot;dbHomeId&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbSystemId&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbWorkload&quot;:&quot;\u003cstring\u003e&quot;,&quot;definedTags&quot;:{&quot;quisc84&quot;:{&quot;dolor_4&quot;:{},&quot;eiusmod_3&quot;:{}},&quot;eu_15&quot;:{&quot;consectetur735&quot;:{},&quot;culpae_9&quot;:{},&quot;ad_ff&quot;:{}},&quot;aliquipa4&quot;:{&quot;anime&quot;:{},&quot;minime9&quot;:{}},&quot;non35&quot;:{&quot;sunt3_f&quot;:{},&quot;et98&quot;:{}},&quot;commodo_10&quot;:{&quot;in_439&quot;:{},&quot;ex486&quot;:{}}},&quot;freeformTags&quot;:{&quot;tempor_5&quot;:&quot;\u003cstring\u003e&quot;,&quot;adipisicingf&quot;:&quot;\u003cstring\u003e&quot;,&quot;autedce&quot;:&quot;\u003cstring\u003e&quot;,&quot;ipsum_ce5&quot;:&quot;\u003cstring\u003e&quot;},&quot;isCdb&quot;:&quot;\u003cboolean\u003e&quot;,&quot;kmsKeyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;kmsKeyVersionId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastBackupDurationInSeconds&quot;:&quot;\u003cinteger\u003e&quot;,&quot;lastBackupTimestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;lastFailedBackupTimestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;ncharacterSet&quot;:&quot;\u003cstring\u003e&quot;,&quot;pdbName&quot;:&quot;\u003cstring\u003e&quot;,&quot;sidPrefix&quot;:&quot;\u003cstring\u003e&quot;,&quot;sourceDatabasePointInTimeRecoveryTimestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;vaultId&quot;:&quot;\u003cstring\u003e&quot;,&quot;vmClusterId&quot;:&quot;\u003cstring\u003e&quot;}]