---
title: "查看物理恢复结果 - OceanBase AI 数据库 V4.6.3 | OceanBase 文档中心"
description: "查看物理恢复结果 恢复结束后，可以通过视图查看物理恢复结果。 操作步骤 使用 root 用户登录集群的 sys 租户。 待恢复完成后，您可以执行以下语句，查看集群的恢复任务结果。 obclient [(none)]&gt; SELECT * FROM oceanbase.CDB_OB_RESTORE_HISTORY\\G 查…"
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

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

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*M1BcQZvbrRMAAAAAQGAAAAgAeiGDAQ/original) OceanBase AI 数据库V 4.6.3

# 查看物理恢复结果

更新时间：2026-11-16 20:22:57

[编辑](https://github.com/oceanbase/oceanbase-database-ai/edit/V4.6.3/zh-CN/600.manage/600.backup-and-recovery/600.restore-data/500.view-the-restore-history.md)  

恢复结束后，可以通过视图查看物理恢复结果。

## 操作步骤

1. 使用 `root` 用户登录集群的 `sys` 租户。
 2. 待恢复完成后，您可以执行以下语句，查看集群的恢复任务结果。

   ```sql
   obclient [(none)]> SELECT * FROM oceanbase.CDB_OB_RESTORE_HISTORY\G

   ```

   查看结果示例如下：

   ```shell
   *************************** 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: s3://data/backup//archive?host=obs.****.myhuaweicloud.com,s3://data/backup/data?host=obs.****.myhuaweicloud.com
                     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: s3://data/backup/archive/piece_d1001r1p1?host=obs.****.myhuaweicloud.com,s3://data/backup/archive/piece_d1001r2p2?host=obs.****.myhuaweicloud.com
                 BACKUP_SET_LIST: s3://data/backup/data/backup_set_1_full?host=obs.****.myhuaweicloud.com
          BACKUP_CLUSTER_VERSION: 17179869184
                        LS_COUNT: 3
                 FINISH_LS_COUNT: 3
                    TABLET_COUNT: 428
             FINISH_TABLET_COUNT: 428
                     TOTAL_BYTES: 313158553
             TOTAL_BYTES_DISPLAY: 298.65MB
                    FINISH_BYTES: 0
            FINISH_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: s3://data/backup//archive?host=obs.****.myhuaweicloud.com,s3://data/backup/data?host=obs.****.myhuaweicloud.com
                     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: s3://data/backup/archive/piece_d1001r1p1?host=obs.****.myhuaweicloud.com,s3://data/backup/archive/piece_d1001r2p2?host=obs.****.myhuaweicloud.com
                 BACKUP_SET_LIST: s3://data/backup/data/backup_set_1_full?host=obs.****.myhuaweicloud.com
          BACKUP_CLUSTER_VERSION: 17179869184
                        LS_COUNT: 3
                 FINISH_LS_COUNT: 3
                    TABLET_COUNT: 428
             FINISH_TABLET_COUNT: 428
                     TOTAL_BYTES: 313158553
             TOTAL_BYTES_DISPLAY: 298.65MB
                    FINISH_BYTES: 0
            FINISH_BYTES_DISPLAY: 0.00MB
                     DESCRIPTION: NULL
                         COMMENT: NULL
   1 row in set

   ```

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

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

## 后续操作

物理恢复执行成功后，恢复后的租户均为备租户，您可执行如下操作:

- 执行 `recover` 命令, 作为备租户继续从源租户回放日志, 具体操作参见 [备租户日志回放](https://www.oceanbase.com/docs/common-oceanbase-database-ai-1000000007088519)。
 - 执行备切主命令，将备租户转换为主租户，具体操作参见 [备租户转为主租户](https://www.oceanbase.com/docs/common-oceanbase-database-ai-1000000007088528)。

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