--转储eye表空间数据文件头----

DATA FILE #5:

(name #9) /oracle/oradata/orcl/eye1.dbf

creation size=12800 block size=8192 status=0xc head=9 tail=9 dup=1

tablespace 7, index=6 krfil=5 prev_file=0

unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

Checkpoint cnt:5 scn: 0x0000.000bd805 08/18/2010 20:02:13

Stop scn: 0x0000.000bd805 08/18/2010 20:02:13

Creation Checkpointed at scn: 0x0000.000bd5fc 08/18/2010 19:54:44

thread:1 rba:(0x11.609.10)

enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 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 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000

Hot Backup end marker scn: 0x0000.00000000

--上面来源于控制文件，下面源于数据文件头，但数据文件被我rm了，所以找不到了

aux_file is NOT DEFINED

ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

ORA-01110: data file 5: '/oracle/oradata/orcl/eye1.dbf'

*** Error 1157 in open/read file # 5 ***

---在oracle mount时转储system表空间数据文件头

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:88 scn: 0x0000.000bd805 08/18/2010 20:02:13 ---控制文件checkpoint cnt及scn为0x0000.000bd805 及checkpoint cnt为88

Stop scn: 0x0000.000bd805 08/18/2010 20:02:13

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

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

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=799=0x31f, 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 19:37:17

status:0x2000 root dba:0x00400179 chkpt cnt: 88 ctl cnt:87

begin-hot-backup file size: 0

Checkpointed at scn: 0x0000.000bd805 08/18/2010 20:02:13 --数据文件的checkpoint scn为0x0000.000bd805,checkpoint cnt为88

thread:1 rba:(0x12.15158.10)

enabled threads: 01000000 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

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头转储system 表空间数据文件头----

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:89 scn: 0x0000.000bd806 08/18/2010 20:11:55 --数据库open后，控制文件的checkpoint scn等待数据文件的checkpoint scn，且二者的checkpoint count计数据器一样

Stop scn: 0xffff.ffffffff 08/18/2010 20:02:13 ---数据库open后，stop scn置为无穷大0xffff.ffffffff

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

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

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=805=0x325, 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 19:37:17

status:0x2004 root dba:0x00400179 chkpt cnt: 89 ctl cnt:88

begin-hot-backup file size: 0

Checkpointed at scn: 0x0000.000bd806 08/18/2010 20:11:55

thread:1 rba:(0x12.15158.10)

enabled threads: 01000000 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

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在mount及open时，控制文件及数据文件头关于checkpoint及scn（cnt)的信息是不一样的，会有变动的

mount会验证比较控制文件的stop scn是否等待数据文件（头）的scn(checkpoint)及checkpoint cnt是否一致

open会置数据文件（file header之前：就是源于控制文件中的）的stop scn为无穷大，因为open后，数据库处于变动状态，所以stop scn为不定的，故配置为无穷大

--10046事件可以运行在nomount,mount,open状态下

SQL> alter session set events='10046 trace name context forever,level 12';

Session altered.

SQL> alter session set events='10046 trace name context off';

Session altered.

ITPub博客

oracle mount_open_checkpoint(scn)启动验证测试

最新文章