Originally posted by gk
Hi,
I am new to Oracle.
During start up i get the following message:

ORA - 01122 Database file 1 failed verification check
ORA - 01110 : DATA FILE 1 :
"/home/oracle/product/9.0.1/oradata/oralin/system01.dbf"
ORA - 01207 : File is more recent than controlfile - old controlfile

Please let me know how can i fix that.
Thank you.
GK
Do the following.

1. Take a trace of controlfile.

SQL > alter database backup controlfile to trace;

2. You can find the file in userdump dest. Open the trace file and edit for neccesary changes.

3. Startup the database in nomount state.

SQL > startup nomoun

4. Run the controlfile script create in step 2

SQL > @cfile.sql

5. Recover the db

SQL > recover database using backup controlfile

6. Open the database.

SQL > alter database open;

I guess this works..