ORA-01122: database file 1 failed verification check I moved data file and database started fine but I did the following steps:

SQL&gt; shutdown
SQL&gt; startup nomount
SQL&gt; alter system set control_files='/var/oracle/oradata/control.dbf' scope=spfile;
# shut immediate
# chown oracle:dba /var/oracle/oradata/control.dbf
# chmod 755 /var/oracle/oradata/control.dbf
# su – oracle
sqlplus / as sysdba
SQL&gt; startup

Total System Global Area 1068937216 bytes  
Fixed Size                  2233344 bytes  
Variable Size             813698048 bytes  
Database Buffers          247463936 bytes  
Redo Buffers                5541888 bytes  
Database mounted.  

ORA-01122: database file 1 failed verification check  
ORA-01110: data file 1: '/var/oracle/oradata/system.dbf'  
ORA-01207: file is more recent than control file - old control file  


and now I'm unable to resolve this error.
The SCN in the data file is greater than the SCN in the control file or wrong control file is being used. Please use correct control file. 

If the the control fle is correct then do BACKUP CONTROLFILE RECOVERY.

Steps:

SQL&gt;startup mount

SQL&gt; recover database using backup controlfile until cancel;


it will ask you for archive logs, give the path of all archive logs which it needs until it gives you message, 

MEDIA RECOVERY COMPLETED.


Open the database.

SQL&gt; alter database open;