The ALTER SYSTEM BACKUP CLUSTER PARAMETERS statement is used to back up cluster-level parameters.
Limitations and considerations
This statement can only be executed by the
rootuser in thesystenant.This statement only backs up cluster-level parameters that have non-default settings.
Notice
Parameters such as
all_server_list,rootservice_list, anddebug_sync_timeoutare not backed up, regardless of whether their values are default or not.
Syntax
ALTER SYSTEM BACKUP CLUSTER PARAMETERS TO 'parameters_backup_path';
Parameters
Parameter |
Description |
|---|---|
| parameters_backup_path | You must specify the target path for the backup files of cluster-level parameters. The requirements for this path are the same as those for the backup destination path used in data backup. For more information, see Prepare for backup. |
Examples
Back up the cluster-level parameters to the s3://oceanbase-test-bucket/backup/cluster_parameters?host=***&access_id=***&access_key=*** directory.
obclient> ALTER SYSTEM BACKUP CLUSTER PARAMETERS TO 's3://oceanbase-test-bucket/backup/cluster_parameters?host=***&access_id=***&access_key=***';