---
title: 数据恢复报错 1235 should not have backup_dest and restore_source at the same time not supported-OceanBase数据库使用指南
description: 了解OceanBase数据库在实际应用中关于 数据恢复报错 1235 should not have backup_dest and restore_source at the same time not supported相关的常见问题和使用技巧，帮助您快速解决 数据恢复报错 1235 should not have backup_dest and restore_source at the same time not supported的难题。
---
切换语言

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

划线反馈

# 数据恢复报错 1235 should not have backup_dest and restore_source at the same time not supported

更新时间：2025-06-23 08:32

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

## 适用版本

OceanBase 数据库 V2.x 和 V3.x 版本。

## 问题现象

执行数据恢复命令遇到下述报错。

```shell
ERROR 1235 (0A000): should not have backup_dest and restore_source at the same time not supported

```

## 问题原因

恢复步骤有误，此操作前执行过 add restore source 操作。

## 解决方法

可通过下述方法解决（二选一）。

- 撤销之前的恢复路径，之后重新执行。

  ```shell
  obclient> ALTER SYSTEM CLEAR RESTORE SOURCE;

  ```
 - 修改恢复语句，剔除恢复路径项目，然后重新执行。

  --修改前

  ```shell
  obclient> alter system restore restore_xxxx from ten_app_cifc0 at 'file:///ushare/restore_test/' until '2023-01-09 09:50:48.505300' with 'backup_cluster_name=obc_region01&backup_cluster_id=1658148067&pool_list=restore_test_xxxx_pool';

  ```

  --修改后

  ```shell
  obclient> alter system restore restore_xxxx from ten_app_cifc0 until '2023-01-09 09:50:48.505300' with 'backup_cluster_name=obc_region01&backup_cluster_id=1658148067&pool_list=restore_test_xxxx_pool';

  ```

## 相关文档

具体操作参见 [执行备份备份数据的恢复](https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000946223)。 ​ ​ ​ ​ ​ ​ ​ ​ ​

上一篇

[恢复租户报错 -4002, invalid locality](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000208069)

下一篇

[OceanBase 数据库执行恢复时报错 ERROR -4179](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000208063) ![有帮助](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) 咨询热线