The ALTER SYSTEM BACKUP CLUSTER PARAMETERS statement is used to back up cluster-level parameters.
Limitations and considerations
This statement can only be executed under the
rootuser of thesystenant.This statement only backs up cluster-level parameters that are not set to their default values.
Notice
For parameters such as
all_server_list,rootservice_list, anddebug_sync_timeout, regardless of whether their values are default, they will not be backed up.
Syntax
ALTER SYSTEM BACKUP CLUSTER PARAMETERS TO 'parameters_backup_path';
Parameters
| Parameter | Description |
|---|---|
| parameters_backup_path | The target path for the backup file of cluster-level parameters, which needs to be specified by the user. The path requirements are consistent with those for data backup destination paths. For more information about the requirements for data backup destination paths, see Prepare for backup. |
Examples
Back up cluster-level parameters to the oss://oceanbase-test-bucket/backup/cluster_parameters?host=***.aliyun-inc.com&access_id=***&access_key=*** directory.
obclient> ALTER SYSTEM BACKUP CLUSTER PARAMETERS TO 'oss://oceanbase-test-bucket/backup/cluster_parameters?host=***.aliyun-inc.com&access_id=***&access_key=***';