oracle dump

SQL> select name from v$datafile;                                                                                                                                     

NAME
------------------------------------------------------------------------------------------
/opt/oracle/oradata/duxiu/system02.dbf
/opt/oracle/oradata/duxiu/undotbs01.dbf
/opt/oracle/oradata/duxiu/sysaux01.dbf
/opt/oracle/oradata/duxiu/users01.dbf
/opt/oracle/oradata/duxiu/test01.dbf
/opt/oracle/oradata/duxiu/test02.dbf
/opt/oracle/oradata/duxiu/test04.dbf

7 rows selected.

SQL> create tablespace lijiwei datafile '/opt/oracle/oradata/duxiu/lijiwei.dbf' size 50M;                                                                             

Tablespace created.

SQL> create table scott.li0 tablespace lijiwei as select * from scott.emp;                                                                                            

Table created.

SQL> select SEGMENT_NAME,SEGMENT_TYPE,HEADER_BLOCK,BLOCKS,EXTENTS from dba_segments where TABLESPACE_NAME='LIJIWEI';                                                  

SEGMENT_NAME                                       SEGMENT_TYPE       HEADER_BLOCK     BLOCKS    EXTENTS
-------------------------------------------------- ------------------ ------------ ---------- ----------
LI0                                                TABLE                        11          8          1

SQL> select SEGMENT_NAME,HEADER_BLOCK,BLOCKS,EXTENTS from dba_segments where TABLESPACE_NAME='LIJIWEI';                                                               

SEGMENT_NAME                                       HEADER_BLOCK     BLOCKS    EXTENTS
-------------------------------------------------- ------------ ---------- ----------
LI0                                                          11          8          1

SQL> alter system dump datafile 8 BLOCK MIN 1 BLOCK MAX 12;                                                                                                           

System altered.

 

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

Block 1 (file header) not dumped: use dump file header command

 

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

buffer tsn: 14 rdba: 0x02000002 (8/2)
scn: 0x0000.00dbed62 seq: 0x02 flg: 0x04 tail: 0xed621d02
frmt: 0x02 chkval: 0xbadc type: 0x1d=KTFB Bitmapped File Space Header

File Space Header Block:
Header Control:
RelFno: 8, Unit: 8, Size: 6400, Flag: 1

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

buffer tsn: 14 rdba: 0x02000003 (8/3)
scn: 0x0000.00dbed62 seq: 0x01 flg: 0x04 tail: 0xed621e01
frmt: 0x02 chkval: 0x4d38 type: 0x1e=KTFB Bitmapped File Space Bitmap

File Space Bitmap Block:
BitMap Control:
RelFno: 8, BeginBlock: 9, Flag: 0, First: 1, Free: 63487

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

buffer tsn: 14 rdba: 0x02000004 (8/4)
scn: 0x0000.00dbed0d seq: 0x01 flg: 0x00 tail: 0xed0d1e01
frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap

File Space Bitmap Block:
BitMap Control:
RelFno: 8, BeginBlock: 507913, Flag: 0, First: 0, Free: 63488

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

buffer tsn: 14 rdba: 0x02000005 (8/5)
scn: 0x0000.00dbed0f seq: 0x01 flg: 0x00 tail: 0xed0f1e01
frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitma

File Space Bitmap Block:
BitMap Control:
RelFno: 8, BeginBlock: 1015817, Flag: 0, First: 0, Free: 63488

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

buffer tsn: 14 rdba: 0x02000006 (8/6)
scn: 0x0000.00dbed11 seq: 0x01 flg: 0x00 tail: 0xed111e01
frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap

File Space Bitmap Block:
BitMap Control:
RelFno: 8, BeginBlock: 1523721, Flag: 0, First: 0, Free: 63488

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

buffer tsn: 14 rdba: 0x02000007 (8/7)
scn: 0x0000.00dbed13 seq: 0x01 flg: 0x00 tail: 0xed131e01
frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap

File Space Bitmap Block:
BitMap Control:
RelFno: 8, BeginBlock: 2031625, Flag: 0, First: 0, Free: 63488

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

buffer tsn: 14 rdba: 0x02000008 (8/8)
scn: 0x0000.00dbed15 seq: 0x01 flg: 0x00 tail: 0xed151e01
frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap

