ORA-01122: database file 1 failed verification check


When database startup, it send this message to the console,

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1:
‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\ITCAPPS2\SYSTEM01.DBF’
ORA-01207: file is more recent than control file – old control file

To fix this, try

  1. alter database backup controlfile to trace;
  2. startup nomount;
  3. recover database using backup controlfile;
  4. alter database open;

Hope this will work ^_^

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: