Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching


当前位置: 首页 » 技术文章 » 内部原理

Understanding Datafile Header kcvfh structure

KCVFH means kernel cache recovery file header.The length of datafile header for different version is different.

   9i kcvfh

10g kcvfh   676 bytes

11g kcvfh   860 bytes

12c kcvfh 1112 bytes

BBED> p kcvfh
struct kcvfh, 860 bytes             @0       
   struct kcvfhbfh, 20 bytes        @0       
      ub1 type_kcbh                 @0        0x0b    --Block type
      ub1 frmt_kcbh                 @1        0xa2    --Block format
      ub1 spare1_kcbh               @2        0x00
      ub1 spare2_kcbh               @3        0x00
      ub4 rdba_kcbh                 @4        0x00400001   --Block address
      ub4 bas_kcbh                  @8        0x00000000   --Scn base
      ub2 wrp_kcbh                  @12       0x0000       --Scn wrap
      ub1 seq_kcbh                  @14       0x01         --Sequence
      ub1 flg_kcbh                  @15       0x04 (KCBHFCKV)  --Block flag
      ub2 chkval_kcbh               @16       0x40d1           --Block checksum
      ub2 spare3_kcbh               @18       0x0000           
   struct kcvfhhdr, 76 bytes        @20      
      ub4 kccfhswv                  @20       0x00000000      --Software version
      ub4 kccfhcvn                  @24       0x0b200400      --Compatibility Version
      ub4 kccfhdbi                  @28       0x028f3abc      --Dbid
      text kccfhdbn[0]              @32      U                --Dbname
      text kccfhdbn[1]              @33      P
      text kccfhdbn[2]              @34      G
      text kccfhdbn[3]              @35      R
      text kccfhdbn[4]              @36       
      text kccfhdbn[5]              @37       
      text kccfhdbn[6]              @38       
      text kccfhdbn[7]              @39       
      ub4 kccfhcsq                  @40       0x000008da      --Controlfile Seq at last ckpt
      ub4 kccfhfsz                  @44       0x00019a00      --Filesize
      s_blkz kccfhbsz               @48       0x00            --The logical block size for flashback
      ub2 kccfhfno                  @52       0x0001          --File number
      ub2 kccfhtyp                  @54       0x0003          --File type
      ub4 kccfhacid                 @56       0x00000000      --Activation identifier
      ub4 kccfhcks                  @60       0x00000000      --File checksum
      text kccfhtag[0]              @64                       --Control file tag based on date and time   
      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       0x00400208   --Root dba block
   struct kcvfhcrs, 8 bytes         @100     
      ub4 kscnbas                   @100      0x00000007   --File created scn
      ub2 kscnwrp                   @104      0x0000
   ub4 kcvfhcrt                     @108      0x3121c97d   --Datafile create time
   ub4 kcvfhrlc                     @112      0x360233bd   --Last resetlog time
   struct kcvfhrls, 8 bytes         @116                   --Last resetlog scn
      ub4 kscnbas                   @116      0x000e2006
      ub2 kscnwrp                   @120      0x0000
   ub4 kcvfhbti                     @124      0x00000000   --Hot backup time(begin backup)
   struct kcvfhbsc, 8 bytes         @128                   --Hot backup scn
      ub4 kscnbas                   @128      0x00000000
      ub2 kscnwrp                   @132      0x0000
   ub2 kcvfhbth                     @136      0x0000       --Hot backup thread
   ub2 kcvfhsta                     @138      0x2004 (KCVFHOFZ) --File status
   struct kcvfhckp, 36 bytes        @484     
      struct kcvcpscn, 8 bytes      @484                   --Checkpoint scn
         ub4 kscnbas                @484      0x2719a36e
         ub2 kscnwrp                @488      0x0d87
      ub4 kcvcptim                  @492      0x362e681b   --Checkpoint time
      ub2 kcvcpthr                  @496      0x0001       --Checkpoint thread
      union u, 12 bytes             @500     
         struct kcvcprba, 12 bytes  @500                   --Checkpoint rba
            ub4 kcrbaseq            @500      0x00000014
            ub4 kcrbabno            @504      0x00009af7
            ub2 kcrbabof            @508      0x0010
      ub1 kcvcpetb[0]               @512      0x02         --Backup Enabled Threads
      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      0x00000081   --Checkpoint count
   ub4 kcvfhrts                     @144      0x36292c33   --Recovery timestamp
   ub4 kcvfhccc                     @148      0x00000080   --Controlfile Checkpoint Count
   struct kcvfhbcp, 36 bytes        @152     
      struct kcvcpscn, 8 bytes      @152                   --Backup ckpt scn
         ub4 kscnbas                @152      0x00000000
         ub2 kscnwrp                @156      0x0000
      ub4 kcvcptim                  @160      0x00000000   --Backup ckpt time
      ub2 kcvcpthr                  @164      0x0000       --Backup thread
      union u, 12 bytes             @168                   --Backup rba
         struct kcvcprba, 12 bytes  @168     
            ub4 kcrbaseq            @168      0x00000000
            ub4 kcrbabno            @172      0x00000000
            ub2 kcrbabof            @176      0x0000
      ub1 kcvcpetb[0]               @180      0x00         --Ckpt enable thread bit
      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  --File size when hot backup begins
   struct kcvfhxcd, 16 bytes        @316                  --External cache id
      ub4 space_kcvmxcd[0]          @316      0x00000000
      ub4 space_kcvmxcd[1]          @320      0x00000000
      ub4 space_kcvmxcd[2]          @324      0x00000000
      ub4 space_kcvmxcd[3]          @328      0x00000000
   sword kcvfhtsn                   @332      0           --Tablespace number
   ub2 kcvfhtln                     @336      0x0006      --The length of tablespace name
   text kcvfhtnm[0]                 @338     S            --Tablespace name
   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  --Relateive file number
   struct kcvfhrfs, 8 bytes         @372                  --Recovery Fuzzy SCN
      ub4 kscnbas                   @372      0x00000000
      ub2 kscnwrp                   @376      0x0000
   ub4 kcvfhrft                     @380      0x00000000  --Recovery fuzzy time
   struct kcvfhafs, 8 bytes         @384                  --Absolute Fuzzy SCN(Minimum PITR SCN)
      ub4 kscnbas                   @384      0x00000000
      ub2 kscnwrp                   @388      0x0000
   ub4 kcvfhbbc                     @392      0x00000000  --Backup blocks count(except image copies)
   ub4 kcvfhncb                     @396      0x00000000  --New media corrupt blocks
   ub4 kcvfhmcb                     @400      0x00000000  --Media corrupt blocks
   ub4 kcvfhlcb                     @404      0x00000000  --Logical corrupt blocks
   ub4 kcvfhbcs                     @408      0x00000000  --
   ub2 kcvfhofb                     @412      0x000a      --It should be the related with RDBA format
   ub2 kcvfhnfb                     @414      0x000a      --It should be the related with RDBA format
   ub4 kcvfhprc                     @416      0x3121c97a  --Previous Resetlog count
   struct kcvfhprs, 8 bytes         @420                  --Previous Resetlog SCN from database
      ub4 kscnbas                   @420      0x00000001
      ub2 kscnwrp                   @424      0x0000
   struct kcvfhprfs, 8 bytes        @428                  --Previous media recovery fuzzy scn
      ub4 kscnbas                   @428      0x00000000
      ub2 kscnwrp                   @432      0x0000
   ub4 kcvfhtrt                     @444      0x00000000  --Terminal Recovery TimeStamp

