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