在正常情况下Controlfile中记录的Incmplt recovery scn是0x0000.00000000,只有在进行不完全恢复的时候Incmplt recovery scn的值才会改变,改变的values就是Database Checkpoint中的value,也就是我们常说的system checkpoint scn. 那么这个值主要预示着database将来是要通过resetlogs方式open的。通过比较两次controlfile的转储我们就可以看出:
file 1:
***************************************************************************
DATABASE ENTRY
***************************************************************************
(size = 316, compat size = 316, section max = 1, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 1, numrecs = 1)
07/15/2008 16:11:32
DB Name "ICMNLSDB"
Database flags = 0x00404000 0x00001000
Controlfile Creation Timestamp 07/15/2008 16:11:34
Incmplt recovery scn: 0x0000.00000000 Resetlogs scn: 0x0000.000776d8 Resetlogs Timestamp 07/16/2008 18:34:21
Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp 07/15/2008 16:11:32
Redo Version: compatible=0xa200300
#Data files = 4, #Online files = 4
Database checkpoint: Thread=1 scn: 0x0000.00077cfd Threads: #Enabled=1, #Open=0, Head=0, Tail=0
file 2
***************************************************************************
DATABASE ENTRY
***************************************************************************
(size = 316, compat size = 316, section max = 1, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 1, numrecs = 1)
07/15/2008 16:11:32
DB Name "ICMNLSDB"
Database flags = 0x00404042 0x00001000
Controlfile Creation Timestamp 07/15/2008 16:11:34
Incmplt recovery scn: 0x0000.00077cfd Resetlogs scn: 0x0000.000776d8 Resetlogs Timestamp 07/16/2008 18:34:21
Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp 07/15/2008 16:11:32
Redo Version: compatible=0xa200300
#Data files = 4, #Online files = 4
Database checkpoint: Thread=1 scn: 0x0000.00077cfd Threads: #Enabled=1, #Open=0, Head=0, Tail=0