Re: Oracle doesn't want to open the database at startup

y2k% oerr ora 01207
01207, 00000, "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 controlfile recovery to
//         make the control file current. Be sure to follow all restrictions
//         on doing a backup controlfile recovery.

Satar Naghshineh
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

In article <364C0861.5A70D1E9_at_clihop.com>,   Diego Fernandez-Bravo <dev_at_clihop.com> wrote:
> When I start the databse with the SQL statement: 'alter databse oracle
> open;',
> I have the following error messages :
>
> ORA-01122: echec de controle de verification pour fichier BdD 9
> ORA-01110: fichier de donnees 9:
> '/u/services-clihop/SEC000A/bases/SEC000A.tb'
> ORA-01207: fichier plus recent que fichier de controle - ancien fichier
> de controle
>
> Can someone tell me what I should do to get rid of those errors et make
> the database start correctly ???
>
> Where can I find the control file of the 'SEC000A.tb' tablespace ??
>
> Thanks,
>
> D. F-B
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 00:00:00 CST