You can use the ALTER SYSTEM BACKUP CLUSTER PARAMETERS statement to back up cluster-level parameters.
Limitations and considerations
You can execute this statement only as the
rootuser of thesystenant.This statement backs up only cluster-level parameters for which default values are not used.
Notice
The
all_server_list,rootservice_list, anddebug_sync_timeoutparameters are not backed up regardless of whether default values are used for them.
Syntax
ALTER SYSTEM BACKUP CLUSTER PARAMETERS TO 'parameters_backup_path';
Parameters
| Parameter | Description |
|---|---|
| parameters_backup_path | The backup path for cluster-level parameters. You must specify a path as needed. It must be the same as the backup destination for data backup. For more information about the backup destination, see Preparations. |
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=***';