---
title: 备份异地恢复报错备份对象无法恢复至时间点-OceanBase数据库使用指南
description: 了解OceanBase数据库在实际应用中关于 备份异地恢复报错备份对象无法恢复至时间点相关的常见问题和使用技巧，帮助您快速解决 备份异地恢复报错备份对象无法恢复至时间点的难题。
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

划线反馈

# 备份异地恢复报错备份对象无法恢复至时间点

更新时间：2026-05-13 01:51

适用版本： V3.1.x、V3.2.x 内容类型：Troubleshoot  

## 适用版本

OceanBase 数据库 V3.x 版本。

## 问题现象

通过 OCP 恢复异地拷贝的备份文件时，报如下错误。

```
备份对象ObOfflineBackupObject(clusterName=szrcbprd,obClusterId=1,tenantName=tmptobtenantId=1004)无法恢复至时间点2022-10-26T05:00:00，不在可恢复时间区间内。该时间点前7天的可恢复时间区间为:[]。

```

尝试通过命令行方式恢复，报错 `ERROR 9011 (HY000)：cannot find backup file`。

## 问题原因

备份文件拷贝不完整，恢复时找不到部分所需数据文件导致恢复无法正常进行。

## 解决方法

重新从原备份目录拷贝备份文件到指定目录。

可以通过如下 SQL 查询备份文件的路径，进而准确完整地拷贝到异地进行恢复。

```shell
obclient> ALTER SYSTEM RESTORE dest_tenant_name
FROM source_tenant_name AT 'uri' UNTIL 'timestamp' WITH 'restore_option'
PREVIEW;

```

```shell
obclient> SHOW RESTORE PREVIEW;
+--------------+-----------+---------+------------------------------------------------------------------------------------------------------------+-------------+
| backup_type  | backup_id | copy_id | backup_dest                                                                                                | file_status |
+--------------+-----------+---------+------------------------------------------------------------------------------------------------------------+-------------+
| BACKUP_SET   |         1 |       0 | file:///data/nfs/backup/1/incarnation_1/1002/data/backup_set_1_full_20211225                               | AVAILABLE   |
| BACKUP_SET   |         2 |       0 | file:///data/nfs/backup/1/incarnation_1/1002/data/backup_set_2_inc_20211225                                | AVAILABLE   |
| BACKUP_SET   |         1 |       1 | file:///data/nfs/backup_backup/1/incarnation_1/1002/data/backup_set_1_full_20211225                        | AVAILABLE   |
| BACKUP_SET   |         2 |       1 | file:///data/nfs/backup_backup/1/incarnation_1/1002/data/backup_set_2_inc_20211225                         | AVAILABLE   |
| BACKUP_PIECE |         1 |       0 | file:///data/nfs/backup/1/incarnation_1/1002/clog/1_1_20211225                                             | AVAILABLE   |
| BACKUP_PIECE |         2 |       0 | file:///data/nfs/backup/1/incarnation_1/1002/clog/1_2_20211225                                             | AVAILABLE   |
| BACKUP_PIECE |         2 |       1 | file:///data/nfs/backup_backup/1/incarnation_1/1002/clog/1_2_20211225                                      | AVAILABLE   |
+--------------+-----------+---------+------------------------------------------------------------------------------------------------------------+-------------+

```

上一篇

[租户恢复失败，报错：-4016](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000450139)

下一篇

[集群升级失败，手动回滚后恢复任务报错 -4179](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000225630) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线