469,138 Members | 1,384 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,138 developers. It's quick & easy.

please help me


i'm halan ihave a database designed in oracle 8i and i have this message error by starting my base ora-00214

i replace the most the others control file by by the more recent: nothing go on

what can i do please
Jul 11 '07 #1
2 1004
8,127 Expert 4TB
Cause: An inconsistent set of control files, datafiles/logfiles, and redo files was used.
Action: Use a consistant set of control files, datafiles/logfiles, and redo log files. That is, all the files must be for the same database and from the same time period.
Jul 12 '07 #2
8,127 Expert 4TB
This occurs when control files are not in sync.
Take copy of all costrol files to a directory.

If you have say 3 copies of controlfiles, specify only one file name in the
control_file parameter. try to start the database. If the database opens,
then you are good. If fails, try with another one.

Finally when the database is open, copy the good one as well as all other
controlfile. close and reopen database with original control_file parameter
Jul 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Numberwhun | last post: by
1 post views Thread by HolaGoogle | last post: by
2 posts views Thread by rked | last post: by
23 posts views Thread by Jason | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.