这一部分主要是分析level 3，其中有些地方是根据自己的理解写出来的，在没有把握的地方，我都注明了“存疑”二字，希望能够得到读者的

指点。关于level 4及其以上的部分不再介绍，无非是比level 3更详细一些，显示的内容更多，但是level 3已经向我们展示了比较全的条目信

息。实际分析控制文件的话，我感觉分析到level 3或者4就可以了。
另外，再说明一点，我是使用oradebug来分析的controlfile，当然工具多多，也可以使用诸如如下的语句，效果是一样的：
alter session set events 'immediate trace name controlf level 3';等等。

下面我们分析level 3：
cmd>sqlplus "/as sysdba"
sql>oradebug setmypid
sql>oradebug dump confilef 3;

在D:oracleadminsdusunudump中找到刚生成的trace文件，主要内容如下：
（考虑到可读性，注释使用<...>代替，也就是说凡在<>里面的内容均是对它上面的一句话的注释）
<这一块主要介绍 level 3 比 level 2 多出的那一部分>

***************************************************************************
REDO THREAD RECORDS <重做线程项>
***************************************************************************
(blkno = 0x4, size = 104, max = 1, in-use = 1, last-recid= 0)
THREAD #1 - status:0xf thread links forward:0 back:0
#logs:3 first:1 last:3 current:2 last used seq#:0x6
<这个条目说明数据库中总共有3个日志文件组，第一个组为log #1（log group 1）；
最后一个组为log #3（log group 3），当前正在使用的是log #2（log group 2）
>
enabled at scn: 0x0000.0013262b 12/21/2006 21:37:57
<启用线程1时的scn值>
disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
<禁用线程1时的scn值，因为该线程目前处于打开状态，所以该值为无穷大>
opened at 05/08/2007 10:37:49 by instance sdusun
<打开线程的时间戳，当前线程被sdusun实例打开>
Checkpointed at scn: 0x0000.001e484e 05/08/2007 10:37:49
<检查点scn>
thread:1 rba:(0x6.802a.10)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
log history: 5




