dump_backup | OceanBase 文档中心

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
        -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'
        ob_admin dump_backup -d'cos://home/admin/backup_info' -s'host=xxx.com&access_id=111&access_key=222&appid=333'

参数说明：

-d 代表绝对路径，即需要指定备份数据的绝对路径。
-f 代表相对路径，指定相对路径。

使用示例

查看当前租户的全量备份信息

./ob_admin dump_backup -dfile:///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 -dfile:///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 -dfile:///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 -dfile:///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 -dfile:///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 -dfile:///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
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------

常用文件说明

文件目录	描述
/data/backup_set_1_full/	全量备份集
/data/backup_set_1_full/backup_set_1_full_20230111T193330_20230111T193420.obbak	占位符，展示全量备份的开始和结束时间
/data/backup_set_1_full/infos/data_info_turn_1/	turn 1 下的租户级备份文件
/data/backup_set_1_full/infos/data_info_turn_1/tablet_log_stream_info.obbak	tablet 与日志流映射文件
/data/backup_set_1_full/infos/data_info_turn_1/tenant_major_data_macro_range_index.0.obbak	major 宏块索引
/data/backup_set_1_full/infos/data_info_turn_1/tenant_major_data_meta_index.0.obbak	major meta 索引
/data/backup_set_1_full/infos/data_info_turn_1/tenant_major_data_sec_meta_index.0.obbak	major 逻辑 ID 与物理 ID 映射
/data/backup_set_1_full/infos/data_info_turn_1/tenant_minor_data_macro_range_index.0.obbak	minor 宏块索引
/data/backup_set_1_full/infos/data_info_turn_1/tenant_minor_data_meta_index.0.obbak	minor meta 索引
/data/backup_set_1_full/infos/data_info_turn_1/tenant_minor_data_sec_meta_index.0.obbak	minor 逻辑 ID 与物理 ID 映射
/data/backup_set_1_full/infos/diagnose_info.obbak	备份集诊断信息文件
/data/backup_set_1_full/infos/locality_info.obbak	当前备份集的所属租户的 Locality 信息
/data/backup_set_1_full/infos/locality_info.obbak	当前备份集的所属租户的 Locality 信息
/data/backup_set_1_full/infos/meta_info/ls_attr_info.1.obbak	备份时的日志流列表快照
/data/backup_set_1_full/infos/meta_info/ls_meta_infos.obbak	所有日志流的 meta 集合
/data/backup_set_1_full/logstream_1/	日志流 1
/data/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/	turn 1，retry 0 下的基线数据
/data/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/macro_block_data.0.obbak	一个数据文件，512MB~4GB
/data/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/macro_range_index.obbak	macro 索引
/data/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/meta_index.obbak	meta 索引
/data/backup_set_1_full/logstream_1/major_data_turn_1_retry_0/sec_meta_index.obbak	逻辑 ID 与物理 ID 映射文件
/data/backup_set_1_full/logstream_1/meta_info_turn_1_retry_0/	turn 1，retry 0 下的日志流元信息文件
/data/backup_set_1_full/logstream_1/meta_info_turn_1_retry_0/ls_meta_info.obbak	日志流元信息
/data/backup_set_1_full/logstream_1/minor_data_turn_1_retry_0/	turn 1,retry 0 下的转储数据
/data/backup_set_1_full/logstream_1/sys_data_turn_1_retry_0/	turn 1, retry 0 下的系统 tablet 数据
/data/backup_set_1_full/logstream_1001/	日志流 1001
/data/backup_set_1_full/single_backup_set_info.obbak	当前备份集的元信息
/data/backup_set_1_full/tenant_backup_set_infos.obbak	当前租户的全量备份集信息
/data/backup_sets/	backup set 占位符，用于 list
/data/backup_sets/backup_set_1_full_end_success_20230111T193420.obbak	全量备份结束占位符
/data/backup_sets/backup_set_1_full_start.obbak	全量备份起始占位符
/data/backup_sets/backup_set_2_inc_start.obbak	增量备份起始占位符
/data/backup_sets/backup_set_2_inc_end_success_20230111T194420.obbak	增量备份结束占位符
/data/check_file/1002_connect_file_20230111T193020.obbak	连通性检查文件
/data/format.obbak	备份路径的格式化信息