ModifyDatabaseConfig_云数据库 RDS_API文档

插件下载了解更多
VS Code 插件
安装插件之前,确保已安装 VS Code安装插件之前,确保已安装 VS Code
Alibaba Cloud Developer Toolkit is a collection of extensions that can help access Alibaba Cloud services in Visual Studio Code.
JetBrains 插件
安装插件之前,确保已安装 JetBrains IDE安装插件之前,确保已安装 JetBrains IDE
The Alibaba Cloud Developer Toolkit for JetBrains makes it easier to access Alibaba Cloud services.

接口说明

适用引擎

  • RDS SQL Server

相关功能文档

当前该接口支持的功能为修改 SQL Server 数据库属性云盘数据归档 OSS,且通过 API 使用数据归档 OSS 功能前,请先在控制台开启数据归档功能。

注意 使用该接口前,请仔细阅读功能文档,确保完全了解使用接口的前提条件及使用后造成的影响后,再进行操作。

流控信息

请求速率为10/1(s)。

授权信息

如下是此API对应的授权信息,用于RAM权限策略语句的Action元素中,为RAM用户或RAM角色授予调用此API的权限。请通过 RAM 访问控制设置,使用方法可参考访问控制帮助文档

具体说明如下:展开详情

操作访问级别资源类型条件关键字关联操作
rds:ModifyDatabaseConfig
Update
DBInstance
acs:rds:{#regionId}:{#accountId}:dbinstance/{#DbInstanceId}

请求参数

字段名称字段详情
DBInstanceIdstring

实例 ID。

示例值:rm-t4nnu1my39q******参考取值来源:
    CloneDBInstance
    CreateDBInstance
    ReceiveDBInstance
    ModifyDBInstanceSpec
    RecoveryDBInstance
    DescribeDBInstances
    GetDbProxyInstanceSsl
    CalculateDBInstanceWeight
    MigrateDBNodes
    UpgradeDBInstanceMajorVersion
    TransformDBInstancePayType
    EvaluateLocalExtendDisk
    RestoreDdrTable
    RebuildReplicationLink
DBNamestring

数据库名。展开详情

示例值:testDB
DatabasePropertyNamestring

期望修改的数据库属性。展开详情

示例值:compatibility_level
DatabasePropertyValuestring

期望修改的数据库属性值。展开详情

示例值:150

请求说明

SQL Server 原生参数名称

参数名称允许的值修改时是否需要独占库最低 SQL Server 版本
compatibility_level100
110
120
130
140
150
160
SQL Server 2008
parameterizationFORCED
SIMPLE
所有版本适用
delayed_durabilityDISABLED
ALLOWED
FORCED
SQL Server 2014
accelerated_database_recoveryON
OFF
SQL Server 2019
read_committed_snapshotON
OFF
SQL Server 2008
page_verify
CHECKSUM
TORN_PAGE_DETECTION(不支持修改取值为 TORN_PAGE_DETECTION)
所有版本适用
auto_update_statisticsON
OFF
所有版本适用
auto_update_statistics_asyncON
OFF
SQL Server 2012
allow_snapshot_isolationON
OFF
所有版本适用
ansi_null_defaultON
OFF
所有版本适用
ansi_nullsON
OFF
所有版本适用
ansi_warningsON
OFF
所有版本适用
ansi_paddingON
OFF
所有版本适用
concat_null_yields_nullON
OFF
所有版本适用
recursive_triggersON
OFF
所有版本适用
auto_closeOFF所有版本适用

RDS 自定义参数名称

注意 RDS 自定义参数名称使用rds_开头。

参数名称允许的值修改时是否需要独占库最低 SQL Server 版本备注
rds_optimize_db_file_grow1所有版本适用将数据库的所有文件增长设置为大小,且大小为 256MB。
rds_set_db_online1所有版本适用允许用户 online,如果数据库已经 online,则跳过。
rds_shrink_database_log1所有版本适用对数据库进行收缩动作,是否收缩成功取决于日志的 log_resue_wait_desc 的状态是否为“Nothing”。
rds_update_db_stats1所有版本适用更新数据库中的统计信息,底层使用 SQL Server 自带存储过程 sp_updatestats。
rds_rebuild_db_index1所有版本适用重新数据库中的所有碎片率大于 50%的非聚集索引,需要满足下述条件:
- 数据库大小小于 10G。
- 磁盘剩余空间大于 10G 。

返回参数

字段名称字段详情
Codestring

Code 编码。

示例值:200
Messagestring

返回信息。

示例值:successful
RequestIdstring

请求 ID。

示例值:F5C79A20-E931-5389-BC04-DEBA2D3ABD8D

返回示例

错误码

全局错误码
HTTP 状态码错误码错误信息操作
400
%s
DB Operation Failed:%s.诊断
400
InvalidDatabasePropertyValue
Specified value for the database property is not valid.诊断
400
InvalidDatabaseProperty
Specified name for the database property is not valid.诊断
400
DatabasePropertyModificationFail
Database property modification failed, possibly due to high workload on the database or inability to obtain an exclusive lock. Please attempt to modify the property during periods of low workload.诊断
400
InvalidDatabaseVersion
Specified database property is not compatible with the SQL Server major version.诊断
400
InvalidDBInstanceEngineType.Format
the DB instance engine type does not support this operation.诊断
400
UserAlreadyExistInDb
The current login already has a mapped user with the same name in the specific database. please try removing the existing user and retrying.诊断
400
InvalidDiskType
Current disk type does not support this operation.诊断
400
CurrentInsHasColdDB
The current instance has cold storage db.诊断
400
CurrentInsHasColdStorage
Current instance has cold storage.诊断
400
ColdDBHasSameNameWithOnlineDB
The instance has cold db and online db with the same name.诊断
400
DiskSpaceInsufficientForColdOperation
Insufficient disk space to bring db online.诊断
400
InvalidRestoreTimeSpecified
Unable to restore to the specified time, because the database is in cold storage at this time. Please choose a valid restore point.诊断
400
InvalidRestoreDB
Unable to restore, because the database is in cold storage now. Please skip this database.诊断
400
CurrentDBIsInColdStorage
current db is cold db.诊断
400
ColdDBNumExceedsLimit
the number of cold db exceeds the limit.诊断
400
Order.ComboInstanceNotAllowOperate
A package instance is not allowed to operate independently.诊断
400
Price.PricingPlanResultNotFound
Pricing plan price result not found.诊断
400
Order.NoRealNameAuthentication
You have not passed the real-name authentication and do not meet the purchase conditions. Please log in to the user center for real-name authentication.诊断
400
InsufficientAvailableQuota
Your account quota limit is less than 0, please recharge before trying to purchase.诊断
400
CommodityServiceCalling.Exception
Failed to call commodity service.诊断
400
RegionDissolvedEOM
Dear customer, Alibaba Cloud plans to optimize and adjust the current region. Cloud services in this region will cease operations. You are currently unable to operate new purchase orders. Thank you for your understanding and support.诊断
400
Commodity.InvalidComponent
The module you purchased is not legal, please buy it again.诊断
400
RegionEndTimeDissolvedAustralia
Cloud services in the Australia (Sydney) region will be discontinued. Set the validity date to September 30, 2024 or earlier than September 30, 2024.诊断
400
Price.CommoditySys
Commodity system call exception.诊断
400
Pay.InsufficientBalance
Insufficient available balance.诊断
400
Order.PeriodInvalid
There is a problem with the period you selected, please choose again.诊断
400
pay.noCreditCard
Account not bound to credit card.诊断
400
Order.InstHasUnpaidOrder
There is an unpaid order for the service you have purchased. Please pay or void it before placing the order.诊断
400
noAvailablePaymentMethod
No payment method is specified for your account. We recommend that you add a payment method.诊断
400
BasicInfoUncompleted
Your information is incomplete. Complete your information before the operation.诊断
400
Risk.RiskControlRejection
Your account is abnormal, please contact customer service for details.诊断
400
Api.NotSupport
Specified api is not supported.诊断
400
ContainForbiddenLabelError
There is a label that prohibits placing orders. Please contact your distributor for assistance.诊断
400
InvalidDBInstanceId.NotFound
The DBInstanceId provided does not exist in records.诊断
400
InvalidInstanceLevel.DiskType
Specified instance level not support request disk type诊断
400
InvalidParam
Sepcified wal level Parameter is invalid. There are still logical slots in instance, so it can not be set as replica.诊断
400
KmsApiError
User secret key invalid.诊断
400
System.SaleValidateFailed
Sales expression validation system error.诊断
400
Abs.InvalidAccount.NotFound
account is not found.诊断
400
SqlExecuteFailedOrTimeout
sql command execution failed or timed out:%s.诊断
400
ColdData.EngineVersionNotSupport
The current instance engine version not support coldDataEnabled.诊断
400
ColdData.MinorVersionNotSupport
The current instance minor version not support coldDataEnabled.诊断
400
IncorrectTargetClasscode
The current instance type does not support this operation.诊断
400
InvalidConnectionString.Duplicate
Specified connection string already exists in the RDS.诊断
400
RequiredParam.NotFound
Required input param is not found.诊断
400
Parameters.Invalid
Parameter error, please check the parameters.诊断
400
BackupPolicyNotSupport
Cold Data won't open with CrossBackup or Flash Backup, please check Backup Policy.诊断
400
InvalideStatus.Format
The instance status does not support this operation.诊断
400
InvalidReleasedKeepPolicy.Format
Specified Released Keep Policy is not valid.诊断
400
Pay.NoCreditCard
No credit cards.诊断
400
VpcNetworkTypeNotSupport
The vpc network type instance does not support this operation.诊断
400
MirrorInsExists
Specified DB instance mirror ins already existed.诊断
400
UnsupportedClassCode
The specified DB instance class stops selling.诊断
400
InvalidBackupSet
The specified database does not exist in the backup set.诊断
400
OrdTCommodityQueryError
Failed to query for product.诊断
400
ProductInstanceReleased
The instance has been released. Please check before placing the order.诊断
400
RegionEndTimeDissolvedIndia
The region is no longer supported.诊断
400
InvalidCharacter.DbOrAccount
The database name or account name contains invalid characters.诊断
403
InvalidDB.NotFound
Specified db does not exist or DB status does not support.诊断
403
IncorrectDBInstanceState
Current DB instance state does not support this operation.诊断
403
OrderStatus.UnPaid
The specified db instance has unpaid order.诊断
403
InvalidReduceDiskSize
The storage capacity after the scale-down must be larger than the used amount.诊断
403
CloudSSDNotSupport
Cloud ssd does not support this operation, please upgrade to essd.诊断
403
InvalidUserOperatorPermission
The user permission does not support this operation.诊断
403
InvalidVswitchId
Specified conn vswitch id is not valid.诊断
403
IncorrectMinorVersion
Current engine minor version does not support operations.诊断
403
OperationDenied.ZoneResource
There is no available zone for inventory.诊断
403
NotInFlowController
Sorry,no permission.诊断
403
InvalidKmsKey
Kms key is disabled.诊断
403
InvalidInstanceLevel.Malformed
Current DB instance level does not support this operation.诊断
404
InvalidClusterKms
The current instance does not authorized to access the Key Management Service.诊断
404
Request.NotFound
The requested resource is not available.诊断
404
HostInfo.NotFound
The specified host info is not found.诊断
409
ConflictingDatabaseOperation
There is already some operation on the database and the current operation should wait till it is done.诊断
500
ExternalFailure
The request processing has failed due to external service failure.诊断
500
RequestMetaDataFailed
The service request failed. Please try again later or contact service personnel.诊断
500
InvokeProxyFailure
The request processing has failed due to service failure of rds api.诊断

变更历史

变更时间变更内容概要操作
2025-04-02
变更错误码400
2024-05-28
变更错误码400
2024-04-02
变更错误码400
2023-12-25
变更错误码400
2023-11-21
变更错误码400

相关示例