ORA-1122,ORA-1110,ORA-1207whileopenthedatabaseafterc

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

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

[日期：2014-01-12] 来源：Linux社区 作者：carefree [字体：]

symptoms：
ORA-1122 :database file %s failed verification check
ORA-1110 : datafile :
ORA-1207: ORA 1207 file is more recent than control file

Cause：
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;

推荐阅读：

ORA-01172、ORA-01151错误处理

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏，或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法

Oracle 10g打补丁（p5490848_10202_LINUX）

授权scott用户可以开启执行