如果自己搞不定可以找诗檀软件专业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;