When I startup mount, it gives me an error codes. There error code is:
ORA-002014 control file
......apple1.ora version 22028 inconsistent with file ......apple2.ora version 21764
How can I fix this error?
You're database is in an inconsistent state. You will have to recover.
Restore from Backup and start recovering from that point applying Archive redo.
The error states that ur controlfile appl1.ora is not consistent with controlfile apple2.ora.
The solution to the problem is remove the name of the bad controlfile from the CONTROL_FILES init.ora paramter and then try to restart the database.
Once the database is opened u can shutdown the database and make another copy of controlfile and enter the name in CONTROL_FILES init.ora file and restrt the database.
In case of any help please be free to ask me at firstname.lastname@example.org
Rohit Nirkhe,Oracle DBA,OCP 8i
Hi, 27th May 2001 20:15 hrs chennai
The Oracle error number you have mentioned is incorrect.
Oracle Document says like this on your error
ORA-00214 control file '?' version ? inconsistent with file '?' version ?
Cause: Versions of control files and datafiles/logfiles mismatch
Action: 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
try as suggested by rohit if you still have problem
please get back to the forum
I would also like to know at what time of your work you got this error say trying to restore from backup after crash etc...
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Click Here to Expand Forum to Full Width