查看恢复进度和结果

执行全量恢复后，可以通过数据库表或 OCP 来查看恢复进度和结果。

通过视图查看恢复进度和结果

1. 使用 root 用户登录数据库的 sys 租户。

2. 进入 oceanbase 数据库。

   obclient> USE oceanbase;
   

3. 执行以下语句，查看恢复进度。

   示例如下：

   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. 待恢复完成后，您可以执行以下语句，查看集群的恢复任务结果和恢复历史。

   • 查看恢复任务结果。

     示例如下：

     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
     

   • 查看恢复历史。

     示例如下：

     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 天 或 自定义时间 来筛选符合条件的恢复任务。