同时对控制文件做了dump：
?
***************************************************************************
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)
?01/12/2015 18:49:02
?DB Name "ODSPTDB"
?Database flags = 0x00404000 0x00001000
?Controlfile Creation Timestamp? 01/12/2015 18:49:02
?Incmplt recovery scn: 0x0000.00000000
?Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp? 01/12/2015 18:49:02
?Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp? 01/01/1988 00:00:00
?Redo Version: compatible=0xb100000
?#Data files = 99, #Online files = 99
?Database checkpoint: Thread=1 scn: 0x0c54.65c08713
?Threads: #Enabled=1, #Open=0, Head=0, Tail=0
--------------------------
SQL> select to_number('0c5465c08713','xxxxxxxxxxxxxxxxxxxxxxxxx') abc_scn from dual;
? ? ? ? ? ? ? ? ? ? ? ABC_SCN
-----------------------------
? ? ? ? ? ? ? 13556623902483
?--------------------------
***************************************************************************
CHECKPOINT PROGRESS RECORDS
***************************************************************************
?(size = 8180, compat size = 8180, section max = 11, section in-use = 0,
? last-recid= 0, old-recno = 0, last-recno = 0)
?(extent = 1, blkno = 2, numrecs = 11)
THREAD #1 - status:0x2 flags:0x0 dirty:3
low cache rba:(0xc1.6b5346.0) on disk rba:(0xc1.6b5349.0)
on disk scn: 0x0c54.65c038f3 03/10/2000 10:16:58
resetlogs scn: 0x0000.00000001 01/12/2015 18:49:02
?
***************************************************************************
REDO THREAD RECORDS
***************************************************************************
?(size = 256, compat size = 256, section max = 8, section in-use = 1,
? last-recid= 0, old-recno = 0, last-recno = 0)
?(extent = 1, blkno = 9, numrecs = 8)
THREAD #1 - status:0xe thread links forward:0 back:0
?#logs:4 first:1 last:4 current:1 last used seq#:0xc1
?enabled at scn: 0x0000.00000001 01/12/2015 18:50:33
?disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
?opened at 01/13/2015 09:39:34 by instance odsptdb
Checkpointed at scn:? 0x0c54.65c08713 03/10/2000 10:16:58
?thread:1 rba:(0xc1.6b5349.10)
***************************************************************************
LOG FILE RECORDS
***************************************************************************
?(size = 72, compat size = 72, section max = 16, section in-use = 4,
? last-recid= 4, old-recno = 0, last-recno = 0)
?(extent = 1, blkno = 10, numrecs = 16)
LOG FILE #1:
? (name #1) /oradata/odsptdb/odsptdb/redo01.log
?Thread 1 redo log links: forward: 2 backward: 0
?siz: 0xa00000 seq: 0x000000c1 hws: 0x2 bsz: 512 nab: 0x6b5349 flg: 0xa dup: 1
?Archive links: fwrd: 0 back: 0 Prev scn: 0x0c54.65bea140
?Low scn: 0x0c54.65beb699 03/09/2015 21:08:01
?Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
?
<<<<<<<<<<<<<
databasescn: 0x0c54.65c08713? <<<< 控制文件的SCN
on disk scn:? 0x0c54.65c038f3? <<<redo low scn: 0x0c54.65beb699
<<<<<<<<<<<<<
鉴于控制文件里的SCN和数据文件头部SCN都一致，所以尝试resetlogs方式打开数据库
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open ;? ? ?