【 使用环境 】生产环境
【 OB or 其他组件 】数据备份
【 使用版本 】4.1 CE
【问题描述】
照着此 文档https://www.oceanbase.com/docs/community-observer-cn-10000000000901790
执行报如下错, 请问为何了?
obclient [oceanbase]> ALTER SYSTEM SET data_backup_dest=‘file:///data/bak’;
ERROR 1235 (0A000): Not supported feature or function
obclient [oceanbase]> ALTER SYSTEM BACKUP DATABASE;
ERROR 9040 (HY000): backup can not start, because no tenant meets the backup condition, please check the tenant status, log archive status, backup data dest, and backup status for each tenant
使用sys租户登陆情况下，ALTER SYSTEM SET data_backup_dest 需要指定tenant。
可以使用如下命令：
ALTER SYSTEM SET data_backup_dest=‘file:///data/bak’ TEANT = your_tenant_name,
请注意：sys租户不能为其自身设置data_backup_dest.
obclient [oceanbase]> ALTER SYSTEM ARCHIVELOG;
Query OK, 0 rows affected (0.005 sec)
obclient [oceanbase]> ALTER SYSTEM BACKUP TENANT = fund;
ERROR 9040 (HY000): backup can not start, because log archive status is not doing.
obclient [oceanbase]> ALTER SYSTEM MAJOR FREEZE;
Query OK, 0 rows affected (0.015 sec)
obclient [oceanbase]> ALTER SYSTEM BACKUP TENANT = fund;
ERROR 9040 (HY000): backup can not start, because log archive status is not doing.
obclient [oceanbase]>
obclient [oceanbase]> ALTER SYSTEM SET LOG_ARCHIVE_DEST='LOCATION=file:///data/bak' TENANT = fund;
ERROR 9081 (HY000): the content of the format file at the destination does not match
