查看恢复结果

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

通过视图查看恢复结果

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

2. 进入 oceanbase 数据库。

   obclient> USE oceanbase;
   

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

   示例如下：

   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
                     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: 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/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: 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
   

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

   如果恢复失败，您可以通过删除租户的方式来取消本次恢复，具体操作请参见 取消恢复。

后续处理

恢复操作执行成功后, 恢复后的租户均为备租户，您需要执行备切主命令，将备租户转换为主租户，具体操作请参见 备租户转为主租户。