【 使用环境 】测试环境
【 OB】
【 使用版本 】4.3.5
【问题描述】提示备份超时？
【复现路径】
但是另外一个界面里边显示备份完成？是否是假象？
另外在视图里边看是success和complete的，在不做恢复的情况下，如何验证备份是好的呢？
[root@ob data]# obclient -h192.168.207.18 -P2881 -uroot@sys -p'linux2025.' -Doceanbase -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221524481
Server version: OceanBase 4.3.5.3 (r103040032025092501-bcea1d40bd48deb5da7b483709579d2f8ea84ee6) (Built Sep 25 2025 01:27:34)
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 CDB_OB_BACKUP_DELETE_TASK_HISTORY;
Empty set (0.108 sec)
obclient(root@sys)[oceanbase]> select BACKUP_SET_ID,START_TIMESTAMP,END_TIMESTAMP,STATUS,PATH FROM oceanbase.CDB_OB_BACKUP_SET_FILES;
+---------------+----------------------------+----------------------------+---------+----------------------------+
| BACKUP_SET_ID | START_TIMESTAMP | END_TIMESTAMP | STATUS | PATH |
+---------------+----------------------------+----------------------------+---------+----------------------------+
| 1 | 2025-10-29 13:23:54.969878 | 2025-10-29 14:18:49.743895 | SUCCESS | file:///backup/lnzyob/data |
| 2 | 2025-11-10 10:42:01.799105 | 2025-11-10 11:33:21.944992 | SUCCESS | file:///backup/lnzyob/data |
| 3 | 2025-11-14 11:31:39.747239 | 2025-11-14 12:19:21.404765 | SUCCESS | file:///backup/lnzyob/data |
| 4 | 2025-11-16 17:16:16.700891 | 2025-11-16 18:16:34.651781 | SUCCESS | file:///backup/lnzyob/data |
+---------------+----------------------------+----------------------------+---------+----------------------------+
4 rows in set (0.109 sec)
obclient(root@sys)[oceanbase]> select BACKUP_SET_ID,START_TIMESTAMP,END_TIMESTAMP,STATUS,PATH FROM CDB_OB_BACKUP_SET_FILES;
+---------------+----------------------------+----------------------------+---------+----------------------------+
| BACKUP_SET_ID | START_TIMESTAMP | END_TIMESTAMP | STATUS | PATH |
+---------------+----------------------------+----------------------------+---------+----------------------------+
| 1 | 2025-10-29 13:23:54.969878 | 2025-10-29 14:18:49.743895 | SUCCESS | file:///backup/lnzyob/data |
| 2 | 2025-11-10 10:42:01.799105 | 2025-11-10 11:33:21.944992 | SUCCESS | file:///backup/lnzyob/data |
| 3 | 2025-11-14 11:31:39.747239 | 2025-11-14 12:19:21.404765 | SUCCESS | file:///backup/lnzyob/data |
| 4 | 2025-11-16 17:16:16.700891 | 2025-11-16 18:16:34.651781 | SUCCESS | file:///backup/lnzyob/data |
+---------------+----------------------------+----------------------------+---------+----------------------------+
4 rows in set (0.015 sec)
obclient(root@sys)[oceanbase]> SELECT * FROM CDB_OB_BACKUP_DELETE_POLICY;
+-----------+-------------+-----------------+
| TENANT_ID | POLICY_NAME | RECOVERY_WINDOW |
+-----------+-------------+-----------------+
| 1002 | default | 7d |
+-----------+-------------+-----------------+
1 row in set (0.106 sec)
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASK_HISTORY\G
*************************** 1. row ***************************
TENANT_ID: 1002
TASK_ID: 1
JOB_ID: 1
INCARNATION: 1
BACKUP_SET_ID: 1
START_TIMESTAMP: 2025-10-29 13:23:54.969878
END_TIMESTAMP: 2025-10-29 14:18:49.743895
STATUS: COMPLETED
START_SCN: 1761715452030565000
END_SCN: 1761718720023072000
USER_LS_START_SCN: 1761715462002868000
ENCRYPTION_MODE: NONE
PASSWD:
INPUT_BYTES: 284822823607
OUTPUT_BYTES: 233298275234
OUTPUT_RATE_BYTES: 70808581.7207
EXTRA_META_BYTES: 0
TABLET_COUNT: 6152
FINISH_TABLET_COUNT: 6152
MACRO_BLOCK_COUNT: 135797
FINISH_MACRO_BLOCK_COUNT: 135797
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 0
RESULT: 0
COMMENT:
PATH: file:///backup/lnzyob/data
MINOR_TURN_ID: 1
MAJOR_TURN_ID: 1
*************************** 2. row ***************************
TENANT_ID: 1002
TASK_ID: 2
JOB_ID: 2
INCARNATION: 1
BACKUP_SET_ID: 2
START_TIMESTAMP: 2025-11-10 10:42:01.799105
END_TIMESTAMP: 2025-11-10 11:33:21.944992
STATUS: COMPLETED
START_SCN: 1762742531611400000
END_SCN: 1762745592455625000
USER_LS_START_SCN: 1762742541122915000
ENCRYPTION_MODE: NONE
PASSWD:
INPUT_BYTES: 234361965305
OUTPUT_BYTES: 197171565127
OUTPUT_RATE_BYTES: 64013709.8568
EXTRA_META_BYTES: 0
TABLET_COUNT: 6152
FINISH_TABLET_COUNT: 6152
MACRO_BLOCK_COUNT: 111740
FINISH_MACRO_BLOCK_COUNT: 111740
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 0
RESULT: 0
COMMENT:
PATH: file:///backup/lnzyob/data
MINOR_TURN_ID: 1
MAJOR_TURN_ID: 1
*************************** 3. row ***************************
TENANT_ID: 1002
TASK_ID: 3
JOB_ID: 3
INCARNATION: 1
BACKUP_SET_ID: 3
START_TIMESTAMP: 2025-11-14 11:31:39.747239
END_TIMESTAMP: 2025-11-14 12:19:21.404765
STATUS: COMPLETED
START_SCN: 1763091121723413000
END_SCN: 1763093951741047000
USER_LS_START_SCN: 1763091134999439000
ENCRYPTION_MODE: NONE
PASSWD:
INPUT_BYTES: 234403908819
OUTPUT_BYTES: 197172193003
OUTPUT_RATE_BYTES: 68901394.1087
EXTRA_META_BYTES: 0
TABLET_COUNT: 6152
FINISH_TABLET_COUNT: 6152
MACRO_BLOCK_COUNT: 111760
FINISH_MACRO_BLOCK_COUNT: 111760
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 0
RESULT: 0
COMMENT:
PATH: file:///backup/lnzyob/data
MINOR_TURN_ID: 1
MAJOR_TURN_ID: 1
*************************** 4. row ***************************
TENANT_ID: 1002
TASK_ID: 4
JOB_ID: 57
INCARNATION: 1
BACKUP_SET_ID: 4
START_TIMESTAMP: 2025-11-16 17:16:16.700891
END_TIMESTAMP: 2025-11-16 18:16:34.651781
STATUS: COMPLETED
START_SCN: 1763284590034814000
END_SCN: 1763288184614041000
USER_LS_START_SCN: 1763284603157180000
ENCRYPTION_MODE: NONE
PASSWD:
INPUT_BYTES: 234420683884
OUTPUT_BYTES: 197173651692
OUTPUT_RATE_BYTES: 54498708.7130
EXTRA_META_BYTES: 0
TABLET_COUNT: 6152
FINISH_TABLET_COUNT: 6152
MACRO_BLOCK_COUNT: 111768
FINISH_MACRO_BLOCK_COUNT: 111768
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 0
RESULT: 0
COMMENT:
PATH: file:///backup/lnzyob/data
MINOR_TURN_ID: 1
MAJOR_TURN_ID: 1
4 rows in set (0.088 sec)
[root@ob data]# pwd
/backup/lnzyob/data
[root@ob data]# ls -lt
total 8
drwx------. 2 root root 4096 Nov 16 18:16 backup_sets
drwx------. 5 root root 224 Nov 16 18:16 backup_set_4_full
drwx------. 5 root root 224 Nov 14 12:19 backup_set_3_full
drwx------. 5 root root 224 Nov 10 11:33 backup_set_2_full
-rw-------. 1 root root 140 Oct 29 13:23 format.obbak
drwx------. 2 root root 53 Oct 29 13:23 check_file
[root@ob data]# du -sh *
185G backup_set_2_full
185G backup_set_3_full
185G backup_set_4_full
28K backup_sets
4.0K check_file
4.0K format.obbak
[root@ob data]# date
Mon Nov 17 10:55:34 CST 2025