File Space Bitmap Block:
BitMap Control:
RelFno: 8, BeginBlock: 2539529, Flag: 0, First: 0, Free: 63488

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

buffer tsn: 14 rdba: 0x02000009 (8/9)
scn: 0x0000.00dbed69 seq: 0x02 flg: 0x04 tail: 0xed692002
frmt: 0x02 chkval: 0x94df type: 0x20=FIRST LEVEL BITMAP BLOCK

Dump of First Level Bitmap Block
 --------------------------------
   nbits : 4 nranges: 1         parent dba:  0x0200000a   poffset: 0    
   unformatted: 4       total: 8         first useful block: 3     
   owning instance : 1
   instance ownership changed at
   Last successful Search
   Freeness Status:  nf1 0      nf2 0      nf3 0      nf4 0     
 
   Extent Map Block Offset: 4294967295
   First free datablock : 4     
   Bitmap block lock opcode 0
   Locker xid:     :  0x0000.000.00000000
   Inc #: 0 Objd: 66365
  HWM Flag: HWM Set
      Highwater::  0x0200000d  ext#: 0      blk#: 4      ext size: 8    
  #blocks in seg. hdr's freelists: 0    
  #blocks below: 4    
  mapblk  0x00000000  offset: 0    
  --------------------------------------------------------
  DBA Ranges :
  --------------------------------------------------------
   0x02000009  Length: 8      Offset: 0     
 
   0:Metadata   1:Metadata   2:Metadata   3:FULL
   4:unformatted   5:unformatted   6:unformatted   7:unformatted
  --------------------------------------------------------

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

buffer tsn: 14 rdba: 0x0200000a (8/10)
scn: 0x0000.00dbed64 seq: 0x01 flg: 0x04 tail: 0xed642101
frmt: 0x02 chkval: 0x86cb type: 0x21=SECOND LEVEL BITMAP BLOCK

Dump of Second Level Bitmap Block
   number: 1       nfree: 1       ffree: 0      pdba:     0x0200000b
   Inc #: 0 Objd: 66365
  opcode:0
 xid:
  L1 Ranges :
  --------------------------------------------------------
   0x02000009  Free: 5 Inst: 1
 
  --------------------------------------------------------
buffer tsn: 14 rdba: 0x0200000b (8/11)
scn: 0x0000.00dbed6d seq: 0x01 flg: 0x04 tail: 0xed6d2301
frmt: 0x02 chkval: 0xa868 type: 0x23=PAGETABLE SEGMENT HEADER

Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      spare2: 0      #extents: 1      #blocks: 8    
                  last map  0x00000000  #maps: 0      offset: 2716 
      Highwater::  0x0200000d  ext#: 0      blk#: 4      ext size: 8    
  #blocks in seg. hdr's freelists: 0    
  #blocks below: 4    
  mapblk  0x00000000  offset: 0    
                   Unlocked
  --------------------------------------------------------
  Low HighWater Mark :
      Highwater::  0x0200000d  ext#: 0      blk#: 4      ext size: 8    
  #blocks in seg. hdr's freelists: 0    
  #blocks below: 4    
  mapblk  0x00000000  offset: 0    
  Level 1 BMB for High HWM block: 0x02000009
  Level 1 BMB for Low HWM block: 0x02000009
  --------------------------------------------------------
  Segment Type: 1 nl2: 1      blksz: 8192   fbsz: 0     
  L2 Array start offset:  0x00001434
  First Level 3 BMB:  0x00000000
  L2 Hint for inserts:  0x0200000a
  Last Level 1 BMB:  0x02000009
  Last Level II BMB:  0x0200000a
  Last Level III BMB:  0x00000000
     Map Header:: next  0x00000000  #extents: 1    obj#: 66365  flag: 0x10000000
  Inc # 0
  Extent Map
  -----------------------------------------------------------------
   0x02000009  length: 8    
 
  Auxillary Map
  --------------------------------------------------------
   Extent 0     :  L1 dba:  0x02000009 Data dba:  0x0200000c
  --------------------------------------------------------
 
   Second Level Bitmap block DBAs
   --------------------------------------------------------
   DBA 1:   0x0200000a

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

