ob版本：4.2.1.6
ocp: 4.3.5-20250303105901社区版
这个ob是obd部署的，用OCP接管过来的。在OCP上有备份文件，也有日志备份，但是恢复的时候就显示最近 180 天无可恢复时间。
选择备份时间后，提交恢复报错：
解析备份文件异常，内容为[OCP UnexpectedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=BACKUP_FILE_DUMP_FILE_ERROR, args=[1000002],file:///backup/obbackup/test/gqoceanbase/1735210625/tenant_incarnation_1/1014/data
这个日志文件发一下/tmp/ob_admin.log ocp-server.log发一下 看看
这三个信息 sys租户 查一下
SELECT * FROM oceanbase.CDB_OB_BACKUP_SET_FILES;
SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG; – 关注 STATUS/CHECKPOINT_SCN
SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_POLICY;
mysql> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG\G
*************************** 1. row ***************************
TENANT_ID: 1014
DEST_ID: 1003
ROUND_ID: 2
INCARNATION: 1
DEST_NO: 0
STATUS: DOING
START_SCN: 1786587573251826273
START_SCN_DISPLAY: 2026-08-13 10:19:33.251826
CHECKPOINT_SCN: 1786601820436030746
CHECKPOINT_SCN_DISPLAY: 2026-08-13 14:17:00.436030
COMPATIBLE: 1
BASE_PIECE_ID: 2
USED_PIECE_ID: 2
PIECE_SWITCH_INTERVAL: 86400000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 106923829
INPUT_BYTES_DISPLAY: 101.97MB
OUTPUT_BYTES: 106923829
OUTPUT_BYTES_DISPLAY: 101.97MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
COMMENT:
PATH: file:///backup/obbackup/test/gqoceanbase/1735210625/tenant_incarnation_1/1014/clog
1 row in set (0.01 sec)
mysql> SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_POLICY\G
*************************** 1. row ***************************
TENANT_ID: 1014
POLICY_NAME: default
RECOVERY_WINDOW: 7d
1 row in set (0.01 sec)
mysql> SELECT * FROM oceanbase.CDB_OB_BACKUP_SET_FILES\G
*************************** 1. row ***************************
TENANT_ID: 1014
BACKUP_SET_ID: 1
DEST_ID: 1002
INCARNATION: 1
BACKUP_TYPE: FULL
PREV_FULL_BACKUP_SET_ID: 0
PREV_INC_BACKUP_SET_ID: 0
START_TIMESTAMP: 2026-08-13 10:11:23.436543
END_TIMESTAMP: 2026-08-13 10:13:52.610542
STATUS: SUCCESS
FILE_STATUS: AVAILABLE
ELAPSED_SECONDES: 149
PLUS_ARCHIVELOG: OFF
START_REPLAY_SCN: 1786587052842841642
START_REPLAY_SCN_DISPLAY: 2026-08-13 10:10:52.842841
MIN_RESTORE_SCN: 1786587232555585223
MIN_RESTORE_SCN_DISPLAY: 2026-08-13 10:13:52.555585223
INPUT_BYTES: 1081278932
OUTPUT_BYTES: 457115479
OUTPUT_RATE_BYTES: 3064310.6846
EXTRA_META_BYTES: 0
TABLET_COUNT: 760
FINISH_TABLET_COUNT: 760
MACRO_BLOCK_COUNT: 515
FINISH_MACRO_BLOCK_COUNT: 515
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 0
RESULT: 0
COMMENT:
ENCRYPTION_MODE: NONE
PASSWD:
TENANT_COMPATIBLE: 4.2.1.6
BACKUP_COMPATIBLE: 3
PATH: file:///app/backup/obdata/gqoceanbase/1735210625/tenant_incarnation_1/1014/data
CLUSTER_VERSION: 4.2.1.6
CONSISTENT_SCN: 1786587121580790954
MINOR_TURN_ID: 1
MAJOR_TURN_ID: 1
*************************** 2. row ***************************
TENANT_ID: 1014
BACKUP_SET_ID: 2
DEST_ID: 1004
INCARNATION: 1
BACKUP_TYPE: FULL
PREV_FULL_BACKUP_SET_ID: 0
PREV_INC_BACKUP_SET_ID: 0
START_TIMESTAMP: 2026-08-13 10:22:03.572680
END_TIMESTAMP: 2026-08-13 10:24:23.835371
STATUS: SUCCESS
FILE_STATUS: AVAILABLE
ELAPSED_SECONDES: 140
PLUS_ARCHIVELOG: OFF
START_REPLAY_SCN: 1786587573251826273
START_REPLAY_SCN_DISPLAY: 2026-08-13 10:19:33.251826
MIN_RESTORE_SCN: 1786587863813476074
MIN_RESTORE_SCN_DISPLAY: 2026-08-13 10:24:23.813476074
INPUT_BYTES: 1066597893
OUTPUT_BYTES: 454022700
OUTPUT_RATE_BYTES: 3236945.5966
EXTRA_META_BYTES: 0
TABLET_COUNT: 760
FINISH_TABLET_COUNT: 760
MACRO_BLOCK_COUNT: 508
FINISH_MACRO_BLOCK_COUNT: 508
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 0
RESULT: 0
COMMENT:
ENCRYPTION_MODE: NONE
PASSWD:
TENANT_COMPATIBLE: 4.2.1.6
BACKUP_COMPATIBLE: 3
PATH: file:///backup/obbackup/test/gqoceanbase/1735210625/tenant_incarnation_1/1014/data
CLUSTER_VERSION: 4.2.1.6
CONSISTENT_SCN: 1786587762734633215
MINOR_TURN_ID: 1
MAJOR_TURN_ID: 1
*************************** 3. row ***************************
TENANT_ID: 1014
BACKUP_SET_ID: 3
DEST_ID: 1004
INCARNATION: 1
BACKUP_TYPE: INC
PREV_FULL_BACKUP_SET_ID: 2
PREV_INC_BACKUP_SET_ID: 2
START_TIMESTAMP: 2026-08-13 10:49:54.488943
END_TIMESTAMP: 2026-08-13 10:52:20.898145
STATUS: SUCCESS
FILE_STATUS: AVAILABLE
ELAPSED_SECONDES: 146
PLUS_ARCHIVELOG: OFF
START_REPLAY_SCN: 1786587573251826273
START_REPLAY_SCN_DISPLAY: 2026-08-13 10:19:33.251826
MIN_RESTORE_SCN: 1786589540857978472
MIN_RESTORE_SCN_DISPLAY: 2026-08-13 10:52:20.857978472
INPUT_BYTES: 116588711
OUTPUT_BYTES: 17567084
OUTPUT_RATE_BYTES: 119986.2014
EXTRA_META_BYTES: 0
TABLET_COUNT: 760
FINISH_TABLET_COUNT: 760
MACRO_BLOCK_COUNT: 511
FINISH_MACRO_BLOCK_COUNT: 55
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 0
RESULT: 0
COMMENT:
ENCRYPTION_MODE: NONE
PASSWD:
TENANT_COMPATIBLE: 4.2.1.6
BACKUP_COMPATIBLE: 3
PATH: file:///backup/obbackup/test/gqoceanbase/1735210625/tenant_incarnation_1/1014/data
CLUSTER_VERSION: 4.2.1.6
CONSISTENT_SCN: 1786589444226477597
MINOR_TURN_ID: 1
MAJOR_TURN_ID: 1
*************************** 4. row ***************************
TENANT_ID: 1014
BACKUP_SET_ID: 4
DEST_ID: 1004
INCARNATION: 1
BACKUP_TYPE: FULL
PREV_FULL_BACKUP_SET_ID: 0
PREV_INC_BACKUP_SET_ID: 0
START_TIMESTAMP: 2026-08-13 10:53:39.386527
END_TIMESTAMP: 2026-08-13 10:55:57.725091
STATUS: SUCCESS
FILE_STATUS: AVAILABLE
ELAPSED_SECONDES: 138
PLUS_ARCHIVELOG: OFF
START_REPLAY_SCN: 1786587573251826273
START_REPLAY_SCN_DISPLAY: 2026-08-13 10:19:33.251826
MIN_RESTORE_SCN: 1786589757696934190
MIN_RESTORE_SCN_DISPLAY: 2026-08-13 10:55:57.696934190
INPUT_BYTES: 1068695240
OUTPUT_BYTES: 454088281
OUTPUT_RATE_BYTES: 3282441.7709
EXTRA_META_BYTES: 0
TABLET_COUNT: 760
FINISH_TABLET_COUNT: 760
MACRO_BLOCK_COUNT: 509
FINISH_MACRO_BLOCK_COUNT: 509
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 0
RESULT: 0
COMMENT:
ENCRYPTION_MODE: NONE
PASSWD:
TENANT_COMPATIBLE: 4.2.1.6
BACKUP_COMPATIBLE: 3
PATH: file:///backup/obbackup/test/gqoceanbase/1735210625/tenant_incarnation_1/1014/data
CLUSTER_VERSION: 4.2.1.6
CONSISTENT_SCN: 1786589645863303988
MINOR_TURN_ID: 1
MAJOR_TURN_ID: 1
4 rows in set (0.01 sec)
export LD_LIBRARY_PATH=/home/admin/gqoceanbase/oceanbase/lib:$LD_LIBRARY_PATH && export OB_ADMIN_LOG_DIR=/tmp && /home/admin/gqoceanbase/oceanbase/bin/ob_admin dump_backup -c -d file:///app/backup/obdata/gqoceanbase/1735210625/tenant_incarnation_1/1014/data 2>&1
执行一下这个命令 再把这个文件发一下 /tmp/ob_admin.log
看了日志 8 月 7 日～8 月 13 日 10:11 这整段时间既没有数据备份也没有归档日志的 可恢复时间是 真正存在备份 + 连续归档的时刻起算的 才才可以恢复的
这个命令执行一下 看看什么错 之前的日志打印不全
按照正常算的话 23456备份集 应该显示的
