首批通过分布式安全可靠测评，为关键业务系统打造
dump_backup
更新时间：2026-04-16 00:11:36
编辑
分享
dump_backup 功能是 ob_admin 的一个子功能，可解析用于物理备份的数据备份内容。本文主要介绍 dump_backup 的几种用法。
help 命令
您可使用该命令输出 dump_backup 的使用方法。
./ob_admin dump_backup --help
输出为：
Usage: dump_backup command [command args] [options]
commands:
-h,--help display this message.
options:
-d,--backup-file-path absolute backup file path with file prefix
-s,--storage-info oss/cos should provide storage info
-f,--file-path relative data file path
-o,--offset data offset
-l,--length data length
-c,--check-exist check file is exist or not
samples:
dump meta:
ob_admin dump_backup -dfile:///home/admin/backup_info
dump macro:
ob_admin dump_backup -dfile:///home/admin/macro_block_1.0 -o1024 -l2048
dump data with -f:
ob_admin dump_backup -f/home/admin/macro_block_1.0 -o1024 -l2048
dump data with -s:
ob_admin dump_backup -d'oss://home/admin/backup_info' -s'host=xxx.com&access_id=111&access_key=222'
选项说明如下：
| 选项名 | 是否必选 | 数据类型 | 默认值 | 说明 |
|---|---|---|---|---|
| -d/--backup-file-path | 是 | 字符串 | 无 | 指定数据备份文件的绝对路径。 |
| -s/--storage-info | 否 | 字符串 | 无 | 指定对象存储的 Host 地址和验证信息。验证信息包含访问 ID（access_id）和访问密钥（access_key），对于 Amazon S3 服务，还需明确指定区域（s3_region）。 |
| -f/--file-path | 否 | 字符串 | 无 | 指定数据备份文件的相对路径。
注意该选项已废弃，请勿配置。 |
| -o/--offset | 否 | 整型 | 0 | 设置读取偏移量，根据指定的数据备份文件不同有如下两种情况：
|
| -l/--length | 否 | 整型 | 0 | 设置读取长度，根据指定的数据备份文件不同有如下两种情况：
|
| -c/--check-exist | 否 | 布尔型 | false | 控制是否检查数据备份文件是否存在。指定该选项时，命令将检查输入的数据备份文件是否存在，若文件存在将打印 true，反之则打印 false。 |
使用示例
查看当前租户的全量备份信息
./ob_admin dump_backup -d'file:///home/admin/backup/ob_backup_oracle_tenant/data/backup_set_1_full/tenant_backup_set_infos.obbak
输出为：
------------------------------{Backup Common Header}------------------------------
| data_type|27
| header_version|1
| data_version|1
| compressor_type|1
| header_length|48
| header_checksum|-3262
| data_length|173
| data_zlength|173
| data_checksum|3011330068
| align_length|0
--------------------------------------------------------------------------------
------------------------------{tenant backup set infos}------------------------------
| 1|{backup_set_id:1, incarnation:1, tenant_id:1002, dest_id:1001, backup_type:{type:1}, plus_archivelog:false, date:20230224, prev_full_backup_set_id:0, prev_inc_backup_set_id:0, stats:{input_bytes:24003314, output_bytes:24003314, tablet_count:1106, finish_tablet_count:1106, macro_block_count:251, finish_macro_block_count:251, extra_bytes:0, finish_file_count:0}, start_time:1677225213079065, end_time:0, status:1, result:0, encryption_mode:0, passwd:"", file_status:0, backup_path:"file:///data/test/user_backup/ob_backup_oracle_tenant/data", start_replay_scn:{val:1677225090023122807}, min_restore_scn:{val:1677225275520986000}, tenant_compatible:17179934720, backup_compatible:1, data_turn_id:1, meta_turn_id:1}
查看日志流元信息
$./ob_admin dump_backup -d'file:///home/admin/backup/ob_backup_oracle_tenant/data/backup_set_1_full/logstream_1/meta_info_turn_1_retry_0/ls_meta_info.obbak
输出为：
------------------------------{Backup File Header}------------------------------
| magic|-1410727888
| version|0
| file_type|65536
| compressor_type|0
--------------------------------------------------------------------------------
查看 major 宏块索引
$./ob_admin dump_backup -d'file:///home/admin/backup/ob_backup_oracle_tenant/data/backup_set_1_full/infos/data_info_turn_1/tenant_major_data_macro_range_index.0.obbak
输出为：
------------------------------{Backup File Header}------------------------------
| magic|7967
| version|1
| file_type|1
| compressor_type|0
--------------------------------------------------------------------------------
------------------------------{Backup Common Header}------------------------------
| data_type|4
| header_version|1
| data_version|0
| compressor_type|1
| header_length|48
| header_checksum|-30018
| data_length|3637
| data_zlength|3637
| data_checksum|1987640562
| align_length|0
--------------------------------------------------------------------------------
------------------------------{Backup Multi Level Index Header}------------------------------
| magic|-1
| backup_type|4
| index_level|0
--------------------------------------------------------------------------------
------------------------------{Backup Macro Range Index}------------------------------
| start_key:tablet_id|1
| start_key:logic_version|1677225092915334139
| start_key:data_seq|0
| end_key:tablet_id|1
| end_key:logic_version|1677225092915334139
| end_key:data_seq|0
| backup_set_id|1
| ls_id|1
| turn_id|1
| retry_id|0
| file_id|0
| offset|9183232
| length|2463
--------------------------------------------------------------------------------
------------------------------{Backup Macro Range Index}------------------------------
| start_key:tablet_id|3
| start_key:logic_version|1677225092915334139
| start_key:data_seq|0
| end_key:tablet_id|3
| end_key:logic_version|1677225092915334139
| end_key:data_seq|0
| backup_set_id|1
| ls_id|1
| turn_id|1
| retry_id|0
| file_id|0
| offset|9183232
| length|2463
--------------------------------------------------------------------------------
······
------------------------------{Backup Macro Range Index}------------------------------
| start_key:tablet_id|1152921504606846977
| start_key:logic_version|1677225092915334139
| start_key:data_seq|0
| end_key:tablet_id|1152921504606846977
| end_key:logic_version|1677225092915334139
| end_key:data_seq|0
| backup_set_id|1
| ls_id|1001
| turn_id|1
| retry_id|0
| file_id|0
| offset|36864
| length|136
--------------------------------------------------------------------------------
------------------------------{Backup Common Header}------------------------------
| data_type|0
| header_version|1
| data_version|0
| compressor_type|1
| header_length|48
| header_checksum|-28423
| data_length|96
| data_zlength|96
| data_checksum|1663955940
| align_length|0
--------------------------------------------------------------------------------
------------------------------{Backup Multi Level Index Header}------------------------------
| magic|-1
| backup_type|0
| index_level|1
--------------------------------------------------------------------------------
------------------------------{Backup Macro Range Index Index}------------------------------
| end_key:start_key|{data_seq:0, logic_version:1677225092915334139, tablet_id:1152921504606846977}
| end_key:end_key|{data_seq:0, logic_version:1677225092915334139, tablet_id:1152921504606846977}
| end_key:backup_set_id|1
| end_key:ls_id|1001
| end_key:turn_id|1
| end_key:retry_id|0
| end_key:file_id|0
| end_key:offset|36864
| end_key:length|136
| offset|4096
| length|3685
--------------------------------------------------------------------------------
------------------------------{Index File Trailer}------------------------------
| file_type|0
| tree_height|1
| last_block_offset|7781
| last_block_length|144
| checksum|7924
--------------------------------------------------------------------------------
查看备份集诊断信息
./ob_admin dump_backup -d'file:///home/admin/backup/ob_backup_oracle_tenant/data/backup_set_1_full/infos/diagnose_info.obbak
输出为：
------------------------------{Backup Common Header}------------------------------
| data_type|13
| header_version|1
| data_version|1
| compressor_type|1
| header_length|48
| header_checksum|991
| data_length|300
| data_zlength|300
| data_checksum|2397211904
| align_length|0
--------------------------------------------------------------------------------
------------------------------{diagnose info}------------------------------
------------------------------{locality info}------------------------------
| tenant_id|1002
| tenant_name|backup_oracle_tenant
| backup_set_id|1
| cluster_id|1
| cluster_name|ob_cluster_01
| compat_mode|1
| locality|FULL{1}@z1, FULL{1}@z2, FULL{1}@z3
| primary_zone|z1;z2,z3
--------------------------------------------------------------------------------
------------------------------{backup set info}------------------------------
| tenant_id|1002
| backup_set_id|1
| dest_id|1001
| incarnation|1
| backup_type|FULL
| backup_date|20230224
| prev_full_backup_set_id|0
| prev_inc_backup_set_id|0
| input_bytes|24003314
| output_bytes|24003314
| tablet_count|1106
| finish tablet count|1106
| macro block count|251
| finish macro block count|251
| extra_meta_bytes|0
| finish file count|0
| start_time|1677225213079065
| end_time|1677225276556635
| status|1
| result|0
| encryption_mode|0
| passwd|
| file_status|0
| backup_path|file:///data/test/user_backup/ob_backup_oracle_tenant/data
| start_replay_scn|1677225090023122807
| min_restore_scn|1677225275520986000
| tenant_compatible|17179934720
| backup_compatible|1
| meta_turn_id|1
| data_turn_id|1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
查看所有日志流的 meta 集合
./ob_admin dump_backup -d'file:///home/admin/backup/ob_backup_oracle_tenant/data/backup_set_1_full/infos/meta_info/ls_meta_infos.obbak
输出为：
------------------------------{Backup Common Header}------------------------------
| data_type|13
| header_version|1
| data_version|1
| compressor_type|1
| header_length|48
| header_checksum|991
| data_length|300
| data_zlength|300
| data_checksum|2397211904
| align_length|0
--------------------------------------------------------------------------------
------------------------------{diagnose info}------------------------------
------------------------------{locality info}------------------------------
| tenant_id|1002
| tenant_name|backup_oracle_tenant
| backup_set_id|1
| cluster_id|1
| cluster_name|ob_cluster_01
| compat_mode|1
| locality|FULL{1}@z1, FULL{1}@z2, FULL{1}@z3
| primary_zone|z1;z2,z3
--------------------------------------------------------------------------------
------------------------------{backup set info}------------------------------
| tenant_id|1002
| backup_set_id|1
| dest_id|1001
| incarnation|1
| backup_type|FULL
| backup_date|20230224
| prev_full_backup_set_id|0
| prev_inc_backup_set_id|0
| input_bytes|24003314
| output_bytes|24003314
| tablet_count|1106
| finish tablet count|1106
| macro block count|251
| finish macro block count|251
| extra_meta_bytes|0
| finish file count|0
| start_time|1677225213079065
| end_time|1677225276556635
| status|1
| result|0
| encryption_mode|0
| passwd|
| file_status|0
| backup_path|file:///data/test/user_backup/ob_backup_oracle_tenant/data
| start_replay_scn|1677225090023122807
| min_restore_scn|1677225275520986000
| tenant_compatible|17179934720
| backup_compatible|1
| meta_turn_id|1
| data_turn_id|1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
查看全量备份起始占位符
./ob_admin dump_backup -d'file:///home/admin/backup/ob_backup_oracle_tenant/data/backup_sets/backup_set_1_full_start.obbak
输出为：
------------------------------{Backup Common Header}------------------------------
| data_type|23
| header_version|1
| data_version|1
| compressor_type|1
| header_length|48
| header_checksum|22833
| data_length|6
| data_zlength|6
| data_checksum|2748775104
| align_length|0
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
查看租户资源配置及副本分布信息
阿里云 OSS
NFS
AWS S3
兼容 S3 协议的对象存储
./ob_admin dump_backup -d'oss://oceanbase-test-bucket/backup/data/backup_set_1_full/infos/locality_info.obbak' -s'host=***.aliyun-inc.com&access_id=***&access_key=***'
./ob_admin dump_backup -d'file:///data/nfs/backup/data/backup_set_1_full/infos/locality_info.obbak'
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/data/data/backup_set_1_full/infos/locality_info.obbak' -s'host=s3.***.amazonaws.com&access_id=****&access_key=****&s3_region=****'
OBS
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/data/backup_set_1_full/infos/locality_info.obbak' -s'host=obs.****.myhuaweicloud.com&access_id=****&access_key=****'GCS
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/data/backup_set_1_full/infos/locality_info.obbak' -s'host=https://storage.googleapis.com&access_id=****&access_key=****'COS
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/data/backup_set_1_full/infos/locality_info.obbak' -s'host=cos.ap-xxxx.myqcloud.com&access_id=***&access_key=***'
输出结果如下：
------------------------------{locality info}------------------------------
| tenant_id|1002
| tenant_name|backup_oracle_tenant
| backup_set_id|1
| cluster_id|1
| cluster_name|ob1.xxxxx.xxx
| compat_mode|1
| locality|FULL{1}@z1, FULL{1}@z2, FULL{1}@z3
| primary_zone|z1;z2,z3
| sys_time_zone|+08:00
| resource_pool_list|
| 1|{ "resource_name: samll_pool01, zone_list:z1, unit_count: 2, unit: {unit_name: small_unit01, unit_max_cpu: 1.00, unit_min_cpu: 1.00, unit_memory_size:2147483648, unit_log_disk_size:6442450944, unit_max_iops: 9223372036854775807,unit_min_iops:9223372036854775807, iops_weight:1}}
| 2|{ "resource_name: samll_pool02, zone_list:z2, unit_count: 2, unit: {unit_name: small_unit01, unit_max_cpu: 1.00, unit_min_cpu: 1.00, unit_memory_size:2147483648, unit_log_disk_size:6442450944, unit_max_iops: 9223372036854775807,unit_min_iops:9223372036854775807, iops_weight:1}}
--------------------------------------------------------------------------------
查看租户级配置项信息
阿里云 OSS
NFS
AWS S3
兼容 S3 协议的对象存储
./ob_admin dump_backup -d'oss://oceanbase-test-bucket/backup/data/backup_set_1_full/infos/tenant_parameter.obbak' -s'host=***.aliyun-inc.com&access_id=***&access_key=***'
./ob_admin dump_backup -d'file:///data/nfs/backup/data/backup_set_1_full/infos/tenant_parameter.obbak'
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/data/backup_set_1_full/infos/tenant_parameter.obbak' -s'host=s3.***.amazonaws.com&access_id=****&access_key=****&s3_region=****'
OBS
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/data/backup_set_1_full/infos/tenant_parameter.obbak' -s'host=obs.****.myhuaweicloud.com&access_id=****&access_key=****'GCS
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/data/backup_set_1_full/infos/tenant_parameter.obbak' -s'host=https://storage.googleapis.com&access_id=****&access_key=****'COS
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/data/backup_set_1_full/infos/tenant_parameter.obbak' -s'host=cos.ap-xxxx.myqcloud.com&access_id=***&access_key=***&appid=***'
输出结果的示例如下：
------------------------------ {parameter_list}------------------------------
| 0|{name:balancer_idle_time, value:20s}
| 1|{name:compaction_dag_cnt_limit, value:18000}
| 2|{name:compaction_high_thread_score, value:10}
| 3|{name:ha_high_thread_score, value:10}
| 4|{name:ha_low_thread_score, value:10}
| 5|{name:ha_mid_thread_score, value:10}
| 6|{name:log_archive_concurrency, value:8}
--------------------------------------------------------------------------------
查看集群级配置项信息
阿里云 OSS
NFS
AWS S3
兼容 S3 协议的对象存储
./ob_admin dump_backup -d'oss://oceanbase-test-bucket/backup/cluster_parameters/cluster_parameter.20241018T140609.obbak' -s'host=***.aliyun-inc.com&access_id=***&access_key=***'
./ob_admin dump_backup -d'file:///data/nfs/backup/cluster_parameters/cluster_parameter.20241018T140609.obbak'
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/cluster_parameters/cluster_parameter.20241018T140609.obbak' -s'host=s3.***.amazonaws.com&access_id=****&access_key=****&s3_region=****'
OBS
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/cluster_parameters/cluster_parameter.20241018T140609.obbak' -s'host=obs.****.myhuaweicloud.com&access_id=****&access_key=****'GCS
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/cluster_parameters/cluster_parameter.20241018T140609.obbak' -s'host=https://storage.googleapis.com&access_id=****&access_key=****'COS
./ob_admin dump_backup -d's3://oceanbase-test-bucket/backup/cluster_parameters/cluster_parameter.20241018T140609.obbak' -s'host=cos.ap-xxxx.myqcloud.com&access_id=***&access_key=***&appid=***'
输出结果的示例如下：
------------------------------ {parameter_list}------------------------------
| 0|{name:enable_async_syslog, value:0}
| 1|{name:enable_record_trace_log, value:0}
| 2|{name:min_observer_version, value:4.2.5.0}
| 3|{name: resource_hard_limit, value:1000}
| 4|{name:_backup_idle_time, value:10s}
| 5|{name:_enable_dbms_job_package, value:0}
| 6|{name:_restore_idle_time, value:10s}
--------------------------------------------------------------------------------
常用文件说明
本节介绍在执行 dump_backup 命令时常用的数据备份文件。其中 ${backup_data_path} 表示指定的备份路径，您需根据实际配置进行替换，详细介绍可参见 配置备份目的端。
| 文件目录 | 描述 |
|---|---|
| ${backup_data_path}/backup_set_1_full/ | 全量备份集 |
| ${backup_data_path}/backup_set_1_full/backup_set_1_full_20230111T193330_20230111T193420.obbak | 占位符，展示全量备份的开始和结束时间 |
| ${backup_data_path}/backup_set_1_full/single_backup_set_info.obbak | 当前备份集的元信息 |
| ${backup_data_path}/backup_set_1_full/tenant_backup_set_infos.obbak | 当前租户的全量备份集信息 |
| ${backup_data_path}/backup_set_1_full/infos/table_list | 全量表名文件 |
| ${backup_data_path}/backup_set_1_full/infos/table_list/table_list.1702352553000000000.1.obbak | 快照点 1 的表名文件 1 |
| ${backup_data_path}/backup_set_1_full/infos/table_list/table_list.1702352553000000000.2.obbak | 快照点 1 的表名文件 2 |
| ${backup_data_path}/backup_set_1_full/infos/table_list/table_list_meta_info.1702352553000000000.obbak | 快照点 1 的表名元信息文件 |
| ${backup_data_path}/backup_set_1_full/infos/major_data_info_turn_1/ | major turn 1 下的租户级备份文件 |
| ${backup_data_path}/backup_set_1_full/infos/major_data_info_turn_1/tablet_log_stream_info.obbak | tablet 与日志流映射文件 |
| ${backup_data_path}/backup_set_1_full/infos/major_data_info_turn_1/tenant_major_data_macro_range_index.0.obbak | major 宏块索引 |
| ${backup_data_path}/backup_set_1_full/infos/major_data_info_turn_1/tenant_major_data_meta_index.0.obbak | major meta 索引 |
| ${backup_data_path}/backup_set_1_full/infos/major_data_info_turn_1/tenant_major_data_sec_meta_index.0.obbak | major 逻辑 ID 与物理 ID 映射 |
| ${backup_data_path}/backup_set_1_full/infos/minor_data_info_turn_1/ | minor turn 1 下的租户级备份文件 |
| ${backup_data_path}/backup_set_1_full/infos/minor_data_info_turn_1/tablet_log_stream_info.obbak | tablet 与日志流映射文件 |
| ${backup_data_path}/backup_set_1_full/infos/minor_data_info_turn_1/tenant_minor_data_macro_range_index.0.obbak | minor 宏块索引 |
| ${backup_data_path}/backup_set_1_full/infos/minor_data_info_turn_1/tenant_minor_data_meta_index.0.obbak | minor meta 索引 |
| ${backup_data_path}/backup_set_1_full/infos/minor_data_info_turn_1/tenant_minor_data_sec_meta_index.0.obbak | minor 逻辑 ID 与物理 ID 映射 |
| ${backup_data_path}/backup_set_1_full/infos/diagnose_info.obbak | 备份集诊断信息文件 |
| ${backup_data_path}/backup_set_1_full/infos/tenant_parameter.obbak | 当前租户的租户级配置项信息 |
| ${backup_data_path}/backup_set_1_full/infos/locality_info.obbak | 当前备份集的所属租户的 Locality 信息，包含当前租户的资源分布信息和副本分布信息 |
| ${backup_data_path}/backup_set_1_full/infos/meta_info/ls_attr_info.1.obbak | 备份时的日志流列表快照 |
| ${backup_data_path}/backup_set_1_full/infos/meta_info/ls_meta_infos.obbak | 所有日志流的 meta 集合 |
| ${backup_data_path}/backup_set_1_full/logstream_1/ | 1 号日志流 |
| ${backup_data_path}/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/ | turn 1，retry 0 下的基线数据 |
| ${backup_data_path}/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/macro_block_data.0.obbak | 一个数据文件，512MB~4GB |
| ${backup_data_path}/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/macro_range_index.obbak | macro 索引 |
| ${backup_data_path}/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/meta_index.obbak | meta 索引 |
| ${backup_data_path}/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/sec_meta_index.obbak | 逻辑 ID 与物理 ID 映射文件 |
| ${backup_data_path}/backup_set_1_full/logstream_1/meta_info_turn_1_retry_0/ | turn 1，retry 0 下的日志流元信息文件 |
| ${backup_data_path}/backup_set_1_full/logstream_1/meta_info_turn_1_retry_0/ls_meta_info.obbak | 日志流元信息 |
| ${backup_data_path}/backup_set_1_full/logstream_1/meta_info_turn_1_retry_0/tablet_info.1.obbak | 日志流 tablet meta 列表 |
| ${backup_data_path}/backup_set_1_full/logstream_1/minor_data_turn_1_retry_0/ | turn 1，retry 0 下的转储数据 |
| ${backup_data_path}/backup_set_1_full/logstream_1/sys_data_turn_1_retry_0/ | turn 1，retry 0 下的系统 tablet 数据 |
| ${backup_data_path}/backup_set_1_full/logstream_1001/ | 日志流 1001 |
| ${backup_data_path}/backup_sets/ | 数据备份列表的汇总目录，记录了所有的数据备份集列表 |
| ${backup_data_path}/backup_sets/backup_set_1_full_end_success_20230111T193420.obbak | 全量备份结束占位符 |
| ${backup_data_path}/backup_sets/backup_set_1_full_start.obbak | 全量备份起始占位符 |
| ${backup_data_path}/backup_sets/backup_set_2_inc_start.obbak | 增量备份起始占位符 |
| ${backup_data_path}/backup_sets/backup_set_2_inc_end_success_20230111T194420.obbak | 增量备份结束占位符 |
| ${backup_data_path}/check_file/1002_connect_file_20230111T193020.obbak | 连通性检查文件 |
| ${backup_data_path}/format.obbak | 备份路径的格式化信息 |
| ${backup_data_path}/cluster_parameter.20241018T140609.obbak | 集群级配置项信息 |