buffer tsn: 14 rdba: 0x0200000c (8/12)
scn: 0x0000.00dbed69 seq: 0x02 flg: 0x04 tail: 0xed690602
frmt: 0x02 chkval: 0x3dce type: 0x06=trans data

Block header dump:  0x0200000c
 Object id on Block? Y
 seg/obj: 0x1033d  csc: 0x00.dbed68  itc: 3  flg: E  typ: 1 - DATA
     brn: 0  bdba: 0x2000009 ver: 0x01 opc: 0
     inc: 0  exflg: 0
 
 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0xffff.000.00000000  0x00000000.0000.00  C---    0  scn 0x0000.00dbed68
0x02   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
0x03   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
 
data_block_dump,data header at 0xeba727c
===============
tsiz: 0x1f80
hsiz: 0x16
pbl: 0x0eba727c
bdba: 0x0200000c
     76543210
flag=--------
ntab=1
nrow=2
frre=-1
fsbo=0x16
fseo=0x1f2d
avsp=0x1f17
tosp=0x1f17
0xe:pti[0]      nrow=2  offs=0
0x12:pri[0]     offs=0x1f58
0x14:pri[1]     offs=0x1f2d
block_row_dump:
tab 0, row 0, @0x1f58
tl: 40 fb: --H-FL-- lb: 0x0  cc: 8
col  0: [ 3]  c2 4a 46
col  1: [ 6]  c0 ee bc cc ce b0
col  2: [ 5]  43 4c 45 52 4b
col  3: [ 3]  c2 50 03
col  4: [ 7]  77 b4 0c 11 01 01 01
col  5: [ 3]  c2 0a 16
col  6: *NULL*
col  7: [ 2]  c1 15
tab 0, row 1, @0x1f2d
tl: 43 fb: --H-FL-- lb: 0x0  cc: 8
col  0: [ 3]  c2 4b 64
col  1: [ 5]  41 4c 4c 45 4e
col  2: [ 8]  53 41 4c 45 53 4d 41 4e
col  3: [ 3]  c2 4d 63
col  4: [ 7]  77 b5 02 14 01 01 01
col  5: [ 2]  c2 11
col  6: [ 2]  c2 04
col  7: [ 2]  c1 1f
end_of_block_dump
End dump data blocks tsn: 14 file#: 8 minblk 2 maxblk 12
*** 2013-04-22 16:19:18.359
DUMP OF DATA FILES: 8 files in database

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

 

SQL> alter system set events 'immediate trace name file_hdrs level 3';                                                                                                

System altered.

 DATA FILE #8:
  (name #12) /opt/oracle/oradata/duxiu/lijiwei.dbf
creation size=6400 block size=8192 status=0xe head=12 tail=12 dup=1
 tablespace 14, index=10 krfil=8 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:2 scn: 0x0000.00dbed09 04/22/2013 16:05:28
 Stop scn: 0xffff.ffffffff 04/22/2013 16:05:27
 Creation Checkpointed at scn:  0x0000.00dbed08 04/22/2013 16:05:27
 thread:1 rba:(0x62.154e.10)

 

Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
 V10 STYLE FILE HEADER:
        Compatibility Vsn = 169869568=0xa200100
        Db ID=1418004073=0x54850669, Db Name='DUXIU'
        Activation ID=0=0x0
        Control Seq=1923224=0x1d5898, File size=6400=0x1900
        File Number=8, Blksiz=8192, File Type=3 DATA
Tablespace #14 - LIJIWEI  rel_fn:8
Creation   at   scn: 0x0000.00dbed08 04/22/2013 16:05:27
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
 reset logs count:0x30517a17 scn: 0x0000.00b74051 reset logs terminal rcv data:0x0 scn: 0x0000.00000000
 prev reset logs count:0x2e53932b scn: 0x0000.0006ce7b prev reset logs terminal rcv data:0x0 scn: 0x0000.00000000
 recovered at 01/01/1988 00:00:00
 status:0x4 root dba:0x00000000 chkpt cnt: 2 ctl cnt:1
begin-hot-backup file size: 0
Checkpointed at scn:  0x0000.00dbed09 04/22/2013 16:05:28