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

当前位置: 数据库>oracle

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

来源: 互联网发布时间：2017-05-30

本文导语: 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...

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;

您可能感兴趣的文章:

本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。