OCP中备份任务成功但恢复时无目标源租户

OceanBase 技术问题
#6

image
image1731×755 67.5 KB

可恢复时间区间也没有目标租户

1 个赞
#7

select * from DBA_OB_BACKUP_JOB_HISTORY;

1 个赞
#8

image
image1554×599 67.4 KB

image
image1556×588 100 KB

1004是目标租户

1 个赞
#9

ocp版本是多少 麻烦提供一份ocp-server日志。

1 个赞
#12

版本是4.2.2-20240315150922
grep ‘38a0ed4a56fe4b0c’ ocp-server.log
2026-01-14 17:21:06.958 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.s.c.trace.RequestTracingAspect : API: [GET /api/v2/ob/clusters/1/backup/info?timeScopeType=LATEST_SEVEN_DAYS&startTime=2026-01-01T00%3A00%3A00%2B08%3A00&endTime=2026-01-07T23%3A59%3A59%2B08%3A00, client=172.21.1.234, traceId=38a0ed4a56fe4b0c, method=SuccessResponse com.oceanbase.ocp.server.common.controller.ObClusterBackupController.parseBackupInfo(long,OffsetDateTime,OffsetDateTime,ObQueryTimeScopeType), args=1,2026-01-01T00:00+08:00,2026-01-07T23:59:59+08:00,LATEST_SEVEN_DAYS,]
2026-01-14 17:21:06.958 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.oceanbase.backup.core.model.TimeScope : normalize time scope (startTime=2026-01-01T00:00+08:00, endTime=2026-01-07T23:59:59+08:00): passed
2026-01-14 17:21:06.967 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.b.i.BackupStrategyManagerFactory : isPhysical=true, isLogical=false, isPhysicalAndWasLogical=false
2026-01-14 17:21:06.989 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:06.990 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:07.001 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysicalCheck, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/incarnation_1, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:07.219 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : uri=oss://xxx-dmas/main_data/1/incarnation_1.
2026-01-14 17:21:07.219 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : is_exist=false .
2026-01-14 17:21:07.219 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.b.i.BackupStrategyManagerFactory : isPhysical=true, isLogical=false, isPhysicalAndWasLogical=false
2026-01-14 17:21:07.225 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.b.i.d.info.BackupInfoServiceImpl : parse cluster backup info, clusterName = main_data, clusterId = 1
2026-01-14 17:21:07.225 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.ocp.backup.internal.utils.OssUtils : OSS client created, endpoint=oss-cn-hangzhou.aliyuncs.com, accessKeyId=, supportCname=true, hashCode=970107576
2026-01-14 17:21:07.444 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:07.445 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:07.450 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysicalCheck, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1004/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:07.615 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : uri=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1004/data/format.obbak.
2026-01-14 17:21:07.615 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : is_exist=true .
2026-01-14 17:21:07.619 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:07.620 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:07.625 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysical, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1004/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:07.939 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:07.940 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:07.945 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysicalCheck, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1008/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:08.131 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : uri=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1008/data/format.obbak.
2026-01-14 17:21:08.131 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : is_exist=true .
2026-01-14 17:21:08.135 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:08.136 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:08.141 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysical, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1008/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:08.485 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:08.486 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:08.490 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysicalCheck, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1010/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:08.662 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : uri=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1010/data/format.obbak.
2026-01-14 17:21:08.662 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : is_exist=true .
2026-01-14 17:21:08.665 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:08.666 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:08.671 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysical, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1010/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:09.014 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:09.016 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:09.020 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysicalCheck, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1012/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:09.200 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : uri=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1012/data/format.obbak.
2026-01-14 17:21:09.200 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : is_exist=true .
2026-01-14 17:21:09.203 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:09.204 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:09.209 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysical, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1012/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:09.522 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:09.523 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:09.528 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysicalCheck, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1014/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:09.718 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : uri=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1014/data/format.obbak.
2026-01-14 17:21:09.718 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : is_exist=true .
2026-01-14 17:21:09.721 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:09.722 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:09.727 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysical, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1014/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:10.041 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:10.043 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:10.048 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysicalCheck, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1016/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:10.211 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : uri=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1016/data/format.obbak.
2026-01-14 17:21:10.211 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : is_exist=true .
2026-01-14 17:21:10.214 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:10.215 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:10.220 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysical, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1016/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:10.515 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:10.516 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:10.521 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysicalCheck, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1018/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:10.677 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : uri=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1018/data/format.obbak.
2026-01-14 17:21:10.677 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.m.PhysicalBackupFileCheckInfo : is_exist=true .
2026-01-14 17:21:10.681 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1
2026-01-14 17:21:10.682 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1
2026-01-14 17:21:10.687 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.0.229.208:62888/api/v1/backup/file/dumpPhysical, request body:DumpPhysicalBackupFileRequest(obPath=ObPath(installPath=/home/admin/oceanbase, dataPath=/data/1, logPath=/data/log1, diskPathStyle=DEFAULT, runPath=/home/admin/oceanbase), backupFilePath=oss://xxx-dmas/main_data/1/tenant_incarnation_1/1018/data/format.obbak, storageOption=host=oss-cn-hangzhou.aliyuncs.com&access_id=xxx&access_key=xxx), params:null
2026-01-14 17:21:11.015 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.b.c.d.i.AbstractBackupInfoManager : submit 7 parse tasks for {1008=sys_meta_db, 1018=backup_lu, 1016=tang_backup, 1004=data_office, 1014=back_up, 1012=business_unit_bak, 1010=business_unit}
2026-01-14 17:21:12.811 INFO 24873 — [http-nio-0.0.0.0-8080-exec-9,38a0ed4a56fe4b0c,367097e31418] c.o.o.s.c.trace.RequestTracingAspect : API OK: [GET /api/v2/ob/clusters/1/backup/info client=172.21.1.234, traceId=38a0ed4a56fe4b0c, duration=5856 ms]
[root@10-0-104-235 logs]#

1 个赞
#13

我看到这个帖子说/home/admin下需要一个ob_admin，我目前home/admin下是空的，会是这个原因吗

1 个赞
#14

应该不是这个问题，目标OBserver上是有的，OCP没有应该没关系

1 个赞
#15

image
image1593×423 129 KB

目前看OSS上备份确实存在，但是获取的可恢复时间为空

1 个赞
#16

建议优先使用obd升级一下ocp版本到4.4试试。

1 个赞
#17

当前OCP版本我是恢复过几次的，不知道为啥这次列表突然获取不到了，根版本关系我感觉不大

#18

除了升级还有其他方案吗，目前所有正常运行的租户都不显示，只显示了被删除的租户

#19

@旭辉 大佬帮忙看看嘞

#20

之前有过几次断电，重启集群后恢复正常了，不知道是不是跟元数据有关

#21

看起来备份文件在，有没有check list检查或者有没有手动恢复的方法呀

#22

@旭辉
我看了您

这个帖子，执行了
/home/admin/oceanbase/bin/ob_admin dump_backup -d ‘oss://xxx-dmas/main_data/1/tenant_incarnation_1/1004/data?host=oss-cn-hangzhou.aliyuncs.com’

/home/admin/oceanbase/bin/ob_admin dump_backup -d ‘oss://xxx-dmas/main_data/1/tenant_incarnation_1/1004/clog?host=oss-cn-hangzhou.aliyuncs.com’

不过还是没有恢复，看起来我和这位同志遇到的问题的表象是一样的

执行data的结果是
succ to open, filename=/data/ob_log//ob_admin.log, fd=3, wf_fd=2
succ to open, filename=/data/ob_log//ob_admin_rs.log, fd=4, wf_fd=2

其中/data/ob_log//ob_admin.log有明显报错

[2026-01-14 20:21:17.911085] INFO  main (main.cpp:122) [76745][][T0][Y0-0000000000000000-0-0] [lt=0] cmd: [/home/admin/oceanbase/bin/ob_admin dump_backup -d oss://xxx-dmas/main_data/1/tenant_incarnation_1/1004/data?host=oss-cn-hangzhou.aliyuncs.com ]
[2026-01-14 20:21:17.913803] INFO  [LIB] ObSliceAlloc (ob_slice_alloc.h:321) [76745][][T0][Y0-0000000000000000-0-0] [lt=44] ObSliceAlloc init finished(bsize_=7936, isize_=40, slice_limit_=7536, tmallocator_=NULL)
[2026-01-14 20:21:17.913887] INFO  [LIB] ObSliceAlloc (ob_slice_alloc.h:321) [76745][][T0][Y0-0000000000000000-0-0] [lt=37] ObSliceAlloc init finished(bsize_=7936, isize_=160, slice_limit_=7536, tmallocator_=NULL)
[2026-01-14 20:21:17.913996] WDIAG [STORAGE] set (ob_storage_info.cpp:104) [76745][][T500][Y0-0000000000000000-0-0] [lt=5][errcode=-9026] storage info is empty(ret=-9026, device_type=0)
[2026-01-14 20:21:17.914013] WDIAG [SHARE] set (ob_backup_struct.cpp:1502) [76745][][T500][Y0-0000000000000000-0-0] [lt=12][errcode=-9026] failed to set storage info(ret=-9026)
[2026-01-14 20:21:17.914021] WDIAG [STORAGE] check_tenant_backup_path_type_ (ob_admin_dump_backup_data_executor.cpp:2716) [76745][][T500][Y0-0000000000000000-0-0] [lt=5][errcode=-9026] fail to set backup dest(ret=-9026)
[2026-01-14 20:21:17.914039] WDIAG [STORAGE] execute (ob_admin_dump_backup_data_executor.cpp:546) [76745][][T500][Y0-0000000000000000-0-0] [lt=4][errcode=-9026] fail to check tenant backup path type(ret=-9026)
[2026-01-14 20:21:17.914043] WDIAG [COMMON] main (main.cpp:154) [76745][][T500][Y0-0000000000000000-0-0] [lt=4][errcode=-9026] Fail to executor cmd, (ret=-9026)

ob_admin_rs.log是以下内容

[2026-01-14 20:21:17.926483] INFO  [RS] destroy (ob_root_service.cpp:949) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] [ROOTSERVICE_NOTICE] start to destroy rootservice
[2026-01-14 20:21:17.926511] INFO  [RS] destroy (ob_root_service.cpp:961) [76745][][T500][Y0-0000000000000000-0-0] [lt=16] lost replica checker destroy
[2026-01-14 20:21:17.926520] INFO  [RS] destroy (ob_rs_reentrant_thread.cpp:115) [76745][][T500][Y0-0000000000000000-0-0] [lt=6] rs_monitor_check : reentrant thread check unregister success(thread_name="", last_run_timestamp=0)
[2026-01-14 20:21:17.926530] INFO  [RS] destroy (ob_root_service.cpp:969) [76745][][T500][Y0-0000000000000000-0-0] [lt=10] root balance destroy
[2026-01-14 20:21:17.926533] INFO  [RS] destroy (ob_root_service.cpp:976) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] empty server checker destroy
[2026-01-14 20:21:17.926538] INFO  [RS] destroy (ob_root_service.cpp:983) [76745][][T500][Y0-0000000000000000-0-0] [lt=5] rs_monitor_check : thread checker destroy
[2026-01-14 20:21:17.926541] INFO  [RS] destroy (ob_root_service.cpp:989) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] schema history recycler destroy
[2026-01-14 20:21:17.926547] INFO  [RS] destroy (ob_root_service.cpp:993) [76745][][T500][Y0-0000000000000000-0-0] [lt=5] inner queue destroy
[2026-01-14 20:21:17.926550] INFO  [RS] destroy (ob_root_service.cpp:995) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] inspect queue destroy
[2026-01-14 20:21:17.926555] INFO  [RS] destroy (ob_root_service.cpp:997) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] ddl builder destroy
[2026-01-14 20:21:17.926559] INFO  [RS] destroy (ob_rs_reentrant_thread.cpp:115) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] rs_monitor_check : reentrant thread check unregister success(thread_name="", last_run_timestamp=0)
[2026-01-14 20:21:17.926564] INFO  [RS] destroy (ob_root_service.cpp:1002) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] heartbeat checker destroy
[2026-01-14 20:21:17.926575] INFO  [RS] destroy (ob_root_service.cpp:1006) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] event table operator destroy
[2026-01-14 20:21:17.926605] WDIAG [RS] destroy (ob_dbms_job_master.cpp:96) [76745][][T500][Y0-0000000000000000-0-0] [lt=5][errcode=-4006] scheduler task not inited(ret=-4006, inited_=false)
[2026-01-14 20:21:17.926629] INFO  [RS] destroy (ob_root_service.cpp:1009) [76745][][T500][Y0-0000000000000000-0-0] [lt=21] ObDBMSJobMaster destroy
[2026-01-14 20:21:17.926634] INFO  [RS] destroy (ob_root_service.cpp:1012) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] ddl task scheduler destroy
[2026-01-14 20:21:17.926637] INFO  [RS] destroy (ob_rs_reentrant_thread.cpp:115) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] rs_monitor_check : reentrant thread check unregister success(thread_name="", last_run_timestamp=0)
[2026-01-14 20:21:17.926640] INFO  [RS] destroy (ob_root_service.cpp:1027) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] disaster recovery task mgr destroy
[2026-01-14 20:21:17.926649] WDIAG [RS] destroy (ob_dbms_sched_job_master.cpp:95) [76745][][T500][Y0-0000000000000000-0-0] [lt=4][errcode=-4006] scheduler task not inited(ret=-4006, inited_=false)
[2026-01-14 20:21:17.926653] INFO  [RS] destroy (ob_root_service.cpp:1031) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] ObDBMSSchedJobMaster destroy
[2026-01-14 20:21:17.926658] INFO  [RS] destroy (ob_root_service.cpp:1033) [76745][][T500][Y0-0000000000000000-0-0] [lt=5] global ctx timer destroyed
[2026-01-14 20:21:17.926663] INFO  [RS] destroy (ob_root_service.cpp:1042) [76745][][T500][Y0-0000000000000000-0-0] [lt=3] [ROOTSERVICE_NOTICE] destroy rootservice end(ret=0, ret="OB_SUCCESS")
[2026-01-14 20:21:17.928262] INFO  [RS] stop (ob_disaster_recovery_task_table_updater.cpp:188) [76745][][T500][Y0-0000000000000000-0-0] [lt=13] stop ObDRTaskTableUpdater success
[2026-01-14 20:21:17.928268] INFO  [RS] wait (ob_disaster_recovery_task_table_updater.cpp:194) [76745][][T500][Y0-0000000000000000-0-0] [lt=6] wait ObDRTaskTableUpdater
#23

@辞霜 @旭辉
hello大佬，我搜了下ob_admin的OSS用法，目前已经执行了，看起来前几步是好的，后面报错了
ob_admin.log (186.6 KB)
ob_admin_rs.log (4.0 KB)

我AI了一下好像是说备份数据太多，超出缓冲区了，我看了下我确实有很多备份，都是全量的

#24

OB是什么版本？

show variables like '%version_comment%';

之前是正常的？突然就选不到对应源租户吗？

[2026-01-15 09:45:37.676056] WDIAG [STORAGE] dump_tenant_backup_set_infos_ (ob_admin_dump_backup_data_executor.cpp:2364) [116413][][T500][Y0-0000000000000000-0-0] [lt=34][errcode=-4019] fail to printf buf(ret=-4019, i=99)
[2026-01-15 09:45:37.676094] WDIAG [STORAGE] dump_tenant_backup_path_ (ob_admin_dump_backup_data_executor.cpp:997) [116413][][T500][Y0-0000000000000000-0-0] [lt=34][errcode=-4019] fail to dump tenant backup set infos(ret=-4019)
[2026-01-15 09:45:37.676126] WDIAG [STORAGE] execute (ob_admin_dump_backup_data_executor.cpp:550) [116413][][T500][Y0-0000000000000000-0-0] [lt=6][errcode=-4019] fail to dump tenant backup path
[2026-01-15 09:45:37.676133] WDIAG [COMMON] main (main.cpp:154) [116413][][T500][Y0-0000000000000000-0-0] [lt=5][errcode=-4019] Fail to executor cmd, (ret=-4019)
#25

这个报错触发条件：使用ob_admin dump_backup打印超过99个备份集的信息。

#26

OB是：OceanBase_CE 4.2.2.1 (r101000012024030709-083a68a2907b6a1a12138c4a9e0994949166bfba) (Built Mar 7 2024 10:10:58)

之前是好的，OCP上成功恢复过几次，然后服务器之前断电过，但是重启后恢复了，没有注意到备份有没有问题，是昨天突然发现没法选择到正常租户了，目前是所有正在运行的租户都没法恢复，展示的列表是已经删除的租户

备份任务都是正常调度，然后文件实体也存在，就是发起恢复的时候选不到了

#27

有没有办法解决一下嘞，比如指定某个全量备份，还是说我只能清理旧备份，如果清理旧备份的话该如何操作呀