如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com
适用于：
Oracle Server – Enterprise Edition – 版本: 9.2.0.6
该问题可能出现在任何平台。
症状
Error in alert.log:
Shutting down instance: further logons disabled
WARNING! CONTROLFILE SEQUENCE NUMBER TOO OLD, RE-READING…
WARNING! CONTROLFILE SEQUENCE NUMBER TOO OLD, RE-READING…
WARNING! CONTROLFILE SEQUENCE NUMBER TOO OLD, RE-READING…
Verified the issue by the alert log file which displays:
Shutting down instance: further logons disabled
WARNING! CONTROLFILE SEQUENCE NUMBER TOO OLD, RE-READING…
WARNING! CONTROLFILE SEQUENCE NUMBER TOO OLD, RE-READING…
WARNING! CONTROLFILE SEQUENCE NUMBER TOO OLD, RE-READING…
原因
虽然不能确认但很可能控制文件被一个旧副本覆盖。
alert.log表明控制文件的读显示，在控制文件中的信息比预期的旧：
“The controlfile header block returned by the OS has a sequence number that is too old.”
解决方案
要实施解决方案，请执行以下步骤：
(1) 保存控制文件的所有副本进行之后的分析，并联系你的OS 供应商和Oracle support。
(2) Mount实例并发出：
ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS;
(3) shutdown immediate;
(4) 启动nomount;
(5) 重建控制文件并打开数据库。
(6) 恢复数据库；
(7) alter database open;
Comment