租户的备份无法恢复ERROR 4018 (HY000): no backup set path or log piece can be used to restore？

OceanBase 技术问题
,
#1

【 使用环境 】测试环境
【 OB】4.2.5单机版
【问题描述】

系统断电故障，ob无法启动，然后安装了相同版本的ob数据库4.2.5，之前有完整的备份，但是按照恢复命令提示找不到备份？
备份记录：

image
image900×602 19.9 KB

image
image782×585 17.5 KB

恢复过程错误：
image
image1250×629 29.2 KB

image
image1650×88 7.07 KB

请教高手如下的恢复哪里错了，如何才能恢复？谢谢！

备份信息如下：
[root@lnob backup_set_79_full]# pwd
/backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full
[root@lnob backup_set_79_full]# cd ..
[root@lnob data]# ls -lt
total 8
drwx------ 2 admin admin 4096 Oct 26 11:21 backup_sets
drwx------ 5 admin admin  197 Oct 26 10:54 backup_set_79_full
drwx------ 5 admin admin  196 Oct 24 05:42 backup_set_78_inc
drwx------ 5 admin admin  196 Oct 23 05:44 backup_set_77_inc
drwx------ 5 admin admin  196 Oct 22 05:48 backup_set_76_inc
drwx------ 5 admin admin  196 Oct 21 06:00 backup_set_75_inc
drwx------ 5 admin admin  196 Oct 20 07:05 backup_set_74_inc
drwx------ 5 admin admin  196 Oct 19 06:42 backup_set_73_inc
drwx------ 5 admin admin  197 Oct 18 20:36 backup_set_72_full
-rw------- 1 admin admin  175 Aug  7 13:20 format.obbak
drwx------ 2 admin admin   53 Aug  7 13:20 check_file
[root@lnob data]# du -sh *
338G    backup_set_72_full
6.6G    backup_set_73_inc
7.0G    backup_set_74_inc
4.4G    backup_set_75_inc
4.3G    backup_set_76_inc
4.3G    backup_set_77_inc
4.4G    backup_set_78_inc
716G    backup_set_79_full
68K     backup_sets
4.0K    check_file
4.0K    format.obbak
[root@lnob data]# ll backup_set_72_full
total 24
-rw------- 1 admin admin    54 Oct 18 20:36 backup_set_72_full_20251018T040016_20251018T203555.obbak
drwx------ 6 admin admin   185 Oct 18 20:36 infos
drwx------ 6 admin admin   135 Oct 18 04:12 logstream_1
drwx------ 9 admin admin   234 Oct 18 10:12 logstream_1001
-rw------- 1 admin admin   257 Oct 18 20:36 single_backup_set_info.obbak
-rw------- 1 admin admin 14008 Oct 18 20:36 tenant_backup_set_infos.obbak
[root@lnob data]# 
[root@lnob data]# ll backup_set_79_full
total 28
-rw-------  1 admin admin    54 Oct 26 10:54 backup_set_79_full_20251025T040007_20251026T105450.obbak
drwx------  6 admin admin   185 Oct 26 10:54 infos
drwx------  7 admin admin   168 Oct 25 04:20 logstream_1
drwx------ 23 admin admin  4096 Oct 26 07:58 logstream_1001
-rw-------  1 admin admin   257 Oct 26 10:54 single_backup_set_info.obbak
-rw-------  1 admin admin 15362 Oct 26 10:54 tenant_backup_set_infos.obbak
[root@lnob data]# 
[root@lnob backup_set_79_full]# cd ../../..
[root@lnob tenant_incarnation_1]# ll
total 0
drwx------ 4 admin admin 30 Aug  7 13:20 1002
[root@lnob tenant_incarnation_1]# cd 1002/
[root@lnob 1002]# ll
total 0
drwx------ 14 admin admin 288 Oct 26 11:21 clog
drwx------ 12 admin admin 265 Oct 26 11:21 data
[root@lnob 1002]# cd clog/
[root@lnob clog]# ll
total 8
drwx------ 2 admin admin   53 Aug  7 13:20 check_file
-rw------- 1 admin admin  175 Aug  7 13:20 format.obbak
drwx------ 5 admin admin  221 Oct 18 13:22 piece_d1001r1p72
drwx------ 5 admin admin  221 Oct 19 13:23 piece_d1001r1p73
drwx------ 5 admin admin  221 Oct 20 13:23 piece_d1001r1p74
drwx------ 5 admin admin  221 Oct 21 13:23 piece_d1001r1p75
drwx------ 5 admin admin  221 Oct 22 13:23 piece_d1001r1p76
drwx------ 5 admin admin  221 Oct 23 13:23 piece_d1001r1p77
drwx------ 5 admin admin  221 Oct 24 13:23 piece_d1001r1p78
drwx------ 5 admin admin  221 Oct 25 13:21 piece_d1001r1p79
drwx------ 5 admin admin  105 Oct 25 13:21 piece_d1001r1p80
drwx------ 2 admin admin 4096 Oct 26 11:21 pieces
drwx------ 2 admin admin   39 Aug  7 13:20 rounds
[root@lnob clog]# pwd
/backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog
[root@lnob clog]# ll
total 8
drwx------ 2 admin admin   53 Aug  7 13:20 check_file
-rw------- 1 admin admin  175 Aug  7 13:20 format.obbak
drwx------ 5 admin admin  221 Oct 18 13:22 piece_d1001r1p72
drwx------ 5 admin admin  221 Oct 19 13:23 piece_d1001r1p73
drwx------ 5 admin admin  221 Oct 20 13:23 piece_d1001r1p74
drwx------ 5 admin admin  221 Oct 21 13:23 piece_d1001r1p75
drwx------ 5 admin admin  221 Oct 22 13:23 piece_d1001r1p76
drwx------ 5 admin admin  221 Oct 23 13:23 piece_d1001r1p77
drwx------ 5 admin admin  221 Oct 24 13:23 piece_d1001r1p78
drwx------ 5 admin admin  221 Oct 25 13:21 piece_d1001r1p79
drwx------ 5 admin admin  105 Oct 25 13:21 piece_d1001r1p80
drwx------ 2 admin admin 4096 Oct 26 11:21 pieces
drwx------ 2 admin admin   39 Aug  7 13:20 rounds
恢复步骤如下：为何提示找不到路径？
[root@lnob /]# obclient -h192.168.207.28 -P2881 -uroot@sys -p'1qazXSW@' -Doceanbase -A
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221536996
Server version: OceanBase 4.2.5.4 (r104030022025070212-37927c3517f028002a34b40302f78cce88afdbd9) (Built Jul  2 2025 12:21:09)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS\G;
*************************** 1. row ***************************
RESOURCE_POOL_ID: 1
            NAME: sys_pool
       TENANT_ID: 1
     CREATE_TIME: 2025-10-27 15:44:37.160891
     MODIFY_TIME: 2025-10-27 15:44:37.170140
      UNIT_COUNT: 1
  UNIT_CONFIG_ID: 1
       ZONE_LIST: zone1
    REPLICA_TYPE: FULL
