-
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
-
Hi list
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
Saravanan Oracle DBA(8i OCP)
-
I am sorry for the rookie question, but how do you restore the current one ?
Thanks for your time .
GK
-
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.
-
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.
Ajmal Chishti
-
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..
-nagarjuna
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|