ORA-1122, ORA-1110, ORA-1207 while open the database after crash

symptoms：
ORA-1122 :database file %s failed verification check
ORA-1110 : datafile :
ORA-1207: ORA 1207 file is more recent than control fileCause：
The information in this file is inconsistent with information from the control file.
The datafile header CHECKPOINT count is beyond the controlfile CHECKPOINT count.Solution：
1.Mount the database
SQL> Startup mount
2. Save the information from the control file:
SQL> Alter database backup controlfile to trace as "/u01/app/Oracle/controlfile.txt";
3. Create a control file creation script from the tracefile generated in user_dump_dest.
Use the Noresetlogs option
4. Shutdown the database and start it in NOMOUNT mode
SQL> shutdown abort
SQL> startup nomount
5. Create the control file
Use the script generated by the "backup controlfile to trace" command above.
6.Recover the database
SQL> recover database;
7. Open the database
SQL> Alter database open;更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12推荐阅读：ORA-01172、ORA-01151错误处理 http://www.linuxidc.com/Linux/2013-06/86529.htmORA-00600 [2662]错误解决 http://www.linuxidc.com/Linux/2013-06/86528.htmORA-01078 和 LRM-00109 报错解决方法 http://www.linuxidc.com/Linux/2012-07/66044.htmORA-00471 处理方法笔记 http://www.linuxidc.com/Linux/2013-09/90017.htmORA-00314,redolog 损坏，或丢失处理方法 http://www.linuxidc.com/Linux/2013-09/90646.htmORA-00257 归档日志过大导致无法存储的解决办法 http://www.linuxidc.com/Linux/2013-09/90594.htmOracle 10g打补丁（p5490848_10202_LINUX）授权scott用户可以开启执行相关资讯 ORA-1122 ORA-1110 ORA-1207 本文评论查看全部评论（0）