使用bbed编辑研究oracle数据块结构(三)

2014-11-24 08:53:37 · 作者: · 浏览: 2
0000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000       <32 bytes per line>      BBED> set dba 0x01400001    DBA 0x01400001 (20971521 5,1)      BBED> find /c TBS3    File: /home/app/oraten/oradata/oraten/tbs301.dbf (5)    Block: 1 Offsets: 338 to 849 Dba:0x01400001   ------------------------------------------------------------------------    54425333 00000000 00000000 00000000 00000000 00000000 00000000 00000500    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00001bd5 3c33a9ec 05000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 0000a82a 0b000000 00008e05 4c330100    00001300 0000fd00 00001000 00000200 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000d00 0d000d00 01000000 00000000    00000000 00000200 40010000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000       <32 bytes per line>   我们知道,在bbed中file#指的是listfile文件中各个数据文件的变化,并不是数据字典中各个数据文件的file#,那么bbed是如何根据DBA来定位文件和数据块的那?原来在每个数据文件的头部的kccfhfno位置存储着该文件在数据库中的文件编号。如
  
BBED> p kcvfhhdr 
  struct kcvfhhdr, 76 bytes                   @20      
     ub4 kccfhswv                             @20       0x00000000
     ub4 kccfhcvn                             @24       0x0a200500
     ub4 kccfhdbi                             @28       0xda0e3a18
     text kccfhdbn[0]                         @32      O
     text kccfhdbn[1]                         @33      R
     text kccfhdbn[2]                         @34      A
     text kccfhdbn[3]                         @35      T
     text kccfhdbn[4]                         @36      E
     text kccfhdbn[5]                         @37      N
     text kccfhdbn[6]                         @38       
     text kccfhdbn[7]                         @39       
     ub4 kccfhcsq                             @40       0x000006f3
     ub4 kccfhfsz                             @44       0x00000500
     s_blkz kccfhbsz                          @48       0x00
     ub2 kccfhfno                             @52       0x0005
     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    
  

Set file name

设定当前编辑的数据文件,文件名称用单引号括起来
BBED> set filename '/home/app/oraten/oradata/oraten/tbs101.dbf'
	FILENAME       	/home/app/oraten/oradata/oraten/tbs101.dbf

Set width

设定当前的屏幕宽度,如果没有设定,默认为80,例如
BBED> set width 120
	WIDTH          	120

Set ibase

设置与bbed交互的数字格式(仅仅是交互格式),默认为10进制,也可以设置为其他,如hex 等
BBED> set ibase hex
	IBASE          	Hex

BBED>