OCP 上备份恢复发起后，一直没有进展

OceanBase
#1

OCP 4.0.3_BP1

OB 构建版本号：OB 构建版本号：4.2.0.0-101000032023091319

在ocp上发起恢复后，快20个小时了（2023-10-18 16:18:06 开始至今），一直不见有进展，还需要继续等下去吗？ 怎么确认这个恢复动作是否正常运行中？

obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_RESTORE_PROGRESS\G
*************************** 1. row ***************************
           TENANT_ID: 1
              JOB_ID: 7
 RESTORE_TENANT_NAME: dev2
   RESTORE_TENANT_ID: 1024
  BACKUP_TENANT_NAME: dev
    BACKUP_TENANT_ID: 1012
 BACKUP_CLUSTER_NAME: test
         BACKUP_DEST: file:///ob-backup/test/1/tenant_incarnation_1/1012/clog,file:///ob-backup/test/1/tenant_incarnation_1/1012/data
      RESTORE_OPTION: pool_list=pool_dev2_zone1_lsa,pool_dev2_zone2_kci,pool_dev2_zone3_zgo&primary_zone=zone1;zone2,zone3&locality=FULL@zone1,FULL@zone2,FULL@zone3
         RESTORE_SCN: 1697612400000000000
 RESTORE_SCN_DISPLAY: 2023-10-18 15:00:00.000000
              STATUS: WAIT_TENANT_RESTORE_FINISH
     START_TIMESTAMP: 2023-10-18 16:18:06.894108
     BACKUP_SET_LIST: file:///ob-backup/test/1/tenant_incarnation_1/1012/data/backup_set_118_full
   BACKUP_PIECE_LIST: file:///ob-backup/test/1/tenant_incarnation_1/1012/clog/piece_d1001r1p120,file:///ob-backup/test/1/tenant_incarnation_1/1012/clog/piece_d1001r1p121
         TOTAL_BYTES: NULL
 TOTAL_BYTES_DISPLAY: NULL
        FINISH_BYTES: NULL
FINISH_BYTES_DISPLAY: NULL
         DESCRIPTION: ALTER RESTORE dev2 BY NORMAL WITH restore_job_id=1697617086800
*************************** 2. row ***************************
           TENANT_ID: 1024
              JOB_ID: 7
 RESTORE_TENANT_NAME: dev2
   RESTORE_TENANT_ID: 1024
  BACKUP_TENANT_NAME: dev
    BACKUP_TENANT_ID: 1012
 BACKUP_CLUSTER_NAME: test
         BACKUP_DEST: file:///ob-backup/test/1/tenant_incarnation_1/1012/clog,file:///ob-backup/test/1/tenant_incarnation_1/1012/data
      RESTORE_OPTION: pool_list=pool_dev2_zone1_lsa,pool_dev2_zone2_kci,pool_dev2_zone3_zgo&primary_zone=zone1;zone2,zone3&locality=FULL@zone1,FULL@zone2,FULL@zone3
         RESTORE_SCN: 1697612400000000000
 RESTORE_SCN_DISPLAY: 2023-10-18 15:00:00.000000
              STATUS: RESTORING
     START_TIMESTAMP: 2023-10-18 16:18:06.894108
     BACKUP_SET_LIST: file:///ob-backup/test/1/tenant_incarnation_1/1012/data/backup_set_118_full
   BACKUP_PIECE_LIST: file:///ob-backup/test/1/tenant_incarnation_1/1012/clog/piece_d1001r1p120,file:///ob-backup/test/1/tenant_incarnation_1/1012/clog/piece_d1001r1p121
         TOTAL_BYTES: 3019436692
 TOTAL_BYTES_DISPLAY: 2.81GB
        FINISH_BYTES: 0
FINISH_BYTES_DISPLAY: 0.00MB
         DESCRIPTION: ALTER RESTORE dev2 BY NORMAL WITH restore_job_id=1697617086800
2 rows in set (0.011 sec)
#3

看看日志呢，里面有什么状态信息

#4

日志里没有看到有相关信息

#5

可以删除任务重新发起看一下吗

#6

全量备份时间：2023-10-18 05:00
上面是恢复到：2023-10-18 15:00:00.000000 十几个小时了，一直没动静

停了后尝试恢复到： 2023-10-18 05:02 45分钟就完成了

所以，是不是恢复 日志备份位点 会比较慢？ 那遇到这种情况下，是只能等了吗？ 能不能看到是在正在恢复中，还是已经中断了，目前也不知道怎么决断

#7

请问下恢复的时间点是从小于等于了CDB_OB_ARCHIVELOG表的CHECKPOINT_SCN归档位点吗？