Click to See Complete Forum and Search --> : ORA - 01122 Database file 1 failed verification check
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
sarannn_99
09-27-2002, 03:03 AM
U have the old controlfile instead the current one so, the datafile can't sync with it(Mismatch in Ckpt no.). Check ur controlfile and restore the current one..
bye
I am sorry for the rookie question, but how do you restore the current one ?
Thanks for your time .
GK
Sharma
09-27-2002, 05:30 PM
It looks like the old controlfile is restored. If you can find copy of current control file then it is fine. Otherwise you may have to recover using the option USING BACKUP CONTROL FILE;
I think this operation should not be perfomed by Rookie. But again, it is just a my opinion.
Prince
09-28-2002, 05:20 AM
ORA-01122 database file string failed verification check
Cause: The information in this file is inconsistent with information from the control file. See accompanying message for reason.
Action: Make certain that the database files and control files are the correct files for this database.
nagarjuna
09-28-2002, 05:40 AM
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..