***************************************************************************
LOG FILE RECORDS <日志文件项>
***************************************************************************
(blkno = 0x5, size = 72, max = 50, in-use = 3, last-recid= 3)
LOG FILE #1:
(name #3) F:ORACLEORADATASDUSUNREDO01.LOG
Thread 1 redo log links: forward: 2 backward: 0
LOG FILE #1的Next scn: 0x0000.001d9522等于LOG FILE #2的Low scn: 0x0000.001d9522
>
siz: 0x32000 seq: 0x00000005 hws: 0x25 bsz: 512 nab: 0x15f81 flg: 0x1 dup: 1
<文件大小及块大小bsz;3*16*16*16*16 + 2*16*16*16 = 196608 + 8192 = 204800 ;所以日志文件大小为：204800*bsz=102MB.
nab是日志文件中LGWR可用的下一个数据块的地址，如果这个值是无穷大，说明这个日志文件是当前（LGWR正在写入）的日志文件>
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0018291b
Low scn: 0x0000.001bfcf4 01/26/2007 21:15:40 <日志文件包含的最低scn>
Next scn: 0x0000.001d9522 04/27/2007 20:31:46 <日志文件包含的下一个scn>
LOG FILE #2:
(name #2) F:ORACLEORADATASDUSUNREDO02.LOG
Thread 1 redo log links: forward: 3 backward: 1
siz: 0x32000 seq: 0x00000006 hws: 0x7 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001bfcf4
Low scn: 0x0000.001d9522 04/27/2007 20:31:46
<注意这里：LOG FILE #1的Next scn: 0x0000.001d9522等于LOG FILE #2的Low scn: 0x0000.001d9522>
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
<
这个日志文件是当前（LGWR正在写入）的日志文件。
日志发生切换时会分配一个低scn和一个高scn,低scn就是上一个日志的高scn的值,而高scn则设置为无穷大,直到切换到下一个
>
LOG FILE #3:
(name #1) F:ORACLEORADATASDUSUNREDO03.LOG
Thread 1 redo log links: forward: 0 backward: 2
siz: 0x32000 seq: 0x00000004 hws: 0x1f bsz: 512 nab: 0x31fff flg: 0x1 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001766a3
Low scn: 0x0000.0018291b 01/11/2007 00:01:02
Next scn: 0x0000.001bfcf4 01/26/2007 21:15:40




***************************************************************************
DATA FILE RECORDS <数据文件项>
***************************************************************************
(blkno = 0x6, size = 180, max = 100, in-use = 18, last-recid= 2)
DATA FILE #1:
(name #19) F:ORACLEORADATASDUSUNSYSTEM01.DBF
creation size=0 block size=8192 status=0xe head=19 tail=19 dup=1
tablespace 0, index=1 krfil=1 prev_file=0 <表空间信息,tablespace 0 表示ts#=0,说明是系统表空间>
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 <记录nologging操作的scn>
Checkpoint cnt:235 scn: 0x0000.001e484e 05/08/2007 10:37:49
<
对该文件执行检查点的次数为235（文件处于热备状态时，如果发生了检查点，检查点计数器（Checkpoint cnt）也还是加1）
但是，在热备份状态下scn被锁定。
>
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37 <文件结束scn，open状态为无穷大>
<
结束scn（Stop scn）是数据文件的最后一个scn（数据库正常关闭时会设置这个值），数据库正常打开的状态，该值为无穷大。
数据库恢复时要求恢复到Stop scn。
对以上几个scn的作用作一下总结：我们比较的是数据文件头中SCN号码,控制文件中记录的数据文件SCN号,终止SCN号码
在启动中,先比较数据文件头的SCN号和控制文件中数据文件SCN号码是否一致,如果一致,然后比较数据文件头SCN与控制文件中记录的终止SCN是

否一致。如果数据文件头SCN较小,则表示文件相对于当前控制文件比较陈旧,需要进行介质恢复,如果两者一致,但文件头的SCN小于终止SCN(无

穷大),表示数据库是非正常关闭,只要进行实例恢复
>
Creation Checkpointed at scn: 0x0000.0000000b 05/12/2002 16:17:58
<用“alter database create datafile”命令恢复数据文件时，需要依据文件创建时的检查点scn（Creation Checkpointed at scn）>
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0 <当文件脱机时，文件脱机时的scn作为脱机scn保存在控制文件中>
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
<当文件联机时，文件联机时的检查点scn作为联机scn保存在控制文件中>
<这里的Offline scn可能是表示数据库上一次正常关闭时数据文件的检查点scn；
这里的Online Checkpointed at scn表示数据库本次打开时的数据文件的检查点scn；这里存疑！
>
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000 <热备时的scn>
aux_file is NOT DEFINED
DATA FILE #2:
(name #18) F:ORACLEORADATASDUSUNUNDOTBS01.DBF
creation size=0 block size=8192 status=0xe head=18 tail=18 dup=1
tablespace 1, index=2 krfil=2 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:221 scn: 0x0000.001e484e 05/08/2007 10:37:49
<注意：从这里可以看到Checkpoint scn都是 0x0000.001e484e，这说明数据文件是一致的>
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.0002dd31 05/12/2002 20:22:54
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #3:
(name #17) F:ORACLEORADATASDUSUNCWMLITE01.DBF
creation size=0 block size=8192 status=0xe head=17 tail=17 dup=1
tablespace 3, index=3 krfil=3 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:232 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.0000188b 05/12/2002 16:19:08
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #4:
(name #16) F:ORACLEORADATASDUSUNDRSYS01.DBF
creation size=0 block size=8192 status=0xe head=16 tail=16 dup=1
tablespace 4, index=4 krfil=4 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:232 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.0000189e 05/12/2002 16:19:11
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #5:
(name #15) F:ORACLEORADATASDUSUNEXAMPLE01.DBF
creation size=0 block size=8192 status=0xe head=15 tail=15 dup=1
tablespace 5, index=5 krfil=5 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:232 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.000018b4 05/12/2002 16:19:24
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #6:
(name #14) F:ORACLEORADATASDUSUNINDX01.DBF
creation size=0 block size=8192 status=0xe head=14 tail=14 dup=1
tablespace 6, index=6 krfil=6 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:232 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.000018c7 05/12/2002 16:19:27
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #7:
(name #13) F:ORACLEORADATASDUSUNODM01.DBF
creation size=0 block size=8192 status=0xe head=13 tail=13 dup=1
tablespace 7, index=7 krfil=7 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:232 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.000018db 05/12/2002 16:19:30
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #8:
(name #12) F:ORACLEORADATASDUSUNTOOLS01.DBF
creation size=0 block size=8192 status=0xe head=12 tail=12 dup=1
tablespace 8, index=8 krfil=8 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:232 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.000018ee 05/12/2002 16:19:32
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #9:
(name #20) F:ORACLEORA92DATABASEMISSING00009
creation size=0 block size=8192 status=0x85c head=20 tail=20 dup=1
tablespace 9, index=12 krfil=9 prev_file=13
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:4294967295 scn: 0x0000.00000000 01/01/1988 00:00:00
Stop scn: 0x0000.00132656 12/21/2006 21:38:26
Creation Checkpointed at scn: 0x0000.00001901
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=0
DATA FILE #10:
(name #11) F:ORACLEORADATASDUSUNXDB01.DBF
creation size=0 block size=8192 status=0xe head=11 tail=11 dup=1
tablespace 10, index=9 krfil=10 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:232 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.00001914 05/12/2002 16:19:39
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #11:
(name #10) F:ORACLEORADATASDUSUNYTWF.ORA
creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
tablespace 12, index=10 krfil=11 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:200 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.00081b82 10/05/2006 18:07:35
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #12:
(name #9) F:ORACLEORADATASDUSUNHLT.ORA
creation size=0 block size=8192 status=0xe head=9 tail=9 dup=1
tablespace 13, index=11 krfil=12 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:200 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.0007fbdb 10/05/2006 18:03:37
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #13:
(name #8) F:ORACLEORADATASDUSUNUSERS02.DBF
creation size=0 block size=8192 status=0xe head=8 tail=8 dup=1
tablespace 9, index=12 krfil=13 prev_file=14
unrecoverable scn: 0x0000.00183fda 01/11/2007 00:35:44
Checkpoint cnt:186 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.000a888f 11/24/2006 20:44:28
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #14:
(name #7) F:ORACLEORADATASDUSUNUSERS03.DBF
creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1
tablespace 9, index=12 krfil=14 prev_file=15
unrecoverable scn: 0x0000.00183fdb 01/11/2007 00:35:44
Checkpoint cnt:142 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.000ced41 11/26/2006 21:10:01
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #15:
(name #6) F:ORACLEORADATASDUSUNUSERS01.DBF
creation size=0 block size=8192 status=0xe head=6 tail=6 dup=1
tablespace 9, index=12 krfil=15 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:132 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.000d0c8c 11/27/2006 23:57:28
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #16:
(name #5) F:ORACLEORADATASDUSUNSUN.DBF
creation size=0 block size=8192 status=0xe head=5 tail=5 dup=1
tablespace 14, index=13 krfil=16 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:126 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.000d838d 12/01/2006 20:39:45
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #17:
(name #4) F:ORACLEORADATASDUSUNSUN2.ORA
creation size=0 block size=8192 status=0xe head=4 tail=4 dup=1
tablespace 15, index=14 krfil=17 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:128 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.000d9030 12/01/2006 21:00:49
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.0013262a prev_range: 0
Online Checkpointed at scn: 0x0000.0013262b 12/21/2006 21:37:57
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
DATA FILE #18:
(name #21) F:ORACLEORADATASDUSUNPERFSTAT.DBF
creation size=25600 block size=8192 status=0xe head=21 tail=21 dup=1
tablespace 17, index=17 krfil=18 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:48 scn: 0x0000.001e484e 05/08/2007 10:37:49
Stop scn: 0xffff.ffffffff 05/07/2007 11:40:37
Creation Checkpointed at scn: 0x0000.001589c4 01/06/2007 22:05:36
thread:1 rba:(0x2.12c11.10)
enabled threads: 01000000 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




***************************************************************************
TEMP FILE RECORDS <临时文件记录项（该项从Oracle9i开始引入）>
***************************************************************************
(blkno = 0x21, size = 56, max = 100, in-use = 1, last-recid= 1)
TEMP FILE #1: External File #201
(name #22) F:ORACLEORADATASDUSUNTEMP01.DBF
creation size=5120 block size=8192 status=0xe head=22 tail=22 dup=1
tablespace 2, index=15 krfil=1 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00




***************************************************************************
TABLESPACE RECORDS <表空间记录项（该项从Oracle8开始引入）>
***************************************************************************
(blkno = 0x20, size = 68, max = 100, in-use = 17, last-recid= 3)
TABLESPACE #0 SYSTEM: recno=1 <表空间号与name>
First datafile link=1 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #1 UNDOTBS1: recno=2
First datafile link=2 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #3 CWMLITE: recno=3
First datafile link=3 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #4 DRSYS: recno=4
First datafile link=4 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #5 EXAMPLE: recno=5
First datafile link=5 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #6 INDX: recno=6
First datafile link=6 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #7 ODM: recno=7
First datafile link=7 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #8 TOOLS: recno=8
First datafile link=8 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #10 XDB: recno=9
First datafile link=10 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #12 YTWF: recno=10
First datafile link=11 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #13 HLT: recno=11
First datafile link=12 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #9 USERS: recno=12
First datafile link=9 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #14 SUN: recno=13
First datafile link=16 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #15 SUN2: recno=14
First datafile link=17 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #2 TEMP: recno=15
First datafile link=1 Tablespace Flag=1
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #16 SUN3: recno=16
First datafile link=0 Tablespace Flag=1
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #17 PERFSTAT: recno=17
First datafile link=18 Tablespace Flag=0
Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00




***************************************************************************
RMAN CONFIGURATION RECORDS
***************************************************************************
(blkno = 0x22, size = 1108, max = 50, in-use = 8, last-recid= 24)
DEFAULT DEVICE TYPE TO:DISK recno=1
CHANNEL:DEVICE TYPE DISK MAXPIECESIZE 2 G recno=2
DEVICE TYPE:DISK PARALLELISM 3 recno=3
RETENTION POLICY:TO REDUNDANCY 1 recno=4
MAXSETSIZE TO:UNLIMITED recno=5
BACKUP OPTIMIZATION:ON recno=6
DATAFILE BACKUP COPIES FOR DEVICE TYPE:DISK TO 1 recno=7
CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE:DISK TO 'f:oraclermanctlctl_%F' recno=8

<使用过RMAN的最上述配置项应该都不陌生>


***************************************************************************
LOG FILE HISTORY RECORDS
***************************************************************************
(blkno = 0x29, size = 36, max = 226, in-use = 5, last-recid= 5)
<每个记录是36个字节，db_block_size=8192,那么max应该=8192/36=227，实际上=226，
那么剩余的8192-(226*36)=56个字节到哪里去了呢？存疑！>
Earliest record: <最早的记录>
RECID #1 Recno 1 Record timestamp 12/21/06 23:51:55 Thread=1 Seq#=1 Link-Recid=0
<记录号、记录的时间戳、线程以及前一次的记录号（最早的为0）>
Low scn: 0x0000.0013262b 12/21/06 21:37:57 Next scn: 0x0000.0013c9b9
<本次记录的low scn和next scn以及时间戳>
Latest record:
RECID #5 Recno 5 Record timestamp 04/27/07 20:31:47 Thread=1 Seq#=5 Link-Recid=4
Low scn: 0x0000.001bfcf4 01/26/07 21:15:40 Next scn: 0x0000.001d9522
<解释同上>
<注意：这里是level 3的controlfile结构，那么level 4的话，则会给出全部RECID #1/#5/#4/#3/#2>


***************************************************************************
OFFLINE RANGE RECORDS
***************************************************************************
(blkno = 0x2a, size = 56, max = 145, in-use = 0, last-recid= 0)




***************************************************************************
ARCHIVED LOG RECORDS <归档日志项>
***************************************************************************
(blkno = 0x2b, size = 584, max = 237, in-use = 5, last-recid= 5)
<
以下是个人观点：
每个记录是584个字节, db_block_size=8192, max = 237,
那么, 快数=size*237/db_block_size=584*237/8192=16块
>
Earliest record:
RECID #1 Recno 1 Record timestamp 01/11/07 00:01:01 Thread=1 Seq#=1
<记录号、记录的时间戳、线程>
Flags:
<
ARC00001.001文件的标示，deleted 表示这个归档已经删除，未在控制文件中保留（这里存疑！）
produced by archive operation 表示这个归档是由arch操作生成的
created by the foreground process 表示由后台进程创建
>
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
filename F:ORACLEORA92RDBMSARC00001.001
<归档文件路径及name>
Low scn: 0x0000.0013262b 12/21/06 21:37:57 Next scn: 0x0000.0013c9b9 12/21/06 23:51:55
<本次记录的low scn和next scn以及时间戳>
Block count=15733 Blocksize=512
<块大小512字节，块数15733，所以ARC00001.001文件的大小为：15733*0.512KB=8055KB=8MB>
Latest record:
RECID #5 Recno 5 Record timestamp 04/27/07 20:31:53 Thread=1 Seq#=5
Flags:
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
filename F:ORACLEORAARCARC00005.001
Low scn: 0x0000.001bfcf4 01/26/07 21:15:40 Next scn: 0x0000.001d9522 04/27/07 20:31:46
Block count=89984 Blocksize=512

<注意：这里是level 3的controlfile结构，那么level 4的话，则会给出全部RECID #1/#5/#4/#3/#2>


***************************************************************************
BACKUP SET RECORDS <备份集项>
***************************************************************************
(blkno = 0x3c, size = 40, max = 204, in-use = 10, last-recid= 10)
Earliest record:
RECID #1 Recno 1 Record timestamp 01/26/07 16:53:53
Backup set key: stamp=612896032, count=1
Backup status:
Backup contains:
Backup set is NOT part of the incremental strategy
Blocksize=8192 Piece-Count=1 Level=0 Time:
Backup does not have keep options.
Latest record:
RECID #10 Recno 10 Record timestamp 01/26/07 21:21:24
Backup set key: stamp=612912077, count=10
Backup status:
Backup contains:
Backup set is NOT part of the incremental strategy
Blocksize=8192 Piece-Count=1 Level=0 Time:
Backup does not have keep options.




***************************************************************************
BACKUP PIECE RECORDS <备份片项>
***************************************************************************
(blkno = 0x3d, size = 736, max = 210, in-use = 12, last-recid= 12)
Earliest record:
RECID #1 Recno 1 Record timestamp 01/26/07 16:53:53 piece #1 copy #1 pool 0
Backup set key: stamp=612896032, count=1
Flags:
Device: DISK
Handle: F:ORACLEORA92DATABASE1I8G390_1_1
Media-Handle:
Comment:
Tag: TAG20070126T165351
Completion time 01/26/07 16:53:53
Latest record:
RECID #12 Recno 12 Record timestamp 01/26/07 21:21:18 piece #1 copy #1 pool 0
Backup set key: stamp=612912077, count=10
Flags:
Device: DISK
Handle: F:ORACLERMANYTWF_0AI8GIUD
Media-Handle:
Comment:
Tag: TAG20070126T212116
Completion time 01/26/07 21:21:24




***************************************************************************
BACKUP DATAFILE RECORDS <备份数据文件项>
***************************************************************************
(blkno = 0x50, size = 116, max = 211, in-use = 10, last-recid= 10)
Earliest record:
RECID #1 Recno 1 Record timestamp 01/26/07 16:53:53 File=16 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=612896032, count=1
Creation checkpointed at scn: 0x0000.000d838d 12/01/06 20:39:45
File header checkpointed at scn: 0x0000.001b702b 01/26/07 16:53:53
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 9
Blocks scanned for backup 256 Block size 8192
Low Offline Range Recid 0
Latest record:
RECID #10 Recno 10 Record timestamp 01/26/07 21:21:25 File=11 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=612912077, count=10
Creation checkpointed at scn: 0x0000.00081b82 10/05/06 18:07:35
File header checkpointed at scn: 0x0000.001bff49 01/26/07 21:19:12
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 2662
Blocks scanned for backup 12800 Block size 8192
Low Offline Range Recid 0




***************************************************************************
BACKUP LOG RECORDS <备份日志项>
***************************************************************************
(blkno = 0x53, size = 76, max = 107, in-use = 4, last-recid= 4)
Earliest record:
RECID #1 Recno 1 Record timestamp 01/26/07 21:16:55 Thread=1 Seq#=3
Backup set key: stamp=612911780, count=9
Lowscn: 0x0000.001766a3 01/10/07 20:46:30 Next scn: 0x0000.0018291b 01/11/07 00:01:02
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
Block count=204798 Blocksize=512
Latest record:
RECID #4 Recno 4 Record timestamp 01/26/07 21:16:55 Thread=1 Seq#=1
Backup set key: stamp=612911780, count=9
Lowscn: 0x0000.0013262b 12/21/06 21:37:57 Next scn: 0x0000.0013c9b9 12/21/06 23:51:55
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
Block count=15733 Blocksize=512




***************************************************************************
DATAFILE COPY RECORDS <数据文件拷贝项>
***************************************************************************
(blkno = 0x54, size = 660, max = 210, in-use = 3, last-recid= 3)
Earliest record:
RECID #1 Recno 1 Record timestamp 12/21/06 22:55:16
File=0 (0) database id=3675493804 block size=8192
Flags:
Filename: C:ORADATACONTROLFILE.BKP
Creation checkpointed at scn: 0x0000.00000000 12/21/06 21:35:16
File header checkpointed at scn: 0x0000.00132656 12/21/06 21:38:26
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
Recovery Fuzzy scn and time scn: 0x0000.00000000 01/01/88 00:00:00
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 278
Low Offline Range Recid 0
Tag:
Copy does not have keep options.
Latest record:
RECID #3 Recno 3 Record timestamp 01/26/07 21:37:27
File=0 (0) database id=3675493804 block size=8192
Flags:
Filename: F:ORACLERMANCONTROL.BAK
Creation checkpointed at scn: 0x0000.00000000 12/21/06 21:35:16
File header checkpointed at scn: 0x0000.001c01b4 01/26/07 21:36:20
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
Recovery Fuzzy scn and time scn: 0x0000.00000000 01/01/88 00:00:00
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 278
Low Offline Range Recid 0
Tag:
Copy does not have keep options.




***************************************************************************
BACKUP DATAFILE CORRUPTION RECORDS
***************************************************************************
(blkno = 0x65, size = 44, max = 185, in-use = 0, last-recid= 0)




***************************************************************************
DATAFILE COPY CORRUPTION RECORDS
***************************************************************************
(blkno = 0x66, size = 40, max = 204, in-use = 0, last-recid= 0)




***************************************************************************
DELETION RECORDS
***************************************************************************
(blkno = 0x67, size = 20, max = 408, in-use = 12, last-recid= 12)
Earliest record:
RECID #1 Recno 1 Record timestamp 01/26/07 21:16:57
Object type=11 Object recid=1 Object timestamp= 01/11/07 00:01:01
Latest record:
RECID #12 Recno 12 Record timestamp 01/27/07 20:38:49
Object type=16 Object recid=2 Object timestamp= 01/26/07 20:18:55




***************************************************************************
PROXY COPY RECORDS
***************************************************************************
(blkno = 0x68, size = 852, max = 306, in-use = 0, last-recid= 0)




***************************************************************************
INCARNATION RECORDS
***************************************************************************
(blkno = 0x8b, size = 56, max = 145, in-use = 1, last-recid= 1)
Earliest record:
RECID #1 Recno 1 Record timestamp
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
Previous Resetlogs scn and time scn: 0x0000.000d4ce8 11/30/06 23:52:25
Latest record:
RECID #1 Recno 1 Record timestamp
Resetlogs scn and time scn: 0x0000.0013262b 12/21/06 21:37:57
Previous Resetlogs scn and time scn: 0x0000.000d4ce8 11/30/06 23:52:25
*** END OF DUMP ***