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

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;