Modify database parameters
put
/databases/modifyDb
Modify the configuration of a database using DBModificationRequest parameters. Modifies backup configuration, database class, and database type
Request
Supported Media Types
- application/json
Header Parameters
-
opc-idempotency-token: string
Minimum Length:
1
Maximum Length:64
A user-supplied token that uniquely identifies a request. A single request will be acted upon among many requests that share the same token. Idempotency tokens expire after 30 minutes.
Database parameters
Root Schema : DBModificationRequest
Type:
Show Source
object
-
backupConfigId(optional):
string
Backup Config resource ID
-
backupConfigName(optional):
string
Backup Config resource name
-
cpuPool(optional):
string
Defines the CPU Pool name
-
currentTDEPassword(optional):
string
Current Password for Password Protected KeyStore. When specified without 'New TDE password' the TDE wallet will be re-keyed.
-
databaseId(optional):
string
Database resource ID
-
dbClass(optional):
string
Database Class EE: OLTP/DSS/IMDB, SE: OLTP (default:OLTP)
-
dbId(optional):
string
Database resource ID
-
dbName(optional):
string
Database resource Name
-
dbRedundancy(optional):
string
Database redundancy
-
dbShape(optional):
string
Database Shape{odb1s,odb1,odb2,etc.} (default:odb1)
-
dbTargetNodeName(optional):
string
Target node name
-
dbTargetNodeNumber(optional):
string
Target node number
-
dbType(optional):
string
Database Type: SI. Only RAC to SI is allowed SE edition
-
enableEEHA(optional):
boolean
Enable HA for EE SI database
-
enableSEHA(optional):
boolean
Enable HA for SE for 19c and later SI database
-
isAutoBackupDisabled(optional):
boolean
Flag to enable or disable auto backup
-
isBackupDisabled(optional):
boolean
Flag to enable database backup
-
level0BackupDay(optional):
string
Allowed Values:
[ "monday", "tuesday", "wednesday", "thursday", "friday", "saturday", "sunday" ]
-
networksToAdd(optional):
array networksToAdd
-
networksToRemove(optional):
array networksToRemove
-
newTDEPassword(optional):
string
New password for Password Protected Keystore. When specified along with 'Current TDE password', the password of the TDE wallet will be changed.
-
noCpuPool(optional):
boolean
Removes the attached CPU Pool
-
rmanBkupPassword(optional):
string
RMAN backup password
-
tdeWalletMgmt(optional):
boolean
When specified TDE wallet management will be changed from EXTERNAL to ODA.
Response
Supported Media Types
- application/json
200 Response
Database modification state.
Root Schema : ServiceJobReport
Type:
object
Job Request Status
Show Source
-
createTimestamp(optional):
string(date-time)
Job creation timestamp
-
description(optional):
string
Job description
-
jobId(optional):
string
Job ID
-
jobType(optional):
string
-
message(optional):
string
Job message
-
reports(optional):
array reports
-
resourceList(optional):
array resourceList
-
status(optional):
string
Allowed Values:
[ "Created", "Scheduled", "Running", "Success", "Failure", "Retrying", "Waiting", "InternalError", "Reverting", "Reverted", "NodeDisconnectedFailure" ]
Job status -
updatedTime(optional):
string(date-time)
Job modification timestamp
Nested Schema : resourceList
Type:
Show Source
array
-
Array of:
object JobResourceInfo
Resource information
Nested Schema : TaskReport
Type:
Show Source
object
-
endTime(optional):
string(date-time)
-
jobId(optional):
string
-
parentTaskId(optional):
string
-
reportLevel(optional):
string
Allowed Values:
[ "Verbose", "Info", "Error" ]
-
startTime(optional):
string(date-time)
-
status(optional):
string
Allowed Values:
[ "Created", "Scheduled", "Running", "Success", "Failure", "Retrying", "Waiting", "InternalError", "Reverting", "Reverted", "NodeDisconnectedFailure", "Skipped" ]
-
tags(optional):
array tags
-
taskDescription(optional):
string
-
taskId(optional):
string
-
taskName(optional):
string
-
taskResult(optional):
string
-
updatedTime(optional):
string(date-time)
Nested Schema : JobResourceInfo
Type:
object
Resource information
Show Source
-
jobId(optional):
string
Job ID
-
resourceId(optional):
string
Resource ID
-
resourceNewType(optional):
string
-
resourceType(optional):
string
Allowed Values:
[ "Backup", "BackupConfig", "DB", "DbHome", "Grid", "Recovery", "Report", "Tde", "ObjectStoreSwift" ]
Resource type -
updatedTime(optional):
string(date-time)
Last updated timestamp
Default Response
An unexpected error has occurred