ORA-01207 tips Oracle Tips by Burleson Consulting

Question:  I have of test a server where recreates my database exactly equal PRD in another server, taking for it a Full Backup Offline of the original system. Which I obtained successfully my exact copy of my system PRD with a backup offline and I included control files, data files, redo logs, etc.  When I try to start the database to recover, I get this error:

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'u01/oracle/app/data/xxx'
ORA-01207: file is more recent than controlfile - old controlfile

Answer:  Let's look tat the ORA-01207 error:

ORA-01207:  ORA-01207 file is more recent than controlfile - old controlfile

Cause: The control file change sequence number in the datafile 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 CONTROLFILE RECOVERY to make the control file current. Be sure to follow all restrictions on doing a BACKUP CONTROLFILE RECOVERY.

*******************************************************

If this is a production recovery, first open an emergency (Sev 1) Oracle SR (Service Request) on MetaLink.

First, how come the controlfile is too old?  That's the root cause, the error is just the symptom.  The controlfile MUST be more recent than the datafiles.  Note:  Check your alert logs to GUARANTEE that no data files were added since the data of the "old" controlfile.

You have several recovery options:

1 - Get the "original" controlfile at the time of the crash and replace it in all replicated places noted in your control_files parameter. Recover database.

2 - If you are POSITIVE that it's right for you, do an "Alter database backup controlfile to trace;" and use the current "old" controlfile to re-create the controlfile. Re-create the database with this controlfile.  Recover database and loose data.

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.