Tuesday 4 September 2012


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