--- title: "查看恢复进度和结果 | OceanBase 文档中心" description: 查看恢复进度和结果 执行全量恢复后，可以通过数据库表或 OCP 来查看恢复进度和结果。 通过视图查看恢复进度和结果 使用 root 用户登录数据库的 sys 租户。 进入 oceanbase 数据库。 obclient> USE oceanbase; 执行以下语句，查看恢复进度。 示例如下： obclient> SE… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 3.2.4 企业版 LTS # 查看恢复进度和结果 更新时间：2026-05-07 19:06:27 执行全量恢复后，可以通过数据库表或 OCP 来查看恢复进度和结果。 ## 通过视图查看恢复进度和结果 1. 使用 `root` 用户登录数据库的 `sys` 租户。 2. 进入 `oceanbase` 数据库。 ```sql obclient> USE oceanbase; ``` 3. 执行以下语句，查看恢复进度。 示例如下： ```sql obclient> SELECT * FROM oceanbase.CDB_OB_RESTORE_PROGRESS; +--------+-----------------+-----------+-----------------------+------------------+----------------------+-------------------+---------------------+-------------------------+---------------------+----------------------------+-----------------+-----------------+-------------------+------------------------+--------------------------+----------------------------+----------------------------+---------------------------+---------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+------+ | JOB_ID | EXTERNAL_JOB_ID | TENANT_ID | TENANT_NAME | BACKUP_TENANT_ID | BACKUP_TENANT_NAME | BACKUP_CLUSTER_ID | BACKUP_CLUSTER_NAME | WHITE_LIST | STATUS | START_TIME | COMPLETION_TIME | PARTITION_COUNT | MACRO_BLOCK_COUNT | FINISH_PARTITION_COUNT | FINISH_MACRO_BLOCK_COUNT | RESTORE_START_TIMESTAMP | RESTORE_FINISH_TIMESTAMP | RESTORE_CURRENT_TIMESTAMP | BACKUP_SET_LIST | BACKUP_PIECE_LIST | INFO | +--------+-----------------+-----------+-----------------------+------------------+----------------------+-------------------+---------------------+-------------------------+---------------------+----------------------------+-----------------+-----------------+-------------------+------------------------+--------------------------+----------------------------+----------------------------+---------------------------+---------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+------+ | 1 | -1 | 1001 | restore_oracle_tenant | 1001 | backup_oracle_tenant | 1 | cluster123 | `TEST`.`T1`,`TEST`.`T2` | RESTORE_SYS_REPLICA | 2021-12-15 20:52:38.283863 | NULL | 128 | -1 | 67 | -1 | 2021-12-15 20:49:55.765179 | 2021-12-15 20:49:55.765179 | NULL | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1001/data/backup_set_1_full_20211215 | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1001/clog/1 | | +--------+-----------------+-----------+-----------------------+------------------+----------------------+-------------------+---------------------+-------------------------+---------------------+----------------------------+-----------------+-----------------+-------------------+------------------------+--------------------------+----------------------------+----------------------------+---------------------------+---------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+------+ 1 row in set ``` 4. 待恢复完成后，您可以执行以下语句，查看集群的恢复任务结果和恢复历史。 - 查看恢复任务结果。 示例如下： ```sql obclient> SELECT * FROM oceanbase.CDB_OB_RESTORE_PROGRESS; +--------+-----------------+-----------+-----------------------+------------------+----------------------+-------------------+---------------------+------------+----------------------+----------------------------+-----------------+-----------------+-------------------+------------------------+--------------------------+----------------------------+----------------------------+---------------------------+---------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+------+ | JOB_ID | EXTERNAL_JOB_ID | TENANT_ID | TENANT_NAME | BACKUP_TENANT_ID | BACKUP_TENANT_NAME | BACKUP_CLUSTER_ID | BACKUP_CLUSTER_NAME | WHITE_LIST | STATUS | START_TIME | COMPLETION_TIME | PARTITION_COUNT | MACRO_BLOCK_COUNT | FINISH_PARTITION_COUNT | FINISH_MACRO_BLOCK_COUNT | RESTORE_START_TIMESTAMP | RESTORE_FINISH_TIMESTAMP | RESTORE_CURRENT_TIMESTAMP | BACKUP_SET_LIST | BACKUP_PIECE_LIST | INFO | +--------+-----------------+-----------+-----------------------+------------------+----------------------+-------------------+---------------------+------------+----------------------+----------------------------+-----------------+-----------------+-------------------+------------------------+--------------------------+----------------------------+----------------------------+---------------------------+---------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+------+ | 1 | -1 | 1001 | restore_oracle_tenant | 1001 | backup_oracle_tenant | 1 | cluster123 | | RESTORE_USER_REPLICA | 2021-12-15 20:32:47.085544 | NULL | 19 | -1 | 0 | -1 | 2021-12-15 20:30:40.877283 | 2021-12-15 20:31:23.140742 | NULL | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1001/data/backup_set_1_full_20211215 | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1001/clog/1 | | +--------+-----------------+-----------+-----------------------+------------------+----------------------+-------------------+---------------------+------------+----------------------+----------------------------+-----------------+-----------------+-------------------+------------------------+--------------------------+----------------------------+----------------------------+---------------------------+---------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+------+ 1 row in set ``` - 查看恢复历史。 示例如下： ```sql obclient> SELECT * FROM oceanbase.CDB_OB_RESTORE_HISTORY; +--------+-----------------+-----------+---------------------------+------------------+----------------------+-------------------+---------------------+------------+-----------------+----------------------------+----------------------------+-----------------+-------------------+------------------------+--------------------------+----------------------------+----------------------------+---------------------------+---------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+------+ | JOB_ID | EXTERNAL_JOB_ID | TENANT_ID | TENANT_NAME | BACKUP_TENANT_ID | BACKUP_TENANT_NAME | BACKUP_CLUSTER_ID | BACKUP_CLUSTER_NAME | WHITE_LIST | STATUS | START_TIME | COMPLETION_TIME | PARTITION_COUNT | MACRO_BLOCK_COUNT | FINISH_PARTITION_COUNT | FINISH_MACRO_BLOCK_COUNT | RESTORE_START_TIMESTAMP | RESTORE_FINISH_TIMESTAMP | RESTORE_CURRENT_TIMESTAMP | BACKUP_SET_LIST | BACKUP_PIECE_LIST | INFO | +--------+-----------------+-----------+---------------------------+------------------+----------------------+-------------------+---------------------+------------+-----------------+----------------------------+----------------------------+-----------------+-------------------+------------------------+--------------------------+----------------------------+----------------------------+---------------------------+---------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+------+ | 1 | -1 | 1001 | restore_oracle_tenant_new | 1001 | backup_oracle_tenant | 1 | cluster123 | | RESTORE_SUCCESS | 2021-12-15 19:25:01.271951 | 2021-12-15 19:26:34.966226 | 114 | -1 | 114 | -1 | 2021-12-15 19:21:45.577556 | 2021-12-15 19:21:45.577556 | NULL | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1001/data/backup_set_1_full_20211215 | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1001/clog/1 | | | 2 | -1 | 1002 | restore_oracle_tenant | 1001 | backup_oracle_tenant | 1 | cluster123 | | RESTORE_SUCCESS | 2021-12-15 19:27:27.730347 | 2021-12-15 19:29:20.666024 | 126 | -1 | 126 | -1 | 2021-12-15 19:21:45.577556 | 2021-12-15 19:23:10.491747 | NULL | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1001/data/backup_set_1_full_20211215 | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1001/clog/1 | | | 3 | -1 | 1003 | restore_mysql_tenant | 1002 | backup_mysql_tenant | 1 | cluster123 | | RESTORE_SUCCESS | 2021-12-15 19:29:22.235016 | 2021-12-15 19:31:28.607833 | 7 | -1 | 7 | -1 | 2021-12-15 19:21:45.577556 | 2021-12-15 19:23:10.491747 | NULL | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1002/data/backup_set_1_full_20211215 | file:///data/nfs/backup/ob1.obc.obc/1/incarnation_1/1002/clog/1 | | +--------+-----------------+-----------+---------------------------+------------------+----------------------+-------------------+---------------------+------------+-----------------+----------------------------+----------------------------+-----------------+-------------------+------------------------+--------------------------+----------------------------+----------------------------+---------------------------+---------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+------+ 3 rows in set ``` ## 通过 OCP 查看恢复进度及结果 执行恢复操作后，也可以通过 OCP 来查看恢复进度和结果。 1. 登录 OCP。 2. 在左侧导航栏上，单击 **备份恢复** > **恢复** 。 3. 在 **恢复任务** 页签中，查看恢复任务的进度及结果。 可查看恢复任务的 **ID** 、**备份集群**、**备份租户**、**备份方式**、**目标集群**、**目标租户**、**恢复时间** 、**开始时间**、**结束时间** 和 **状态** 。 如果有失败的恢复任务，可在对应的 **操作** 列后单击 **查看原因** ，查看恢复任务不成功的原因。 还可以通过右上方的时间选项 **近 24 小时**、**近 7 天**、**近 30 天** 或 **自定义时间** 来筛选符合条件的恢复任务。 上一篇 下一篇 ![有帮助](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) 咨询热线