*************************** 2. row ***************************
RESOURCE_POOL_ID: 1001
            NAME: lnzyob_pool
       TENANT_ID: 1002
     CREATE_TIME: 2025-10-27 15:47:34.137272
     MODIFY_TIME: 2025-10-27 15:47:34.195087
      UNIT_COUNT: 1
  UNIT_CONFIG_ID: 1001
       ZONE_LIST: zone1
    REPLICA_TYPE: FULL
2 rows in set (0.006 sec)

ERROR: No query specified

obclient(root@sys)[oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full';
Query OK, 0 rows affected (0.001 sec)

obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE lnzyob WITH 'pool_list=lnzyob_pool';
ERROR 4018 (HY000): no backup set path or log piece can be used to restore
obclient(root@sys)[oceanbase]> SHOW RECYCLEBIN;
Empty set (0.010 sec)

obclient(root@sys)[oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_72_full';
Query OK, 0 rows affected (0.001 sec)

obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE lnzyob WITH 'pool_list=lnzyob_pool';
ERROR 4018 (HY000): no backup set path or log piece can be used to restore

obclient(root@sys)[oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog';
Query OK, 0 rows affected (0.001 sec)

obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE lnzyob WITH 'pool_list=lnzyob_pool';
ERROR 4018 (HY000): no backup set path or log piece can be used to restore
obclient(root@sys)[oceanbase]> select * from __all_server;
+----------------------------+----------------------------+----------------+----------+------+-------+------------+-----------------+--------+-----------------------+-------------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+
| gmt_create                 | gmt_modified               | svr_ip         | svr_port | id   | zone  | inner_port | with_rootserver | status | block_migrate_in_time | build_version                                                                             | stop_time | start_service_time | first_sessid | with_partition | last_offline_time |
+----------------------------+----------------------------+----------------+----------+------+-------+------------+-----------------+--------+-----------------------+-------------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+
| 2025-10-27 15:44:38.260767 | 2025-10-27 16:02:36.175122 | 192.168.207.28 |     2882 |    1 | zone1 |       2881 |               1 | ACTIVE |                     0 | 4.2.5.4_104030022025070212-37927c3517f028002a34b40302f78cce88afdbd9(Jul  2 2025 12:21:09) |         0 |   1761552154538097 |            0 |              1 |                 0 |
+----------------------------+----------------------------+----------------+----------+------+-------+------------+-----------------+--------+-----------------------+-------------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+
1 row in set (0.002 sec)
#3

你将这些piece也加进去 再试下

#4

加了啊，还是提示一样，看前面的截图和记录。

image
image1650×88 7.07 KB

#5

piece_d1001xxxx 要加到每个piece的名字这一层

1 个赞
#6

确实是需要把日志都加进去，加了后正在恢复了，感谢感谢！

image
image1504×320 22.4 KB

image
image1265×354 8.35 KB 

obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE lnzyob FROM 'file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p80' WITH 'pool_list=lnzyob_pool';
ERROR 9011 (HY000): cannot find backup file
obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE lnzyob FROM 'file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog' WITH 'pool_list=lnzyob_pool';
ERROR 9011 (HY000): cannot find backup file
obclient(root@sys)[oceanbase]> 
obclient(root@sys)[oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p80';
Query OK, 0 rows affected (0.001 sec)

obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE lnzyob WITH 'pool_list=lnzyob_pool';
ERROR 4201 (HY000): No enough log for restore
obclient(root@sys)[oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p80,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p79';
Query OK, 0 rows affected (0.001 sec)

obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE lnzyob WITH 'pool_list=lnzyob_pool';
ERROR 4179 (HY000): restore tenant with existed tenant name is not allowed
obclient(root@sys)[oceanbase]> 
obclient(root@sys)[oceanbase]> DROP TENANT lnzyob;
Query OK, 0 rows affected (44.085 sec)

obclient(root@sys)[oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p80,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p79,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p78';
Query OK, 0 rows affected (0.001 sec)

obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE lnzyob WITH 'pool_list=lnzyob_pool';
Query OK, 0 rows affected (17.090 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM CDB_OB_RESTORE_PROGRESS\G
*************************** 1. row ***************************
           TENANT_ID: 1
              JOB_ID: 16
 RESTORE_TENANT_NAME: lnzyob
   RESTORE_TENANT_ID: 1004
  BACKUP_TENANT_NAME: lnzyob
    BACKUP_TENANT_ID: 1002
 BACKUP_CLUSTER_NAME: cls
         BACKUP_DEST: file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p80,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p79,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p78
      RESTORE_OPTION: pool_list=lnzyob_pool
         RESTORE_SCN: 1761452452330883000
 RESTORE_SCN_DISPLAY: 2025-10-26 12:20:52.330883
              STATUS: WAIT_TENANT_RESTORE_FINISH
     START_TIMESTAMP: 2025-10-27 16:52:25.667309
     BACKUP_SET_LIST: file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full
   BACKUP_PIECE_LIST: file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p78,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p79,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p80
         RECOVER_SCN: NULL
 RECOVER_SCN_DISPLAY: NULL
    RECOVER_PROGRESS: NULL
        TABLET_COUNT: NULL
 FINISH_TABLET_COUNT: NULL
    RESTORE_PROGRESS: NULL
         TOTAL_BYTES: NULL
 TOTAL_BYTES_DISPLAY: NULL
        FINISH_BYTES: NULL
FINISH_BYTES_DISPLAY: NULL
         DESCRIPTION: 
*************************** 2. row ***************************
           TENANT_ID: 1004
              JOB_ID: 16
 RESTORE_TENANT_NAME: lnzyob
   RESTORE_TENANT_ID: 1004
  BACKUP_TENANT_NAME: lnzyob
    BACKUP_TENANT_ID: 1002
 BACKUP_CLUSTER_NAME: cls
         BACKUP_DEST: file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p80,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p79,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p78
      RESTORE_OPTION: pool_list=lnzyob_pool
         RESTORE_SCN: 1761452452330883000
 RESTORE_SCN_DISPLAY: 2025-10-26 12:20:52.330883
              STATUS: RESTORING
     START_TIMESTAMP: 2025-10-27 16:52:25.667309
     BACKUP_SET_LIST: file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/data/backup_set_79_full
   BACKUP_PIECE_LIST: file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p78,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p79,file:///backup/obbackup/cls/1753162749/tenant_incarnation_1/1002/clog/piece_d1001r1p80
         RECOVER_SCN: 1761452452330883000
 RECOVER_SCN_DISPLAY: 2025-10-26 12:20:52.330883
    RECOVER_PROGRESS: 100.00
        TABLET_COUNT: 6046
 FINISH_TABLET_COUNT: 660
    RESTORE_PROGRESS: 10.91
         TOTAL_BYTES: 195702961375
 TOTAL_BYTES_DISPLAY: 182.26GB
        FINISH_BYTES: 0
FINISH_BYTES_DISPLAY: 0.00MB
         DESCRIPTION: 
2 rows in set (0.082 sec)

看着是在运行了

image
image745×495 15 KB