oracle_bbed.Datafile.Header_System.資料檔案頭資訊
BBED> show
FILE# 1
BLOCK# 1
OFFSET 0
DBA 0x00400001 (4194305 1,1)
FILENAME /u01/app/oracle/oradata/sunner/system01.dbf
BIFILE bifile.bbd
LISTFILE /home/oracle/file.txt
BLOCKSIZE 8192
MODE Edit
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL No
BBED> map
File: /u01/app/oracle/oradata/sunner/system01.dbf (1)
Block: 1 Dba:0x00400001
------------------------------------------------------------
Data File Header
struct kcvfh, 676 bytes @0
ub4 tailchk @8188
MAP[/v] [ DBA | FILENAME | FILE | BLOCK ]
顯示指定位置的頭尾 offset
BBED> p kcvfh
struct kcvfh, 676 bytes @0 -- 檔案頭kcvfh 676 bytes
struct kcvfhbfh, 20 bytes @0 -- 結構kcvfhbfh 20 bytes
ub1 type_kcbh @0 0x0b -- block header type 11
ub1 frmt_kcbh @1 0xa2 -- format 162
ub1 spare1_kcbh @2 0x00 --
ub1 spare2_kcbh @3 0x00 --
ub4 rdba_kcbh @4 0x00400001 -- relative database block address
ub4 bas_kcbh @8 0x00000000 --
ub2 wrp_kcbh @12 0x0000 --
ub1 seq_kcbh @14 0x01 -- 序列 壞塊標記為0xff
ub1 flg_kcbh @15 0x04(KCBHFCKV)-- 標誌
ub2 chkval_kcbh @16 0x76d2 -- 塊校驗值
ub2 spare3_kcbh @18 0x0000 --
struct kcvfhhdr, 76 bytes @20 -- 結構kcvfhhdr 76 bytes
ub4 kccfhswv @20 0x00000000 --
ub4 kccfhcvn @24 0x0a200100 --
ub4 kccfhdbi @28 0xa69be42f -- dbid
text kccfhdbn[0] @32 S --
text kccfhdbn[1] @33 U --
text kccfhdbn[2] @34 N --
text kccfhdbn[3] @35 N --
text kccfhdbn[4] @36 E --
text kccfhdbn[5] @37 R --
text kccfhdbn[6] @38 --
text kccfhdbn[7] @39 --
ub4 kccfhcsq @40 0x0000041b -- controlfile sequence
ub4 kccfhfsz @44 0x0000f000 -- blocks
s_blkz kccfhbsz @48 0x00 --
ub2 kccfhfno @52 0x0001 -- 相對檔案號
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 kcvfhrdb @96 0x00400179 -- 相關
struct kcvfhcrs, 8 bytes @100 --
ub4 kscnbas @100 0x00000009 -- file$.CRSCNBAS creation SCN base
ub2 kscnwrp @104 0x0000 -- file$.crscnwrp creation SCN wrap
ub4 kcvfhcrt @108 0x2184ef93 -- 建立時間
ub4 kcvfhrlc @112 0x2ff9bad5 --
struct kcvfhrls, 8 bytes @116 --
ub4 kscnbas @116 0x4000ac47 --
ub2 kscnwrp @120 0x0000 --
ub4 kcvfhbti @124 0x00000000 --
struct kcvfhbsc, 8 bytes @128 --
ub4 kscnbas @128 0x00000000 --
ub2 kscnwrp @132 0x0000 --
ub2 kcvfhbth @136 0x0000 --
ub2 kcvfhsta @138 0x2004(KCVFHOFZ)--
struct kcvfhckp, 36 bytes @484 --
struct kcvcpscn, 8 bytes @484 -- 當前檢查點SCN
ub4 kscnbas @484 0x4004ab21 --
ub2 kscnwrp @488 0x0000 --
ub4 kcvcptim @492 0x300152ff -- 當前檢查點時間
ub2 kcvcpthr @496 0x0001 --
union u, 12 bytes @500 --
struct kcvcprba,12 bytes @500 --
ub4 kcrbaseq @500 0x0000000e -- recover 需要的下一個日誌序列號
ub4 kcrbabno @504 0x00000002 -- rba block no
ub2 kcrbabof @508 0x0010 -- rba bytes offset
ub1 kcvcpetb[0] @512 0x02 --
ub1 kcvcpetb[1] @513 0x00 --
ub1 kcvcpetb[2] @514 0x00 --
ub1 kcvcpetb[3] @515 0x00 --
ub1 kcvcpetb[4] @516 0x00 --
ub1 kcvcpetb[5] @517 0x00 --
ub1 kcvcpetb[6] @518 0x00 --
ub1 kcvcpetb[7] @519 0x00 --
ub4 kcvfhcpc @140 0x00000088 -- scn of last change to the datafile
ub4 kcvfhrts @144 0x300152fd --
ub4 kcvfhccc @148 0x00000087 -- time of the last chage to the datafile
struct kcvfhbcp, 36 bytes @152 --
struct kcvcpscn, 8 bytes @152 --
ub4 kscnbas @152 0x00000000 --
ub2 kscnwrp @156 0x0000 --
ub4 kcvcptim @160 0x00000000 --
ub2 kcvcpthr @164 0x0000 --
union u, 12 bytes @168 --
struct kcvcprba, 12 bytes @168 --
ub4 kcrbaseq @168 0x00000000 --
ub4 kcrbabno @172 0x00000000 --
ub2 kcrbabof @176 0x0000 -- checkpoint count
ub1 kcvcpetb[0] @180 0x00 --
ub1 kcvcpetb[1] @181 0x00 --
ub1 kcvcpetb[2] @182 0x00 --
ub1 kcvcpetb[3] @183 0x00 --
ub1 kcvcpetb[4] @184 0x00 --
ub1 kcvcpetb[5] @185 0x00 --
ub1 kcvcpetb[6] @186 0x00 --
ub1 kcvcpetb[7] @187 0x00 --
ub4 kcvfhbhz @312 0x00000000 --
struct kcvfhxcd, 16 bytes @316 --
ub4 space_kcvmxcd[0] @316 0x00000000 --
ub4 space_kcvmxcd[1] @320 0x00000000 --
ub4 space_kcvmxcd[2] @324 0x00000000 --
ub4 space_kcvmxcd[3] @328 0x00000000 --
word kcvfhtsn @332 0 --
ub2 kcvfhtln @336 0x0006 --
text kcvfhtnm[0] @338 S --
text kcvfhtnm[1] @339 Y --
text kcvfhtnm[2] @340 S --
text kcvfhtnm[3] @341 T --
text kcvfhtnm[4] @342 E --
text kcvfhtnm[5] @343 M --
text kcvfhtnm[6] @344 --
text kcvfhtnm[7] @345 --
text kcvfhtnm[8] @346 --
text kcvfhtnm[9] @347 --
text kcvfhtnm[10] @348 --
text kcvfhtnm[11] @349 --
text kcvfhtnm[12] @350 --
text kcvfhtnm[13] @351 --
text kcvfhtnm[14] @352 --
text kcvfhtnm[15] @353 --
text kcvfhtnm[16] @354 --
text kcvfhtnm[17] @355 --
text kcvfhtnm[18] @356 --
text kcvfhtnm[19] @357 --
text kcvfhtnm[20] @358 --
text kcvfhtnm[21] @359 --
text kcvfhtnm[22] @360 --
text kcvfhtnm[23] @361 --
text kcvfhtnm[24] @362 --
text kcvfhtnm[25] @363 --
text kcvfhtnm[26] @364 --
text kcvfhtnm[27] @365 --
text kcvfhtnm[28] @366 --
text kcvfhtnm[29] @367 --
ub4 kcvfhrfn @368 0x00000001 -- 相對檔案號
struct kcvfhrfs, 8 bytes @372 --
ub4 kscnbas @372 0x00000000 --
ub2 kscnwrp @376 0x0000 --
ub4 kcvfhrft @380 0x00000000 -- the time which the recovery
-- of this file will be complete
struct kcvfhafs, 8 bytes @384 --
ub4 kscnbas @384 0x00000000 --
ub2 kscnwrp @388 0x0000 --
ub4 kcvfhbbc @392 0x00000000 --
ub4 kcvfhncb @396 0x00000000 --
ub4 kcvfhmcb @400 0x00000000 --
ub4 kcvfhlcb @404 0x00000000 --
ub4 kcvfhbcs @408 0x00000000 --
ub2 kcvfhofb @412 0x000a --
ub2 kcvfhnfb @414 0x000a --
ub4 kcvfhprc @416 0x2ff9955d -- prev checkpoint
struct kcvfhprs, 8 bytes @420 --
ub4 kscnbas @420 0x00083bee --
ub2 kscnwrp @424 0x0000 --
struct kcvfhprfs, 8 bytes @428 --
ub4 kscnbas @428 0x00000000 --
ub2 kscnwrp @432 0x0000 --
ub4 kcvfhtrt @444 0x00000000 --
檢視需要檢視
我們在分析問題，檢視效能是的時候，需檢視特定v$，甚至是x$。
通過SELECT * FROM v$fixed_view_definition 可以查詢指定v$的x$來源。
我們這裡使用的表x$kcvfh:
SQL> desc x$kcvfh;
Name
-------------------
ADDR -- Adderss 唯一標識
INDX -- Indx 表內序列
INST_ID -- Inst_id 例項ID
HXFIL -- 十六進位制的檔案號
HXONS -- Online狀態 0表示"offline",其他表示"Online"
HXSTS -- 應該是狀態標記(offline，值發生變化)
HXERR -- 錯誤程式碼 0 null ...
HXVER -- format,indicates format of block 6,7,8 indicats oracle version 6,7,8
-- 0 indicate not determined (the header could not be read)
FHSWV -- swap vsn
FHCVN -- compatible vsn
FHDBI -- database DBID
FHDBN -- database name
FHCSQ -- controlfile sequence number
FHFSZ -- current block size in blocks(bytes/block_size)
FHBSZ -- block size
FHFNO -- file number
FHTYP -- 1 controlfile 2 redo file 3 validate db file, normal data index undo file
FHRDB -- root dba,occurs in file# 1 (bootstrap$)
FHCRS -- creation_time
FHCRT -- create timestamp
FHRLC -- resetlog_time
FHRLC_I -- resetlog count
FHRLS -- resetlogs_change#
FHPRC -- prev resetlogs timestamp
FHPRC_I -- prev resetlogs count
FHPRS -- prev resegtlog scn
FHBTI -- "begin backup" update the backup start
FHBSC -- "begin backup" system change number
FHBTH -- "begin backup" update thread
FHSTA -- status of datafile,file# 1 is 8186 ,others is 4 ,indicates online status
FHSCN -- datafile_header checkpoint_change#
FHTIM -- checkpoint_time
FHTHR -- thread number
FHRBA_SEQ -- redo file sequence number
FHRBA_BNO -- redo file block number
FHRBA_BOF -- bytes offset:the bytes offset into the block at which the redo record start
FHETB -- extent bytes
FHCPC -- datafile checkpoint_count
FHRTS -- recover timestamp
FHCCC -- controlfile checkpoint count
FHBCP_SCN -- "hot backup" backup checkpoint scn
FHBCP_TIM -- "hot backup" backup timestamp
FHBCP_THR -- "hot backup" threads
FHBCP_RBA_SEQ -- "hot backup" redo file sequence number
FHBCP_RBA_BNO -- "hot backup" redo file block number
FHBCP_RBA_BOF -- "hot backup" bytes offset
FHBCP_ETB -- "hot backup" extent bytes
FHBHZ -- begin hot backup file
FHXCD -- extent cache id
FHTSN -- tablespace number
FHTNM -- tablespace name
FHRFN -- relative file number
FHAFS -- absolute fuzzy scn:minimum pitr scn
FHRFS -- the scn which the recovery of this file will be complete
FHRFT -- the time which the recovery of this file will be complete
HXIFZ -- file is fuzzy(yes/no)
HXNRCV -- file need media recover(yes/no)
HXFNM -- datafile name
FHPOFB -- prev old file block
FHPNFB -- prev new file block
FHPRE10 -- prev 10
FHFIRSTUNRECSCN -- unrecoverable_change#
FHFIRSTUNRECTIM -- unrecoverable_time
HXLMDBA -- space header:the amount of block is being used the amount of block is free
HXLMLD_SCN -- last deallocate scn
FILE# 1
BLOCK# 1
OFFSET 0
DBA 0x00400001 (4194305 1,1)
FILENAME /u01/app/oracle/oradata/sunner/system01.dbf
BIFILE bifile.bbd
LISTFILE /home/oracle/file.txt
BLOCKSIZE 8192
MODE Edit
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL No
BBED> map
File: /u01/app/oracle/oradata/sunner/system01.dbf (1)
Block: 1 Dba:0x00400001
------------------------------------------------------------
Data File Header
struct kcvfh, 676 bytes @0
ub4 tailchk @8188
MAP[/v] [ DBA | FILENAME | FILE | BLOCK ]
顯示指定位置的頭尾 offset
BBED> p kcvfh
struct kcvfh, 676 bytes @0 -- 檔案頭kcvfh 676 bytes
struct kcvfhbfh, 20 bytes @0 -- 結構kcvfhbfh 20 bytes
ub1 type_kcbh @0 0x0b -- block header type 11
ub1 frmt_kcbh @1 0xa2 -- format 162
ub1 spare1_kcbh @2 0x00 --
ub1 spare2_kcbh @3 0x00 --
ub4 rdba_kcbh @4 0x00400001 -- relative database block address
ub4 bas_kcbh @8 0x00000000 --
ub2 wrp_kcbh @12 0x0000 --
ub1 seq_kcbh @14 0x01 -- 序列 壞塊標記為0xff
ub1 flg_kcbh @15 0x04(KCBHFCKV)-- 標誌
ub2 chkval_kcbh @16 0x76d2 -- 塊校驗值
ub2 spare3_kcbh @18 0x0000 --
struct kcvfhhdr, 76 bytes @20 -- 結構kcvfhhdr 76 bytes
ub4 kccfhswv @20 0x00000000 --
ub4 kccfhcvn @24 0x0a200100 --
ub4 kccfhdbi @28 0xa69be42f -- dbid
text kccfhdbn[0] @32 S --
text kccfhdbn[1] @33 U --
text kccfhdbn[2] @34 N --
text kccfhdbn[3] @35 N --
text kccfhdbn[4] @36 E --
text kccfhdbn[5] @37 R --
text kccfhdbn[6] @38 --
text kccfhdbn[7] @39 --
ub4 kccfhcsq @40 0x0000041b -- controlfile sequence
ub4 kccfhfsz @44 0x0000f000 -- blocks
s_blkz kccfhbsz @48 0x00 --
ub2 kccfhfno @52 0x0001 -- 相對檔案號
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 kcvfhrdb @96 0x00400179 -- 相關
struct kcvfhcrs, 8 bytes @100 --
ub4 kscnbas @100 0x00000009 -- file$.CRSCNBAS creation SCN base
ub2 kscnwrp @104 0x0000 -- file$.crscnwrp creation SCN wrap
ub4 kcvfhcrt @108 0x2184ef93 -- 建立時間
ub4 kcvfhrlc @112 0x2ff9bad5 --
struct kcvfhrls, 8 bytes @116 --
ub4 kscnbas @116 0x4000ac47 --
ub2 kscnwrp @120 0x0000 --
ub4 kcvfhbti @124 0x00000000 --
struct kcvfhbsc, 8 bytes @128 --
ub4 kscnbas @128 0x00000000 --
ub2 kscnwrp @132 0x0000 --
ub2 kcvfhbth @136 0x0000 --
ub2 kcvfhsta @138 0x2004(KCVFHOFZ)--
struct kcvfhckp, 36 bytes @484 --
struct kcvcpscn, 8 bytes @484 -- 當前檢查點SCN
ub4 kscnbas @484 0x4004ab21 --
ub2 kscnwrp @488 0x0000 --
ub4 kcvcptim @492 0x300152ff -- 當前檢查點時間
ub2 kcvcpthr @496 0x0001 --
union u, 12 bytes @500 --
struct kcvcprba,12 bytes @500 --
ub4 kcrbaseq @500 0x0000000e -- recover 需要的下一個日誌序列號
ub4 kcrbabno @504 0x00000002 -- rba block no
ub2 kcrbabof @508 0x0010 -- rba bytes offset
ub1 kcvcpetb[0] @512 0x02 --
ub1 kcvcpetb[1] @513 0x00 --
ub1 kcvcpetb[2] @514 0x00 --
ub1 kcvcpetb[3] @515 0x00 --
ub1 kcvcpetb[4] @516 0x00 --
ub1 kcvcpetb[5] @517 0x00 --
ub1 kcvcpetb[6] @518 0x00 --
ub1 kcvcpetb[7] @519 0x00 --
ub4 kcvfhcpc @140 0x00000088 -- scn of last change to the datafile
ub4 kcvfhrts @144 0x300152fd --
ub4 kcvfhccc @148 0x00000087 -- time of the last chage to the datafile
struct kcvfhbcp, 36 bytes @152 --
struct kcvcpscn, 8 bytes @152 --
ub4 kscnbas @152 0x00000000 --
ub2 kscnwrp @156 0x0000 --
ub4 kcvcptim @160 0x00000000 --
ub2 kcvcpthr @164 0x0000 --
union u, 12 bytes @168 --
struct kcvcprba, 12 bytes @168 --
ub4 kcrbaseq @168 0x00000000 --
ub4 kcrbabno @172 0x00000000 --
ub2 kcrbabof @176 0x0000 -- checkpoint count
ub1 kcvcpetb[0] @180 0x00 --
ub1 kcvcpetb[1] @181 0x00 --
ub1 kcvcpetb[2] @182 0x00 --
ub1 kcvcpetb[3] @183 0x00 --
ub1 kcvcpetb[4] @184 0x00 --
ub1 kcvcpetb[5] @185 0x00 --
ub1 kcvcpetb[6] @186 0x00 --
ub1 kcvcpetb[7] @187 0x00 --
ub4 kcvfhbhz @312 0x00000000 --
struct kcvfhxcd, 16 bytes @316 --
ub4 space_kcvmxcd[0] @316 0x00000000 --
ub4 space_kcvmxcd[1] @320 0x00000000 --
ub4 space_kcvmxcd[2] @324 0x00000000 --
ub4 space_kcvmxcd[3] @328 0x00000000 --
word kcvfhtsn @332 0 --
ub2 kcvfhtln @336 0x0006 --
text kcvfhtnm[0] @338 S --
text kcvfhtnm[1] @339 Y --
text kcvfhtnm[2] @340 S --
text kcvfhtnm[3] @341 T --
text kcvfhtnm[4] @342 E --
text kcvfhtnm[5] @343 M --
text kcvfhtnm[6] @344 --
text kcvfhtnm[7] @345 --
text kcvfhtnm[8] @346 --
text kcvfhtnm[9] @347 --
text kcvfhtnm[10] @348 --
text kcvfhtnm[11] @349 --
text kcvfhtnm[12] @350 --
text kcvfhtnm[13] @351 --
text kcvfhtnm[14] @352 --
text kcvfhtnm[15] @353 --
text kcvfhtnm[16] @354 --
text kcvfhtnm[17] @355 --
text kcvfhtnm[18] @356 --
text kcvfhtnm[19] @357 --
text kcvfhtnm[20] @358 --
text kcvfhtnm[21] @359 --
text kcvfhtnm[22] @360 --
text kcvfhtnm[23] @361 --
text kcvfhtnm[24] @362 --
text kcvfhtnm[25] @363 --
text kcvfhtnm[26] @364 --
text kcvfhtnm[27] @365 --
text kcvfhtnm[28] @366 --
text kcvfhtnm[29] @367 --
ub4 kcvfhrfn @368 0x00000001 -- 相對檔案號
struct kcvfhrfs, 8 bytes @372 --
ub4 kscnbas @372 0x00000000 --
ub2 kscnwrp @376 0x0000 --
ub4 kcvfhrft @380 0x00000000 -- the time which the recovery
-- of this file will be complete
struct kcvfhafs, 8 bytes @384 --
ub4 kscnbas @384 0x00000000 --
ub2 kscnwrp @388 0x0000 --
ub4 kcvfhbbc @392 0x00000000 --
ub4 kcvfhncb @396 0x00000000 --
ub4 kcvfhmcb @400 0x00000000 --
ub4 kcvfhlcb @404 0x00000000 --
ub4 kcvfhbcs @408 0x00000000 --
ub2 kcvfhofb @412 0x000a --
ub2 kcvfhnfb @414 0x000a --
ub4 kcvfhprc @416 0x2ff9955d -- prev checkpoint
struct kcvfhprs, 8 bytes @420 --
ub4 kscnbas @420 0x00083bee --
ub2 kscnwrp @424 0x0000 --
struct kcvfhprfs, 8 bytes @428 --
ub4 kscnbas @428 0x00000000 --
ub2 kscnwrp @432 0x0000 --
ub4 kcvfhtrt @444 0x00000000 --
檢視需要檢視
我們在分析問題，檢視效能是的時候，需檢視特定v$，甚至是x$。
通過SELECT * FROM v$fixed_view_definition 可以查詢指定v$的x$來源。
我們這裡使用的表x$kcvfh:
SQL> desc x$kcvfh;
Name
-------------------
ADDR -- Adderss 唯一標識
INDX -- Indx 表內序列
INST_ID -- Inst_id 例項ID
HXFIL -- 十六進位制的檔案號
HXONS -- Online狀態 0表示"offline",其他表示"Online"
HXSTS -- 應該是狀態標記(offline，值發生變化)
HXERR -- 錯誤程式碼 0 null ...
HXVER -- format,indicates format of block 6,7,8 indicats oracle version 6,7,8
-- 0 indicate not determined (the header could not be read)
FHSWV -- swap vsn
FHCVN -- compatible vsn
FHDBI -- database DBID
FHDBN -- database name
FHCSQ -- controlfile sequence number
FHFSZ -- current block size in blocks(bytes/block_size)
FHBSZ -- block size
FHFNO -- file number
FHTYP -- 1 controlfile 2 redo file 3 validate db file, normal data index undo file
FHRDB -- root dba,occurs in file# 1 (bootstrap$)
FHCRS -- creation_time
FHCRT -- create timestamp
FHRLC -- resetlog_time
FHRLC_I -- resetlog count
FHRLS -- resetlogs_change#
FHPRC -- prev resetlogs timestamp
FHPRC_I -- prev resetlogs count
FHPRS -- prev resegtlog scn
FHBTI -- "begin backup" update the backup start
FHBSC -- "begin backup" system change number
FHBTH -- "begin backup" update thread
FHSTA -- status of datafile,file# 1 is 8186 ,others is 4 ,indicates online status
FHSCN -- datafile_header checkpoint_change#
FHTIM -- checkpoint_time
FHTHR -- thread number
FHRBA_SEQ -- redo file sequence number
FHRBA_BNO -- redo file block number
FHRBA_BOF -- bytes offset:the bytes offset into the block at which the redo record start
FHETB -- extent bytes
FHCPC -- datafile checkpoint_count
FHRTS -- recover timestamp
FHCCC -- controlfile checkpoint count
FHBCP_SCN -- "hot backup" backup checkpoint scn
FHBCP_TIM -- "hot backup" backup timestamp
FHBCP_THR -- "hot backup" threads
FHBCP_RBA_SEQ -- "hot backup" redo file sequence number
FHBCP_RBA_BNO -- "hot backup" redo file block number
FHBCP_RBA_BOF -- "hot backup" bytes offset
FHBCP_ETB -- "hot backup" extent bytes
FHBHZ -- begin hot backup file
FHXCD -- extent cache id
FHTSN -- tablespace number
FHTNM -- tablespace name
FHRFN -- relative file number
FHAFS -- absolute fuzzy scn:minimum pitr scn
FHRFS -- the scn which the recovery of this file will be complete
FHRFT -- the time which the recovery of this file will be complete
HXIFZ -- file is fuzzy(yes/no)
HXNRCV -- file need media recover(yes/no)
HXFNM -- datafile name
FHPOFB -- prev old file block
FHPNFB -- prev new file block
FHPRE10 -- prev 10
FHFIRSTUNRECSCN -- unrecoverable_change#
FHFIRSTUNRECTIM -- unrecoverable_time
HXLMDBA -- space header:the amount of block is being used the amount of block is free
HXLMLD_SCN -- last deallocate scn
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28894640/viewspace-2063636/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 通過oracle event來dump資料檔案頭資訊Oracle
- 關於控制檔案與資料檔案頭資訊的說明（zt）
- Oracle檔案頭資訊(zt)Oracle
- idea檔案頭資訊設定Idea
- 檢視BAM檔案頭部資訊
- 資料檔案拷貝檔案頭驗證錯誤
- system資料檔案頭損壞修復
- oracle資料檔案頭轉儲說明Oracle
- 獲取資料庫bak檔案資訊資料庫
- 抽取exp/expdp匯出檔案頭的資訊
- 資料檔案頭塊保留大小、ROWID、資料檔案最大大小等資料庫限制的說明資料庫
- IP資料包頭部資訊分析
- 關於資料檔案頭的檢查點SCN
- 檢測根目錄帶bom頭資訊的檔案
- 關於檔案頭保留塊資訊的儲存探索
- wav檔案的檔案頭
- alter session set events語句dump 控制檔案頭資訊示例Session
- 建立資料庫檔案-日誌檔案-次要資料庫檔案資料庫
- 關於資料檔案頭的檢查點SCN知識
- 8.13 標頭檔案剖析：標頭檔案路徑（下）
- 第十四篇：獲取系統資料檔案資訊
- 檢視錶空間及資料檔案的checkpoint資訊
- 重建控制檔案時，與資料檔案相關的Checkpoint資訊來自何處
- 資料檔案
- locate標頭檔案和庫檔案
- PHP檔案頭BOM頭問題PHP
- 【kingsql分享】使用BBED修改Oracle資料檔案頭推進SCNSQLOracle
- oracle資料庫移動資料檔案、日誌檔案和控制檔案Oracle資料庫
- ASP.NET Core 中的檔案提供程式 遍歷資料夾讀取檔案資訊ASP.NET
- C 標頭檔案
- 資料庫檔案和檔案組資料庫
- 資料庫引數檔案控制檔案日誌檔案資料檔案跟蹤檔案等8大檔案的字典資料庫
- alter session set events語句dump REDO日誌檔案頭資訊示例Session
- 檔案與資料
- 資料泵檔案
- oracle10g 資料檔案頭data file header(file header)OracleHeader
- PE檔案檢測DOS頭\NT頭
- 10g 資料檔案頭到底有多少資料塊，還是說固定有多大？