| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Controlfile corruption
Something went wrong with your DB.
It seems that the system01.dbf is newer then the controlfile.
Did you copy or restore something?
// *Cause: The information in this file is inconsistent with information // from the controlfile. See accompanying message for reason. // *Action: Make certain that the db files and controlfiles are the correct // files for this database.
oracle> oerr ora 01207
01207, 00000, "file is more recent than controlfile - old controlfile"
// *Cause: The controlfile change sequence number in the data file is // greater than the number in the controlfile. This implies that // the wrong controlfile 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 // controlfile change sequence number until it is great enough. // *Action: Use the current controlfile or do backup controlfile recovery to // make the controlfile current. Be sure to follow all restrictions // on doing a backup controlfile recovery.
Jan M. Stankovsky <jan_at_ifs.univie.ac.at> wrote in message
news:387DBCB0.D9EDA25A_at_ifs.univie.ac.at...
> Hello !
>
> Useing Oracle8i EE on Solaris 7 I got for the third time over 1 month
> periode problems with the controlfile. This time I got:
>
> ORA-01122: database file 1 failed verification check
> ORA-01110: data file 1: 'system01.dbf'
> ORA-01207: file is more recent than controlfile - old controlfile
>
> Last time there was an other errormessage concerning the controlfiles,
> but I can't remember now.
>
> The database is only accessed with php3 and sqlplus.
>
>
> Thank you very much for any help/pointers !
Received on Thu Jan 13 2000 - 06:21:15 CST
 |
 |