ORA- 01207  file is more recent than controlfile - old controlfile

Cause: The control file change sequence number in the datafile is greater than the number in the control file.
This implies that the wrong control file is being used. Note that repeatedly causing this error can make it
stop happening without correcting the real problem. Every attempt to open the
database will advance the control file change sequence number until it is great enough.

Action: Use the current control file or do BACKUP CONTROLFILE RECOVERY to make the control file current.
Be sure to follow all restrictions on doing a BACKUP CONTROLFILE RECOVERY.

$ svrmgrl

Oracle Server Manager Release  3 . 1 . 7 . 0 . 0  - Production

Copyright (c)  1997 ,  1999 , Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release  8 . 1 . 7 . 4 . 1  - Production
With the Partitioning option
JServer Release  8 . 1 . 7 . 4 . 1  - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area                         395696156  bytes
Fixed Size                                           75804  bytes
Variable Size                                     79990784  bytes
Database Buffers                                 314572800  bytes
Redo Buffers                                       1056768  bytes
Database mounted.
ORA- 01157 : cannot identify/lock data file  4  - see DBWR trace file
ORA- 01110 : data file  4 : 'C:\ORACLE\ORADATA\CESL2\TEMP01.DBF'

SVRMGR> alter database datafile  4  offline drop;
Statement processed.
SVRMGR> alter database open
      2 > /
Statement processed.
SVRMGR> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            C:\oracle\ora817ee\RDBMS
Oldest online log sequence      562 
Current log sequence            564 

SVRMGR> select file_name from dba_data_files where file_id= 4 ;
FILE_NAME
 --------------------------------------------------------------------------------
 
C:\ORACLE\ORADATA\CESL2\TEMP01.DBF
 1  row selected.

SVRMGR> drop tablespace temp;
Statement processed.

SVRMGR> create temporary tablespace temp tempfile 'C:\ORACLE\ORADATA\CESL2\TEMP01.DBF' size 1000M extent management local uniform size 100M;
Statement processed.

SVRMGR> select file_name from dba_data_files where file_id= 4 ;
FILE_NAME
 --------------------------------------------------------------------------------
 
 0  rows selected.