OraFAQ Forum: Backup & Recovery » ORA-01207: file is more recent than controlfile

Home » RDBMS Server » Backup & Recovery » ORA-01207: file is more recent than controlfile - old controlfile (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01207: file is more recent than controlfile - old controlfile [message #417954]

Wed, 12 August 2009 04:58

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator