ORA-00214: Controlfile Version Inconsistent
Reason;
During the database shutdown one of the control file went inconsistent state .
Solution ,
1.Cut the inconsistent file and paste some other locations.
2.Now you have only two control file to mount your DB .
3. Edit the pfile and delete that inconsistent controlfile,and startup using pfile .
4.Now check the number of controlfiles using { select name from v$controlfile; }
If it is started , your DB is up and running no problem with your controlfile .
5.Shut down the database
6.Manually create one cotrolfile from others using copy & paste and rename the file what you want other .
7.Edit the pfile and enter the added controlfile name .
8.Startup the DB and create spfile from pfile .using (create spfile from pfile='location';)
9.Finally again one shut and start the database successfully
10.Now check the number of controlfiles { select name from v$controlfile; }
Do best.
Regards,
Suresh R
No comments:
Post a Comment