You can use the ALTER SYSTEM BACKUP CLUSTER PARAMETERS statement to back up the cluster-level parameters.
Limitations and considerations
You can execute this statement only as the
rootuser in thesystenant.This statement backs up only the non-default cluster-level parameters.
Notice
Cluster-level parameters such as
all_server_list,rootservice_list, anddebug_sync_timeoutare not backed up, regardless of whether their values are default values.
Syntax
ALTER SYSTEM BACKUP CLUSTER PARAMETERS TO 'parameters_backup_path';
Parameters
| Parameter | Description |
|---|---|
| parameters_backup_path | The target path for storing the backup files of cluster-level parameters. You must specify this parameter. The path must meet the requirements for the backup destination of data. For more information, see Prepare for data backup. |
Examples
Back up the 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=***';