ORA-1122 :database file %s failed verification check
ORA-1110 : datafile :
ORA-1207: ORA 1207 file is more recent than control file
该错误表明:
数据文件头部信息与控制文件信息部一致,数据文件头部CHECKPOINT大于controlfile
CHECKPOINT,需要重建控制文件
1.Mount the database
SQL> Startup mount
2. Save the information from the control file:
SQL> Alter database backup controlfile to trace;
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
alter database backup controlfile to trace;
6.Recover the database
SQL> recover database;
7. Open the database
SQL> Alter database open;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-1075613/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15747463/viewspace-1075613/