Get database details by ID
get
/databases/{databaseId}
Request
Supported Media Types
- application/json
Path Parameters
-
databaseId(required): string
database ID
Query Parameters
-
dbvms: string
DBVMs where the entity comes from. Name list is delimited by comma, like 's1,s2'.
-
includeDBVMEntity: boolean
include DBVM entitiesDefault Value:
false
-
includeLocalEntity: boolean
include local entitiesDefault Value:
true
Response
Supported Media Types
- application/json
200 Response
OK
Root Schema : DB
Type:
Show Source
object
-
associatedNetworks:
array associatedNetworks
-
backupConfigId:
string
-
cloudStorageContainer:
string
if the object store backup is selected, then which container should the database backup go to.
-
cpupool:
string
Defines the CPU Pool name
-
createTime:
string(date-time)
-
databaseUniqueName:
string
-
dbCharacterSet:
object DbCharacterSet
-
dbClass:
string
Allowed Values:
[ "OLTP", "DSS", "IMDB" ]
-
dbConsoleEnable:
boolean
-
dbDomainName:
string
-
dbEdition:
string
Database Edition.
-
dbHomeId:
string
The database home resource identifier for associating this database.
-
dbId:
string
The database id
-
dbName:
string
-
dbRedundancy:
string
-
dbRole:
string
Database role (PRIMARY/STANDBY).
-
dbShape:
string
Allowed Values:
[ "odb1s", "odb1", "odb2", "odb4", "odb6", "odb8", "odb10", "odb12", "odb16", "odb20", "odb24", "odb28", "odb32", "odb36", "odb42", "odb48", "odb56", "odb64" ]
-
dbStorage:
string
Allowed Values:
[ "ASM", "ACFS", "PMEM" ]
-
dbTargetNodeName:
string
-
dbTargetNodeNumber:
string
-
dbType:
string
Allowed Values:
[ "RAC", "RACOne", "SI" ]
-
dbVersion:
string
-
enableEEHA:
boolean
Enable HA for EE SI database
-
enableSEHA:
boolean
-
enableTDE:
boolean
Flag to create TDE enabled database
-
entitySource:
string
Where the database is created. Null for local system.
-
id:
string
-
instanceOnly:
boolean
do not create the database files. Used in case of standby case to create standby instance.
-
isAutoBackupDisabled:
boolean
-
isBcfgInSync:
boolean
-
isCdb:
boolean
-
keystoreType:
string
Type of keystore, which stores TDE Master Encryption Key. Either Software or OKV. Default is Software
-
level0BackupDay:
string
Allowed Values:
[ "monday", "tuesday", "wednesday", "thursday", "friday", "saturday", "sunday" ]
-
name:
string
display name for the resource
-
okvServerConfigName:
string
Name of the OKV Server Config object which represents the metadata of OKV server where TDE Master Encryption Keys are stored
-
pdbAdminUserName:
string
-
pdBName:
string
-
pdbs:
array pdbs
List of PDB objects that are present in the CDB
-
quota:
string
disk space quota for a database.
-
registerOnly:
boolean
Use to migrate existing database
-
remark:
string
Remark for database status
-
rmanBkupPassword:
string
-
state:
object ResourceState
-
tdePassword:
string
Password for Password Protected KeyStore
-
tdeWalletManagement:
string
Specify wallet management method for TDE enabled database. Allowed values are ODA and EXTERNAL.
-
updatedTime:
string(date-time)
Nested Schema : ResourceState
Type:
Show Source
object
-
status:
string
Allowed Values:
[ "CREATING", "CONFIGURED", "UPDATING", "DELETING", "FAILED", "RUNNING", "ENABLED", "DISABLED", "STALE" ]
Nested Schema : Pdb
Type:
Show Source
object
-
id:
string
PDB Id
-
pdbName:
string
Name of the PDB
-
sourcePdbArchivePath:
string
The absolute file name of the PDB archive file if ARCHIVE is used in sourceType
-
sourcePdbName:
string
The source PDB name if PDB is used in pdbSource
-
sourceType:
string
Allowed Values:
[ "SEED", "PDB", "ARCHIVE" ]
The source type to create the PDB -
state:
object ResourceState
Default Response
An unexpected error has occurred