Oracle 控制文件太旧,在数据库打开时生成错误

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

关注刘相兵的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

Speak Your Mind

沪ICP备14014813号

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569