1.关于datafile header
2.关于SCN
让我们从一个dump出来的datafile header开始：
执行alter session set events 'immediate trace name file_hdrs,level 10'会在udump下生成一个trace文件：
Dump file d:\programfiles\oracle\admin\swgdb\udump\swgdb_ora_5992.trc
Thu Feb 17 23:16:54 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Instance name: swgdb
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 5992, image: ORACLE.EXE
*** 2011-02-17 23:16:54.000
*** SESSION ID:(9.5) 2011-02-17 23:16:54.000
DUMP OF DATA FILES: 16 files in database
DATA FILE #1:
(name #18) D:\PROGRAMFILES\ORACLE\ORADATA\swgdb\SYSTEM01.DBF
creation size=0 block size=8192 status=0x12 head=18 tail=18 dup=1
tablespace 0, index=1 krfil=1 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:9022 scn: 0x0000.53d61f0d 02/04/2011 09:46:04
Stop scn: 0xffff.ffffffff 02/17/2011 22:21:48
Creation Checkpointed at scn: 0x0000.0000000b 05/12/2002 16:17:58
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.00000000 prev_range: 0
Online Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
Db ID=4061587700=0xf216e8f4, Db Name='swgdb'
Activation ID=0=0x0
Control Seq=52582=0xcd66, File size=52480=0xcd00
File Number=1, Blksiz=8192, File Type=3 DATA
Tablespace #0 - SYSTEM rel_fn:1
Creation at scn: 0x0000.0000000b 05/12/2002 16:17:58
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2638ebb5 scn: 0x0000.0002e872 recovered at 02/17/2011 22:34:56
status:0x4 root dba:0x004001a1 chkpt cnt: 9022 ctl cnt:9021
begin-hot-backup file size: 0
Checkpointed at scn: 0x0000.bbe01453 02/04/2011 09:46:04
thread:1 rba:(0x3820.2.10) 恢复的时候要用到这一部分信息！
enabled threads: 01000000 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
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 scn: 0x0000.00000000 01/01/1988 00:00:00
这几天破事情真多，都没时间写。。。。希望明天能够完成。。。。
阅读(3124) | 评论(0) | 转发(0) |
