控制文件中
***************************************************************************
DATA FILE RECORDS
***************************************************************************
(size = 428, compat size = 428, section max = 100, section in-use = 4,
last-recid= 7, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
(name #7) +DISKGROUP1/ora/datafile/system.256.683895993
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:63 scn: 0x0000.000a326c 04/17/2009 15:59:49
Stop scn: 0xffff.ffffffff 04/17/2009 15:57:34
checkpoint cnt号:checkpoint的次数,stop scn当数据库正常打开时
这个值被设为无穷大。
Creation Checkpointed at scn: 0x0000.00000008 12/19/2006 04:17:12
thread:0 rba:(0x0.0.0)
数据文件中
DATA FILE #1: (name #7) +DISKGROUP1/ora/datafile/system.256.683895993 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:63 scn: 0x0000.000a326c 04/17/2009 15:59:49 Stop scn: 0xffff.ffffffff 04/17/2009 15:57:34 Creation Checkpointed at scn: 0x0000.00000008 12/19/2006 04:17:12 thread:0 rba:(0x0.0.0) enabled threads: 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. FILEHEADER (header前面的信息来自控制文件,后面的来自数据文件头部) Compatibility Vsn = 169870080=0xa200300 Db ID=1302124456=0x4d9cd7a8, Db Name='ORA' Activation ID=0=0x0 Control Seq=457=0x1c9, File size=61440=0xf000 File Number=1, Blksiz=8192, File Type=3 DATA Tablespace #0 - SYSTEM rel_fn:1 Creation at scn: 0x0000.00000008 12/19/2006 04:17:12 Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0 reset logs count:0x28c36cea scn: 0x0000.00089d08 reset logs terminal rcv data:0x0 scn: 0x0000.00000000 prev reset logs count:0x245542b5 scn: 0x0000.00000001 prev reset logs terminal rcv data:0x0 scn: 0x0000.00000000 recovered at 04/17/2009 15:59:47 status:0x2004 root dba:0x00400179 chkpt cnt: 63 ctl cnt:62 datafile cnt号和control file cnt号 begin-hot-backup file size: 0 Checkpointed at scn: 0x0000.000a326c 04/17/2009 15:59:49 begin scn号 thread:1 rba:(0x8.2.10) |
说明:
1.检查点计数就是常规检查点发生的次数。
2.ctl cnt就是数据文件获得的上一次成功的控制文件检查点计数,以确保上一次checkpoint是成功的。
cnt.gif
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20844861/viewspace-591560/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20844861/viewspace-591560/