文档课题：运用bbed查数据文件头部记录的控制文件seq号.
1、定义测试文件
--为方便测试，定义一个文件，将数据文件查询出来，放到参数文件中.
[oracle@leo-oracle-11g ~]$ vi parameter.txt
blocksize=8192

listfile=dbfiles.txt

mode=edit
[oracle@leo-oracle-11g ~]$ vi dbfiles.txt
1       /u01/app/oracle/oradata/orcl/system01.dbf       817889280

2       /u01/app/oracle/oradata/orcl/sysaux01.dbf       534773760

3       /u01/app/oracle/oradata/orcl/undotbs01.dbf      529530880

4       /u01/app/oracle/oradata/orcl/users01.dbf        5242880
说明：如上内容为通过以下语句查询所得.
select file# || chr(9) || name || chr(9) || bytes from v$datafile;
2、BBED确认SEQ
--以4号文件users01.dbf作为测试文件.
BBED> set file 4
        FILE#           4

BBED> set block 1
        BLOCK#          1

--查看block里面的信息.
BBED> map /v
 File: /u01/app/oracle/oradata/orcl/users01.dbf (4)
 Block: 1                                     Dba:0x01000001
------------------------------------------------------------
 Data File Header

 struct kcvfh, 860 bytes                    @0       
    struct kcvfhbfh, 20 bytes               @0       
    struct kcvfhhdr, 76 bytes               @20      
    ub4 kcvfhrdb                            @96      
    struct kcvfhcrs, 8 bytes                @100     
    ub4 kcvfhcrt                            @108     
    ub4 kcvfhrlc                            @112     
    struct kcvfhrls, 8 bytes                @116     
    ub4 kcvfhbti                            @124     
    struct kcvfhbsc, 8 bytes                @128     
    ub2 kcvfhbth                            @136     
    ub2 kcvfhsta                            @138     
    struct kcvfhckp, 36 bytes               @484     
    ub4 kcvfhcpc                            @140     
    ub4 kcvfhrts                            @144     
    ub4 kcvfhccc                            @148     
    struct kcvfhbcp, 36 bytes               @152     
    ub4 kcvfhbhz                            @312     
    struct kcvfhxcd, 16 bytes               @316     
    sword kcvfhtsn                          @332     
    ub2 kcvfhtln                            @336     
    text kcvfhtnm[30]                       @338     
    ub4 kcvfhrfn                            @368     
    struct kcvfhrfs, 8 bytes                @372     
    ub4 kcvfhrft                            @380     
    struct kcvfhafs, 8 bytes                @384     
    ub4 kcvfhbbc                            @392     
    ub4 kcvfhncb                            @396     
    ub4 kcvfhmcb                            @400     
    ub4 kcvfhlcb                            @404     
    ub4 kcvfhbcs                            @408     
    ub2 kcvfhofb                            @412     
    ub2 kcvfhnfb                            @414     
    ub4 kcvfhprc                            @416     
    struct kcvfhprs, 8 bytes                @420     
    struct kcvfhprfs, 8 bytes               @428     
    ub4 kcvfhtrt                            @444     

 ub4 tailchk                                @8188    

说明：
struct kcvfhbfh, 20 bytes               @0       
struct kcvfhhdr, 76 bytes               @20      
ub4 kcvfhrdb                            @96     
如以上三条：
struct kcvfhbfh, 20 bytes   @0   表示：从0 bite到19bite
struct kcvfhhdr, 76 bytes      @20  表示：从20到75bite
若想查询kcvfhhdr 这76 bite具体信息，使用命令：print kcvfhhdr

BBED> print kcvfhhdr
struct kcvfhhdr, 76 bytes                   @20      
   ub4 kccfhswv                             @20       0x00000000
   ub4 kccfhcvn                             @24       0x0b200400
   ub4 kccfhdbi                             @28       0x62dd1e14
   text kccfhdbn[0]                         @32      O
   text kccfhdbn[1]                         @33      R
   text kccfhdbn[2]                         @34      C
   text kccfhdbn[3]                         @35      L
   text kccfhdbn[4]                         @36       
   text kccfhdbn[5]                         @37       
   text kccfhdbn[6]                         @38       
   text kccfhdbn[7]                         @39       
   ub4 kccfhcsq                             @40       0x0000054b
   ub4 kccfhfsz                             @44       0x00000280
   s_blkz kccfhbsz                          @48       0x00
   ub2 kccfhfno                             @52       0x0004
   ub2 kccfhtyp                             @54       0x0003
   ub4 kccfhacid                            @56       0x00000000
   ub4 kccfhcks                             @60       0x00000000
   text kccfhtag[0]                         @64       
   text kccfhtag[1]                         @65       
   text kccfhtag[2]                         @66       
   text kccfhtag[3]                         @67       
   text kccfhtag[4]                         @68       
   text kccfhtag[5]                         @69       
   text kccfhtag[6]                         @70       
   text kccfhtag[7]                         @71       
   text kccfhtag[8]                         @72       
   text kccfhtag[9]                         @73       
   text kccfhtag[10]                        @74       
   text kccfhtag[11]                        @75       
   text kccfhtag[12]                        @76       
   text kccfhtag[13]                        @77       
   text kccfhtag[14]                        @78       
   text kccfhtag[15]                        @79       
   text kccfhtag[16]                        @80       
   text kccfhtag[17]                        @81       
   text kccfhtag[18]                        @82       
   text kccfhtag[19]                        @83       
   text kccfhtag[20]                        @84       
   text kccfhtag[21]                        @85       
   text kccfhtag[22]                        @86       
   text kccfhtag[23]                        @87       
   text kccfhtag[24]                        @88       
   text kccfhtag[25]                        @89       
   text kccfhtag[26]                        @90       
   text kccfhtag[27]                        @91       
   text kccfhtag[28]                        @92       
   text kccfhtag[29]                        @93       
   text kccfhtag[30]                        @94       
   text kccfhtag[31]                        @95       
说明：如上所示，(ub4 kccfhcsq @40 0x0000054b)包含数据文件头部记录的控制文件seq信息，0x0000054b转换为10进制为1355.
3、x$kcvfh确认SEQ
--通过表x$kcvfh查询数据文件头部记录的控制文件seq信息
[oracle@leo-oracle-11g ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 8 23:52:00 2023

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@orcl> select hxfil,fhcsq,fhscn,fhrba_seq from x$kcvfh;

     HXFIL      FHCSQ FHSCN             FHRBA_SEQ
---------- ---------- ---------------- ----------
         1       1355 2050421                  31
         2       1707 2050421                  31
         3       1355 2050421                  31
         4       1355 2050421                  31

说明：如上，4号文件的fhcsq为控制文件的seq号，数值是吻合的.