单个租户备份配置后无法启动

OceanBase 技术问题

dazhuangge 2025 年11 月 10 日 20:08 #1

【使用环境】生产环境
【 OB or 其他组件】
【使用版本】
【问题描述】集群新加observer后，租户迁移到新机器，备份路径权限已经解决，单个租户无法启动备份
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：

ySQL [(none)]> alter system noarchivelog tenant = CFBC_FAP ;
Query OK, 0 rows affected (0.06 sec)

MySQL [(none)]> SELECT a.TENANT_ID,TENANT_NAME, LOG_MODE,PATH FROM oceanbase.DBA_OB_TENANTS a join oceanbase.CDB_OB_ARCHIVELOG b on a.TENANT_ID=b.TENANT_ID WHERE TENANT_TYPE = ‘USER’ ;
±----------±------------±-------------±---------------------------------------------------------------------+
| TENANT_ID | TENANT_NAME | LOG_MODE | PATH |
±----------±------------±-------------±---------------------------------------------------------------------+
| 1002 | OMSDB | ARCHIVELOG | file:///backup/xp/catl_cloudDB_XP/3/tenant_incarnation_1/1002/clog |
| 1004 | ODCDB | NOARCHIVELOG | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1004/clog |
| 1006 | ZABBIX | NOARCHIVELOG | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1006/clog |
| 1022 | WDY | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1022/clog |
| 1040 | EICC_GUANCE | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1040/clog |
| 1042 | CTMSDB | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1042/clog |
| 1048 | CFBC_FAP | NOARCHIVELOG | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1048/clog |
| 1050 | CFBC_SMME | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1050/clog |
| 1052 | CFBC_AIOSS | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1052/clog |
| 1054 | MWR | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1054/clog |
| 1058 | PMH_CFBC | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1058/clog |
±----------±------------±-------------±---------------------------------------------------------------------+
11 rows in set (0.32 sec)

MySQL [(none)]> ALTER SYSTEM SET log_archive_dest=‘location=file:///backup/caxp/1048/clog’ TENANT = CFBC_FAP ;
Query OK, 0 rows affected (0.25 sec)

MySQL [(none)]> ALTER SYSTEM SET DATA_BACKUP_DEST=’’ TENANT = CFBC_FAP ;
Query OK, 0 rows affected (0.01 sec)

MySQL [(none)]> SELECT a.TENANT_ID,TENANT_NAME, LOG_MODE,PATH FROM oceanbase.DBA_OB_TENANTS a join oceanbase.CDB_OB_ARCHIVELOG b on a.TENANT_ID=b.TENANT_ID WHERE TENANT_TYPE = ‘USER’ ;
±----------±------------±-------------±---------------------------------------------------------------------+
| TENANT_ID | TENANT_NAME | LOG_MODE | PATH |
±----------±------------±-------------±---------------------------------------------------------------------+
| 1002 | OMSDB | ARCHIVELOG | file:///backup/xp/catl_cloudDB_XP/3/tenant_incarnation_1/1002/clog |
| 1004 | ODCDB | NOARCHIVELOG | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1004/clog |
| 1006 | ZABBIX | NOARCHIVELOG | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1006/clog |
| 1022 | WDY | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1022/clog |
| 1040 | EICC_GUANCE | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1040/clog |
| 1042 | CTMSDB | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1042/clog |
| 1048 | CFBC_FAP | NOARCHIVELOG | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1048/clog |
| 1050 | CFBC_SMME | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1050/clog |
| 1052 | CFBC_AIOSS | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1052/clog |
| 1054 | MWR | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1054/clog |
| 1058 | PMH_CFBC | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1058/clog |
±----------±------------±-------------±---------------------------------------------------------------------+
11 rows in set (0.25 sec)

MySQL [(none)]> ALTER SYSTEM archivelog TENANT = CFBC_FAP ;
Query OK, 0 rows affected (0.03 sec)

