--- title: "查看物理恢复结果 - OceanBase 数据库 V4.3.1 | OceanBase 文档中心" description: "查看物理恢复结果 恢复结束后，可以通过视图查看物理恢复结果。 操作步骤 使用 root 用户登录集群的 sys 租户。 待恢复完成后，您可以执行以下语句，查看集群的恢复任务结果。 obclient [(none)]> SELECT * FROM oceanbase.CDB_OB_RESTORE_HISTORY\\G 查…" --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.3.1 # 查看物理恢复结果 更新时间：2026-04-10 11:58:01 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.3.1/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: file:///data/nfs/backup//archive,file:///data/nfs/backup/data 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/piece_d1001r1p1,file:///data/nfs/backup/archive/piece_d1001r2p2 BACKUP_SET_LIST: file:///data/nfs/backup/data/backup_set_1_full 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: file:///data/nfs/backup//archive,file:///data/nfs/backup/data 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/piece_d1001r1p1,file:///data/nfs/backup/archive/piece_d1001r2p2 BACKUP_SET_LIST: file:///data/nfs/backup/data/backup_set_1_full 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-cn-1000000000818783)。 ## 后续操作 物理恢复执行成功后，恢复后的租户均为备租户，您可执行如下操作: - 执行 `recover` 命令, 作为备租户继续从源租户回放日志, 具体操作参见 [备租户日志回放](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000818782)。 - 执行备切主命令，将备租户转换为主租户，具体操作参见 [备租户转为主租户](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000818787)。 上一篇 下一篇 ![有帮助](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) 咨询热线