ORA-01207 file is more recent than controlfile - old controlfile
I have a problem with my Oracle database 9i on Win2k Server. While I am not a DBA, I had to do an install in order to work on my oracle application. I basically had created a database OCTRN a month back. I also have a repository of the database but not sure why.
When I tried to automatically start , mount and open the database in EM stand alone, I get an error saying:
ORA-01122: database file 11 failed verification check
ORA-01110: datafile 'F:\opapps45\OCTRN\OCL_APP.DBF'
ORA-01207: file is more recent than controlfile - old controlfile
How can I sort this problem and start my database?.
Right now, it only starts and mounts but does not open. I don't have a backup but I have some ARCHIVE logfiles in the home\rdbms directory. The last ARCHIVE LOG FILE is 2nd MARCH 2006 7:15 AM. and the previous one is 1st MARCH.
I'd appreciate if someone could tell me the best way I can recover this or resolve this issue. I don't mind if I have to drop the datafile and recreate it.
When I typed ALTER database datafile 'F:\opapps45\octrn\ocl_app.dbf' offline; ir gave me an ORA-01516: nonexistent log file, datafile or tempfile 'F:\opapps45\octrn\ocl_app.dbf'.
Seems you've played with files. You'll need to recreate the controlfiles.
1) backup controlfile to trace, 2) recreate the controlfiles usring the new trace file created in user_dump_dest 3) open the database with RESETLOGS option.