BBED> 


Datafile Header

DATA FILE #1:
  name #7: /oradata/upgr/system01.dbf
creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:132 scn: 0x0d87.271a3866 04/15/2016 00:07:47
 Stop scn: 0xffff.ffffffff 04/14/2016 21:11:16
 Creation Checkpointed at scn:  0x0000.00000007 08/24/2013 11:37:33
 thread:0 rba:(0x0.0.0)
 enabled  threads:  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 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 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
 Offline scn: 0x0000.000e2005 prev_range: 0
 Online Checkpointed at scn:  0x0000.000e2006 03/10/2016 10:19:41
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 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
  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 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
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
 Plugged readony: NO
 Plugin scnscn: 0x0000.00000000
 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Online move state: 0
 
 V10 STYLE FILE HEADER:
        Compatibility Vsn = 186647552=0xb200400
        Db ID=42941116=0x28f3abc, Db Name='UPGR'
        Activation ID=0=0x0
        Control Seq=2472=0x9a8, File size=104960=0x19a00
        File Number=1, Blksiz=8192, File Type=3 DATA
Tablespace #0 - SYSTEM  rel_fn:1
Creation   at   scn: 0x0000.00000007 08/24/2013 11:37:33
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
 reset logs count:0x360233bd scn: 0x0000.000e2006
 prev reset logs count:0x3121c97a scn: 0x0000.00000001
 recovered at 04/15/2016 00:07:48
 status:0x2004 root dba:0x00400208 chkpt cnt: 132 ctl cnt:131
begin-hot-backup file size: 0
Checkpointed at scn:  0x0d87.271a3866 04/15/2016 00:07:47
 thread:1 rba:(0x15.2.10)
 enabled  threads:  01000000 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
  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 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
Backup Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  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 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 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
External cache id: 0x0 0x0 0x0 0x0
Absolute fuzzy scn: 0x0000.00000000
Recovery fuzzy scn: 0x0000.00000000 01/01/1988 00:00:00
Terminal Recovery Stamp  01/01/1988 00:00:00
Platform Information:    Creation Platform ID: 13
Current Platform ID: 13 Last Platform ID: 13

关键词:kcvfh 

相关文章

Understanding Datafile Header kcvfh structure

联系我们

韩朝阳



    Phone:186-9589-1286

    E-mail:ohsdba@qq.com

    微  信: ohsdba


电话(186-9589-1286)

QQ(375349564)

微信(ohsdba)


常用链接

Oracle
eDelivery
My Oracle Support

Exadata 12.1 Document

Exadata 12.2 Document

Oracle 11gR2 Document

Oracle 12cR1 Document

Oracle 12cR2 Document

GoldenGate 12c

Oracle Fusion Middleware

Mysql Document

PostgreSQL

Python

github

sourceforge



Top
Cell186-9589-1286
QQ 375349564
E-mail ohsdba@qq.com