【 使用环境 】生产环境
【 OB or 其他组件 】
【 使用版本 】OCP-4.2.1 OBserver-4.2.1.0
【问题描述】在租户界面全量备份后发起恢复发现源租户部分是空白的
【附件及日志】
1 个赞
这个图好像有延迟，我之前也注意到了。刚备份完成看不到。过段时间再看。
1 个赞
我之前的备份策略是每天都是增量，然后删除15天前的备份数据。然后我发起恢复发现源租户都没有，怀疑是不是没全量导致的，然后测试全量备份一次在发起恢复发现还是没有源租户。不知道是啥问题。
2 个赞
换个备份路径试试 
1 个赞
麻烦发下ocp-server.log文件，我联系ocp同学确认下是否为已知问题
另外确认下 ob_admin的路径 是否在/home/admin/oceanbase/bin/ob_admin？
1 个赞
请问有回复了吗？
这里主要是展示下怎么获取版本号，我使用的422目前是没有这个问题的，你可以升级下尝试下，
这个421版本的问题我需要本地复现下，如果确认是这个现象会提交研发修复，感谢反馈
1 个赞
好的，我这升级下试试
我把ocp升级到4.3.1然后observer升级到4.2.4了，还是不行。当初初始部署的是ocp4.0.3后来升到4.2.0再到4.2.1到现在的4.3.1
2 个赞
SELECT * FROM oceanbase.CDB_OB_BACKUP_TASK_HISTORY\G
查看下最近一次全备是什么时候。
可恢复出已删除租户是因为租户存在时期的全备目前还未删除。
全备是多少天备份一次。
1 个赞
最新的全量是好久前了，后面都是增量。所以我怀疑是没全量导致的。然后我就用1004这个租户做全量备份测试看能不能恢复，但是结果是即使全量了也没法恢复。下面书数据库数据：
| 1004 | 299 | 7419 | 1 | 299 | 2024-08-15 04:00:17.599488 | 2024-08-15 04:02:39.631896 | COMPLETED | 1723665635707620266 | 1723665759617297757 | 1723665647802129295 | NONE | 574538270 | 47973212 | 337762.4352 | 0 | 1243 | 1243 | 273 | 273 | 0 | 1 | 0 | 0 | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 1 | 1 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1004 | 300 | 7432 | 1 | 300 | 2024-08-15 16:50:42.894644 | 2024-08-15 16:53:28.944539 | COMPLETED | 1723711872853497762 | 1723712008928573881 | 1723711882607535390 | NONE | 759089947 | 107734050 | 648805.2883 | 0 | 1243 | 1243 | 361 | 361 | 0 | 1 | 0 | 0 | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 1 | 1 | ||
| 1004 | 301 | 7437 | 1 | 301 | 2024-08-15 20:27:16.625786 | 2024-08-15 20:28:48.734132 | COMPLETED | 1723724846922393000 | 1723724928665141000 | 1723724854305332000 | NONE | 811601400 | 114477163 | 1242853.3132 | 0 | 1298 | 1298 | 386 | 386 | 0 | 1 | 0 | 0 | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 1 | 1 | ||
| 1004 | 302 | 7445 | 1 | 302 | 2024-08-16 04:00:09.709916 | 2024-08-16 04:01:51.190994 | COMPLETED | 1723752021788584000 | 1723752111129579000 | 1723752034698446000 | NONE | 595584274 | 51593379 | 508403.9312 | 0 | 1298 | 1298 | 283 | 283 | 0 | 1 | 0 | 0 | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 1 | 1 |
1 个赞
这里可恢复时间区间显示不对啊，你查下集群备份文件可恢复时间范围
SELECT * FROM (SELECT incarnation, tenant_id, backup_set_id, backup_type, path AS backup_dest, start_timestamp as start_time, end_timestamp as end_time, now(6) as check_time, status, comment, description, ‘CLUSTER’ as backup_level FROM ( SELECT incarnation, tenant_id, backup_set_id, backup_type, path, start_timestamp, end_timestamp, status, comment, description FROM CDB_OB_BACKUP_JOBS UNION SELECT incarnation, tenant_id, backup_set_id, backup_type, path, start_timestamp, end_timestamp, status, comment, description FROM CDB_OB_BACKUP_JOB_HISTORY ) WHERE tenant_id <> 1 ) where start_time >= ‘2024-08-13 00:00:00’ ORDER BY start_time DESC;
2 个赞
| 1 | 1004 | 302 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 2024-08-16 04:00:09.709916 | 2024-08-16 04:01:51.292309 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-16 04:00:07.0 | CLUSTER | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1004 | 301 | FULL | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 2024-08-15 20:27:16.625786 | 2024-08-15 20:28:48.848607 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP TENANT FULL_BACKUP BY BACKUP_NOW AT 2024-08-15 20:27:16.0 | CLUSTER | |
| 1 | 1004 | 300 | FULL | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 2024-08-15 16:50:42.894644 | 2024-08-15 16:53:29.009718 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP TENANT FULL_BACKUP BY BACKUP_NOW AT 2024-08-15 16:50:41.0 | CLUSTER | |
| 1 | 1020 | 279 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1020/data | 2024-08-15 04:00:18.899768 | 2024-08-15 04:02:04.120074 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1012 | 289 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1012/data | 2024-08-15 04:00:18.693607 | 2024-08-15 04:01:59.190024 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1018 | 280 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1018/data | 2024-08-15 04:00:18.300604 | 2024-08-15 04:01:56.381561 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1006 | 294 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1006/data | 2024-08-15 04:00:18.209561 | 2024-08-15 04:01:38.732847 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1014 | 286 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1014/data | 2024-08-15 04:00:17.893484 | 2024-08-15 04:02:09.888447 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1004 | 299 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 2024-08-15 04:00:17.599488 | 2024-08-15 04:02:39.700469 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1002 | 298 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1002/data | 2024-08-15 04:00:17.394822 | 2024-08-15 04:06:53.970523 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1026 | 239 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1026/data | 2024-08-15 04:00:16.988550 | 2024-08-15 04:01:55.384896 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1022 | 251 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1022/data | 2024-08-15 04:00:16.821847 | 2024-08-15 04:01:54.770110 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1024 | 240 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1024/data | 2024-08-15 04:00:16.612179 | 2024-08-15 04:02:05.781523 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1016 | 280 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1016/data | 2024-08-15 04:00:16.501880 | 2024-08-15 04:02:18.399331 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-15 04:00:15.0 | CLUSTER | |
| 1 | 1004 | 298 | FULL | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 2024-08-14 13:29:58.250208 | 2024-08-14 13:32:31.489108 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP TENANT FULL_BACKUP BY BACKUP_NOW AT 2024-08-14 13:29:58.0 | CLUSTER | |
| 1 | 1020 | 278 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1020/data | 2024-08-14 04:00:23.013008 | 2024-08-14 04:02:07.759583 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1012 | 288 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1012/data | 2024-08-14 04:00:22.709658 | 2024-08-14 04:01:56.413464 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1018 | 279 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1018/data | 2024-08-14 04:00:22.403568 | 2024-08-14 04:01:43.585342 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1006 | 293 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1006/data | 2024-08-14 04:00:22.200676 | 2024-08-14 04:02:18.724942 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1014 | 285 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1014/data | 2024-08-14 04:00:21.897505 | 2024-08-14 04:02:23.502353 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1004 | 297 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 2024-08-14 04:00:21.728803 | 2024-08-14 04:02:42.916493 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1002 | 297 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1002/data | 2024-08-14 04:00:21.614602 | 2024-08-14 04:06:51.780012 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1026 | 238 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1026/data | 2024-08-14 04:00:21.404896 | 2024-08-14 04:02:04.999396 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1022 | 250 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1022/data | 2024-08-14 04:00:21.115448 | 2024-08-14 04:02:12.059415 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1024 | 239 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1024/data | 2024-08-14 04:00:20.823753 | 2024-08-14 04:02:09.062734 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1016 | 279 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1016/data | 2024-08-14 04:00:20.725450 | 2024-08-14 04:02:38.516834 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-14 04:00:17.0 | CLUSTER | |
| 1 | 1020 | 277 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1020/data | 2024-08-13 04:00:21.895473 | 2024-08-13 04:01:58.554089 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1012 | 287 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1012/data | 2024-08-13 04:00:21.600950 | 2024-08-13 04:02:09.361783 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1018 | 278 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1018/data | 2024-08-13 04:00:21.401183 | 2024-08-13 04:01:36.693728 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1006 | 292 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1006/data | 2024-08-13 04:00:21.198219 | 2024-08-13 04:02:05.614675 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1014 | 284 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1014/data | 2024-08-13 04:00:21.004160 | 2024-08-13 04:02:13.165895 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1004 | 296 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1004/data | 2024-08-13 04:00:20.798582 | 2024-08-13 04:02:27.319603 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1002 | 296 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1002/data | 2024-08-13 04:00:20.601099 | 2024-08-13 04:07:16.907543 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1026 | 237 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1026/data | 2024-08-13 04:00:20.307157 | 2024-08-13 04:02:18.870201 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1022 | 249 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1022/data | 2024-08-13 04:00:19.898065 | 2024-08-13 04:02:19.076906 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1024 | 238 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1024/data | 2024-08-13 04:00:19.597055 | 2024-08-13 04:02:05.661063 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER | |
| 1 | 1016 | 278 | INC | file:///obbackup/Mccbts_OB_Server_Cluster/1/tenant_incarnation_1/1016/data | 2024-08-13 04:00:19.394697 | 2024-08-13 04:02:42.011918 | 2024-08-16 16:01:11.023276 | COMPLETED | ALTER BACKUP CLUSTER INCREMENTAL_BACKUP BY SCHEDULED AT 2024-08-13 04:00:15.0 | CLUSTER |
1 个赞