ORA-01207: 文件比控制文件更新 - 旧的控制文件

Errors
ORA-1122 ORA-1110 ORA-1207

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.
Fix
1.Mount the database
SQL>Startup mount

2. trace the control file

SQL> alter database backup controlfile to trace as 'f:\aa';

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 NOMOUNT mode

SQL>shutdown abort
SQL>startup NoMount

5.Create the control file

6.Recover database

SQL>recover database ;

7.Open the database

SQL>Alter database open ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10742223/viewspace-343274/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10742223/viewspace-343274/