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用户可以开启执行
，
