---
title: "查看恢复结果 | OceanBase 文档中心"
description: 查看恢复结果 执行全量恢复后，可以通过视图查看恢复结果。 通过视图查看恢复结果 使用 root 用户登录数据库的 sys 租户。 进入 oceanbase 数据库。 obclient> USE oceanbase; 待恢复完成后，您可以执行以下语句，查看集群的恢复任务结果。 示例如下： obclient> SELEC…
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

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

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.0.0 社区版

# 查看恢复结果

更新时间：2026-06-23 15:45:42

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.0.0/zh-CN/500.administrator-guide/1000.high-data-availability/200.backup-and-restoration-management/600.restore-data/500.view-the-restore-history.md)  

执行全量恢复后，可以通过视图查看恢复结果。

## 通过视图查看恢复结果

1. 使用 `root` 用户登录数据库的 `sys` 租户。
 2. 进入 `oceanbase` 数据库。

   ```sql
   obclient> USE oceanbase;

   ```
 3. 待恢复完成后，您可以执行以下语句，查看集群的恢复任务结果。

   示例如下：

   ```sql
    obclient> SELECT * FROM CDB_OB_RESTORE_HISTORY\G
    *************************** 1. row ***************************
                          TENANT_ID: 1
                             JOB_ID: 1
                RESTORE_TENANT_NAME: mysql
                  RESTORE_TENANT_ID: 1002
                 BACKUP_TENANT_NAME: backup_tenant
                   BACKUP_TENANT_ID: 1002
                BACKUP_CLUSTER_NAME: backup_cluster
                        BACKUP_DEST: file:///data/nfs/backup//archive,file:///data/nfs/backup/data
                        TENANT_ROLE: 1
                        RESTORE_SCN: 1658389117092435000
                RESTORE_SCN_DISPLAY: 2022-06-1 07:38:37.092435
                     RESTORE_OPTION: pool_list=small_pool_2&primary_zone=z1
                    START_TIMESTAMP: 2022-06-1 15:40:58.366601
                   FINISH_TIMESTAMP: 2022-06-1 15:44:16.061358
                             STATUS: SUCCESS
                  BACKUP_PIECE_LIST: file:///data/nfs/backup/archive/2_1_2,file:///data/nfs/backup/archive/2_1_3
                    BACKUP_SET_LIST: file:///data/nfs/backup/data/backup_set_1_full
             BACKUP_CLUSTER_VERSION: 17179869184
                           LS_COUNT: 0
                    FINISH_LS_COUNT: 0
                       TABLET_COUNT: 0
                FINISH_TABLET_COUNT: 0
                  MAJOR_BLOCK_BYTES: 0
          MAJOR_BLOCK_BYTES_DISPLAY: 0.00MB
           FINISH_MAJOR_BLOCK_BYTES: 0
   FINISH_MAJOR_BLOCK_BYTES_DISPLAY: 0.00MB
                  MINOR_BLOCK_BYTES: 0
          MINOR_BLOCK_BYTES_DISPLAY: 0.00MB
           FINISH_MINOR_BLOCK_BYTES: 0
   FINISH_MINOR_BLOCK_BYTES_DISPLAY: 0.00MB
                        DESCRIPTION: NULL
                            COMMENT: NULL
    *************************** 2. row ***************************
                          TENANT_ID: 1002
                             JOB_ID: 1
                RESTORE_TENANT_NAME: mysql
                  RESTORE_TENANT_ID: 1002
                 BACKUP_TENANT_NAME: backup_tenant
                   BACKUP_TENANT_ID: 1002
                BACKUP_CLUSTER_NAME: backup_cluster
                        BACKUP_DEST: file:///data/nfs/backup//archive,file:///data/nfs/backup/data
                        TENANT_ROLE: 1
                        RESTORE_SCN: 1658389117092435000
                RESTORE_SCN_DISPLAY: 2022-06-1 07:38:37.092435
                     RESTORE_OPTION: pool_list=small_pool_2&primary_zone=z1
                    START_TIMESTAMP: 2022-06-1 15:40:58.366601
                   FINISH_TIMESTAMP: 2022-06-1 15:44:05.304540
                             STATUS: SUCCESS
                  BACKUP_PIECE_LIST: file:///data/nfs/backup/archive/2_1_2,file:///data/nfs/backup/archive/2_1_3
                    BACKUP_SET_LIST: file:///data/nfs/backup/data/backup_set_1_full
             BACKUP_CLUSTER_VERSION: 17179869184
                           LS_COUNT: 0
                    FINISH_LS_COUNT: 0
                       TABLET_COUNT: 0
                FINISH_TABLET_COUNT: 0
                  MAJOR_BLOCK_BYTES: 0
          MAJOR_BLOCK_BYTES_DISPLAY: 0.00MB
           FINISH_MAJOR_BLOCK_BYTES: 0
   FINISH_MAJOR_BLOCK_BYTES_DISPLAY: 0.00MB
                  MINOR_BLOCK_BYTES: 0
          MINOR_BLOCK_BYTES_DISPLAY: 0.00MB
           FINISH_MINOR_BLOCK_BYTES: 0
   FINISH_MINOR_BLOCK_BYTES_DISPLAY: 0.00MB
                        DESCRIPTION: NULL
                            COMMENT: NULL

   ```

   `CDB_OB_RESTORE_HISTORY` 视图中各字段基本与 `CDB_OB_RESTORE_HISTORY` 相对应。其中， `COMMENT` 用于记录任务失败时的相关错误信息。

   如果恢复失败，您可以通过删除租户的方式来取消本次恢复，具体操作请参见 [取消恢复](https://www.oceanbase.com/docs/community-observer-cn-10000000000901800)。

## 后续处理

恢复操作执行成功后, 恢复后的租户均为备租户，您需要执行备切主命令，将备租户转换为主租户，具体操作请参见 [备租户转为主租户](https://www.oceanbase.com/docs/community-observer-cn-10000000000901803)。

 上一篇 下一篇 ![有帮助](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) 咨询热线