执行下面的SQL语句,
alter system set backup_dest_option=‘log_archive_checkpoint_interval=120s&recovery_window=7d&auto_delete_obsolete_backup=true&log_archive_piece_switch_interval=1d&backup_copies=2’;
会报错:
ERROR 1235 (0A000): backup_copies out of range [0,8] is not supported
但是按照文档的描述,backup_copies 的取值范围是[1,8]:
"
backup_copies
用于指定一个备份级的冗余度。默认值为
1
。如果设置了
backup_backup_dest
,建议该参数设置为
2
,其有效范围为 [1,8]。"
https://open.oceanbase.com/docs/community/oceanbase-database/V3.1.1/backup_dest_option-1-2
另外,参考代码:
check_backup_dest_opt 函数中:
这里明确指明backup_copies不允许是非0值
if (OB_SUCC(ret)) { if (0 != new_opt.backup_copies_) { ret = OB_NOT_SUPPORTED; LOG_WARN(“invalid backup copies”, K(ret), K(opt_str), K(new_opt)); LOG_USER_ERROR(OB_NOT_SUPPORTED, “backup_copies out of range [0,8] is”); } }