oracle10g 資料檔案頭data file header(file header)
--分析資料檔案頭的相關資訊(checkpoint scn,stop scn等）
執行alter session set events 'immediate trace name file_hdrs level 10'
--以上為轉儲資料檔案頭的資訊（注：是資料庫中所有資料檔案及臨時檔案）
--以下來源於控制檔案（此部分資訊同於控制檔案的dump)
DATA FILE #1:
(name #7) /oracle/oradata/orcl/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:80 scn: 0x0000.000b6d16 08/18/2010 13:31:45
Stop scn: 0xffff.ffffffff 08/18/2010 13:14:51
Creation Checkpointed at scn: 0x0000.00000008 10/22/2005 21:44:31
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.00080633 prev_range: 0
Online Checkpointed at scn: 0x0000.00080634 08/13/2010 17:44:12
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
---以下來源於資料檔案頭
V10 STYLE. FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=1254727785=0x4ac9a069, Db Name='ORCL'
Activation ID=0=0x0
Control Seq=685=0x2ad, File size=61440=0xf000
File Number=1, Blksiz=8192, File Type=3 DATA
Tablespace #0 - SYSTEM rel_fn:1
Creation at scn: 0x0000.00000008 10/22/2005 21:44:31
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2b5454ec scn: 0x0000.00080634 reset logs terminal rcv data:0x0 scn: 0x0000.00000000
prev reset logs count:0x221e01a8 scn: 0x0000.00000001 prev reset logs terminal rcv data:0x0 scn: 0x0000.00000000
recovered at 08/18/2010 11:46:30
status:0x2004 root dba:0x00400179 chkpt cnt: 80 ctl cnt:79
begin-hot-backup file size: 0
Checkpointed at scn: 0x0000.000b6d16 08/18/2010 13:31:45
thread:1 rba:(0xe.d81.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
oracle在啟動open時，會對此資訊進行驗證，二者是否一致，如不一致，根據scn 進行相關的恢復
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9240380/viewspace-671319/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- PE教程3: File Header （檔案頭）Header
- System File1 File Header（資料庫System檔案1檔案頭）損壞情況的恢復Header資料庫
- The Ultimate (DLL) Header File (轉)Header
- 使用 header 頭下載檔案Header
- oracle_bbed.Datafile.Header_System.資料檔案頭資訊OracleHeader
- ORA-01251: Unknown File Header Version read for file number 7Header
- LMT更新file header bitmap不產生redo和undo ?Header
- gulp使用gulp-file-include將header/footer引入頁面Header
- 真正理解預編譯標頭檔案: Procompiled header編譯CompileHeader
- oracle block header_tail資料塊頭與資料塊尾OracleBloCHeaderAI
- 【UTL_FILE】使用UTL_FILE包生成檔案並寫入資料
- 【JAVA ：File類的用法(一)】File類的構造方法-File類建立檔案與資料夾Java構造方法
- 20161110Bitmapped File Space Header恢復APPHeader
- [20121011]file header reset--bbed學習.txtHeader
- [20220128]Check the datapump file header information in Oracle.txtHeaderORMOracle
- 包含檔案（Include file）
- zt_Oracle資料恢復：資料檔案頭的SCN與時間校驗_file$_scnOracle資料恢復
- Oracle資料庫資料檔案small file的最大值Oracle資料庫
- Vi and Vim Autocommand: 3 Steps to Add Custom Header To Your File AutomaticallyHeader
- 6.2file寫檔案
- 6.1file讀檔案
- HTML input file檔案域HTML
- HTML input file 檔案域HTML
- Java —— 檔案類（File 類）Java
- Java : File 檔案類操作Java
- MySQL資料匯入匯出之Load data fileMySql
- 幾種ASM與File System資料檔案轉移方法ASM
- ASM資料和File System檔案轉移方法集錦ASM
- php常用header頭部定義彙總PHPHeader
- data file int write和db file sequential read個人想法
- ThunderSoft File Lock for Mac檔案鎖Mac
- 檔案伺服器 — File Browser伺服器
- File Juicer for Mac(檔案提取工具)UIMac
- 控制檔案-control file
- control file（控制檔案）
- 計劃檔案(Planning file)
- UTL_FILE遍歷檔案
- HP -Data Protector Restore file systemREST