Home » RDBMS Server » Backup & Recovery » ORA-01207: file is more recent than controlfile - old controlfile (Oracle 9i)
ORA-01207: file is more recent than controlfile - old controlfile [message #417954] Wed, 12 August 2009 04:58 Go to next message
JoinNepal
Messages: 33
Registered: October 2003
Member
Hi,
I got this error when I tied to start Oracle Database from SQL Prompt:

SQL> startup
ORACLE instance started.

Total System Global Area 126950220 bytes
Fixed Size 453452 bytes
Variable Size 109051904 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\TDB\SYSTEM01.DBF'
ORA-01207: file is more recent than controlfile - old controlfile


SQL>
Can anyone help me to resolve this please?

Thanks in advance.

Kind Regards,

JoinNepal
Re: ORA-01207: file is more recent than controlfile - old controlfile [message #417966 is a reply to message #417954] Wed, 12 August 2009 05:30 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01207: file is more recent than control file - old control file
 *Cause:  The control file change sequence number in the data file 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 control file recovery to
         make the control file current. Be sure to follow all restrictions
         on doing a backup control file recovery.

Regards
Michel
Re: ORA-01207: file is more recent than controlfile - old controlfile [message #417990 is a reply to message #417966] Wed, 12 August 2009 06:49 Go to previous messageGo to next message
JoinNepal
Messages: 33
Registered: October 2003
Member
Can you pls give me complete steps to perform to recover?

Thanks.
Re: ORA-01207: file is more recent than controlfile - old controlfile [message #417994 is a reply to message #417990] Wed, 12 August 2009 07:37 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Recreate your controlfile

http://www.google.co.in/search?hl=en&ei=X7eCSonAN8iTkAWold3WCg&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=ho w+to+recreate+controlfile+in+oracle&spell=1

Thanks

[Updated on: Wed, 12 August 2009 07:39]

Report message to a moderator

Re: ORA-01207: file is more recent than controlfile - old controlfile [message #418098 is a reply to message #417994] Wed, 12 August 2009 23:16 Go to previous messageGo to next message
JoinNepal
Messages: 33
Registered: October 2003
Member
Pls give me the steps to re-create control files.

Syntax I mean.

Thanks.

JoinNepal
Re: ORA-01207: file is more recent than controlfile - old controlfile [message #418109 is a reply to message #418098] Wed, 12 August 2009 23:49 Go to previous message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read the answers that is given and follow them.
The steps and syntax and everything are in the link posted by gentlebabu.

Regards
Michel

[Updated on: Wed, 12 August 2009 23:50]

Report message to a moderator

Previous Topic: rman instance shutdown suddenly
Next Topic: Migrating Postgres BLOB data to Oracle
Goto Forum:
  


Current Time: Fri Dec 19 17:41:15 CST 2014

Total time taken to generate the page: 0.09138 seconds