MySQL [(none)]>
MySQL [(none)]> SELECT a.TENANT_ID,TENANT_NAME, LOG_MODE,PATH FROM oceanbase.DBA_OB_TENANTS a join oceanbase.CDB_OB_ARCHIVELOG b on a.TENANT_ID=b.TENANT_ID WHERE TENANT_TYPE = ‘USER’ ;
±----------±------------±-------------±---------------------------------------------------------------------+
| TENANT_ID | TENANT_NAME | LOG_MODE | PATH |
±----------±------------±-------------±---------------------------------------------------------------------+
| 1002 | OMSDB | ARCHIVELOG | file:///backup/xp/catl_cloudDB_XP/3/tenant_incarnation_1/1002/clog |
| 1004 | ODCDB | NOARCHIVELOG | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1004/clog |
| 1006 | ZABBIX | NOARCHIVELOG | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1006/clog |
| 1022 | WDY | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1022/clog |
| 1040 | EICC_GUANCE | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1040/clog |
| 1042 | CTMSDB | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1042/clog |
| 1048 | CFBC_FAP | ARCHIVELOG | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1048/clog |
| 1050 | CFBC_SMME | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1050/clog |
| 1052 | CFBC_AIOSS | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1052/clog |
| 1054 | MWR | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1054/clog |
| 1058 | PMH_CFBC | ARCHIVELOG | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1058/clog |
±----------±------------±-------------±---------------------------------------------------------------------+
11 rows in set (0.29 sec)

MySQL [(none)]> SELECT a.TENANT_ID,TENANT_NAME, LOG_MODE,b.STATUS,PATH FROM oceanbase.DBA_OB_TENANTS a join oceanbase.CDB_OB_ARCHIVELOG b on a.TENANT_ID=b.TENANT_ID WHERE TENANT_TYPE = ‘USER’ ;
±----------±------------±-------------±-------±---------------------------------------------------------------------+
| TENANT_ID | TENANT_NAME | LOG_MODE | STATUS | PATH |
±----------±------------±-------------±-------±---------------------------------------------------------------------+
| 1002 | OMSDB | ARCHIVELOG | DOING | file:///backup/xp/catl_cloudDB_XP/3/tenant_incarnation_1/1002/clog |
| 1004 | ODCDB | NOARCHIVELOG | STOP | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1004/clog |
| 1006 | ZABBIX | NOARCHIVELOG | STOP | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1006/clog |
| 1022 | WDY | ARCHIVELOG | DOING | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1022/clog |
| 1040 | EICC_GUANCE | ARCHIVELOG | DOING | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1040/clog |
| 1042 | CTMSDB | ARCHIVELOG | DOING | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1042/clog |
| 1048 | CFBC_FAP | ARCHIVELOG | STOP | file:///backup/catl_cloudDB_XP/3/tenant_incarnation_1/1048/clog |
| 1050 | CFBC_SMME | ARCHIVELOG | DOING | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1050/clog |
| 1052 | CFBC_AIOSS | ARCHIVELOG | DOING | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1052/clog |
| 1054 | MWR | ARCHIVELOG | DOING | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1054/clog |
| 1058 | PMH_CFBC | ARCHIVELOG | DOING | file:///backup/caxp/catl_cloudDB_XP/3/tenant_incarnation_1/1058/clog |
±----------±------------±-------------±-------±---------------------------------------------------------------------+
11 rows in set (0.22 sec)

【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试，在发帖时输入 [@论坛小助手] 即可召唤小助手，欢迎试用！

dazhuangge 2025 年11 月 10 日 20:08 #3

1 个赞

论坛小助手 2025 年11 月 10 日 20:08 #4

针对您描述的问题，推荐使用 obdiag 工具进行日志采集，这将有助于我们确定问题的具体原因。以下是建议的命令：

日志采集场景: 数据备份问题
日志采集命令: obdiag gather scene run --scene=observer.backup

请执行上述命令，并将生成的日志文件提供给我们。这将帮助我们更准确地定位问题。

另外，为了确定具体的问题，在此需要您提供一些信息：

您能否详细描述一下在添加新的 Observer 节点后，集群的整体状态？
当前租户 CFBC_FAP 在迁移至新机器后，是否遇到了任何错误信息或警告信息？
您提到备份路径权限问题已解决，请问具体的解决步骤是什么？
在尝试启动备份时，是否有特定的错误代码或消息显示？
备份任务配置是否有所更改？如果有，请提供具体的变更内容。
其他租户在新 Observer 上是否能够正常启动备份？

感谢您的配合！

附上敏捷诊断工具 obdiag 使用帮助链接

邓欢欢 2025 年11 月 11 日 08:41 #5

旭辉 2025 年11 月 11 日 09:39 #6

你是要配置 CFBC_FAP 这个租户的备份？
在本租户下或者sys租户指定租户方式执行如下配置试下，如果仍旧开启备份失败，上传下observer.log和rootservice.log

1.alter system set log_archive_dest= '';
2.alter system set data_backup_dest= '';
3.alter system set log_archive_dest= 'LOCATION=file:///xxx';
4.alter system set data_backup_dest= 'file:///xxx';
5.Alter system archivelog;
6.alter system backup database;