ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dump 段头

dump 段头

原创 Linux操作系统 作者:admincy 时间:2019-05-05 12:24:04 0 删除 编辑

 

1.       定位出segment header的数据块

 

select segment_name, header_file, header_block
         from dba_segments
         where segment_name =
'EMPLOYEES';

 

2.    dump

  alter system dump datafile 5 block 83;

 

 

3. 如果是回滚段的话,还可用以下命令dump _SYSSMU1$为段名

   alter system dump undo header '_SYSSMU1$';

3. udump下找出对应的trace文件。内容如下

 

*** 2009-01-19 14:26:34.348

*** SERVICE NAME:(SYS$USERS) 2009-01-19 14:26:34.302

*** SESSION ID:(133.57) 2009-01-19 14:26:34.302

Start dump data blocks tsn: 6 file#: 5 minblk 83 maxblk 83

buffer tsn: 6 rdba: 0x01400053 (5/83)

scn: 0x0000.000831f3 seq: 0x01 flg: 0x04 tail: 0x31f32301

frmt: 0x02 chkval: 0x63bd type: 0x23=PAGETABLE SEGMENT HEADER

Hex dump of block: st=0, typ_found=1

Dump of memory from 0x07E52200 to 0x07E54200

 

。。。。。。。

  Extent Control Header

  -----------------------------------------------------------------

  Extent Header:: spare1: 0      spare2: 0      #extents: 1      #blocks: 8    

                  last map  0x00000000  #maps: 0      offset: 2716 

      Highwater::  0x01400059  ext#: 0      blk#: 8      ext size: 8    

  #blocks in seg. hdr's freelists: 0    

  #blocks below: 5    

  mapblk  0x00000000  offset: 0    

                   Unlocked

  --------------------------------------------------------

  Low HighWater Mark :

      Highwater::  0x01400059  ext#: 0      blk#: 8      ext size: 8    

  #blocks in seg. hdr's freelists: 0    

  #blocks below: 5    

  mapblk  0x00000000  offset: 0    

  Level 1 BMB for High HWM block: 0x01400051

  Level 1 BMB for Low HWM block: 0x01400051

  --------------------------------------------------------

  Segment Type: 1 nl2: 1      blksz: 8192   fbsz: 0     

  L2 Array start offset:  0x00001434

  First Level 3 BMB:  0x00000000

  L2 Hint for inserts:  0x01400052

  Last Level 1 BMB:  0x01400051

  Last Level II BMB:  0x01400052

  Last Level III BMB:  0x00000000

     Map Header:: next  0x00000000  #extents: 1    obj#: 51258  flag: 0x10000000

  Inc # 0

  Extent Map

  -----------------------------------------------------------------

   0x01400051  length: 8    

 

  Auxillary Map

  --------------------------------------------------------

   Extent 0     :  L1 dba:  0x01400051 Data dba:  0x01400054

  --------------------------------------------------------

 

   Second Level Bitmap block DBAs

   --------------------------------------------------------

   DBA 1:   0x01400052

 

End dump data blocks tsn: 6 file#: 5 minblk 83 maxblk 83

 

 

 

 

 

 

 

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30821/viewspace-541415/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-17

  • 博文量
    18
  • 访问量
    14775