1745804 Members
3739 Online
108722 Solutions
New Discussion юеВ

Oracle Recovery Error

 
SOLVED
Go to solution
hasan420
Occasional Contributor

Oracle Recovery Error

After i recoverd the Database (cold Backup wa done) get the follwing Error Message
ORA-00214: controlfile '/oradata/tcepwc11/control03.ctl' version 199
inconsistent with file '/app/oracle/oradata/tcepwc11/control01.ctl' version 161

I have tried to restore this 2 Cotrolfiles from same backup , but still same Problem

2 REPLIES 2
Steve Steel
Honored Contributor
Solution

Re: Oracle Recovery Error

Hi

oerr ora 214
00214, 00000, "controlfile '%s' version %s inconsistent with file '%s' version %
s"
// *Cause: An inconsistent set of controlfiles, datafiles/logfiles, and redo
// files was used.
// *Action: Use a consistant set of controlfiles, datafiles/logfiles, and redo
// log files. That is, all the files must be for the same database
// and from the same time period.


Thus you have had it

See what the differen ce is and then try using one of the files copied to the other name so that they are the same


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Simon Wickham_6
Regular Advisor

Re: Oracle Recovery Error

ORA-00214 means an inconsistent set of control files, datafiles, and redo log files was used.

To resolve this use a consistent set of control files, datafiles, and redo log files. That is, all the files must be for the same database and from the same time period.

Regards,
Simon