Early in the morning to do my daily plsqlchallenge question I tried logging into my local database and bam I hit the ORA-00214 error. Well actually I hit this error when I try to start up my database. I guess the error was because I shut my machine down forcefully by plugging off my machine. I guess this was what caused the inconsistencies in the control files. The possible causes for this issue in the documentation were the following:
1) You have restored the control file from backup, but forgot to copy it onto all of the mirrored copies of the control file as listed in the "CONTROL_FILES" parameter in the initialization parameter
2) You have moved one or more copies of the control file to a different location while the database was up and running.
3) You accidentally overwrote one of the copies of the control file with an old copy.
4) The database or the system crashed while the mirrored copies of the control file were being updated, causing them to be out of sync.
5) You are restoring a database backup that was improperly taken with the database up and running ("fuzzy" backup).
In my case it was the error 4 which caused the error.
The solution was easy compared to what it could be. Below are the steps that I took to start up the database.
1) Shutdown the database
a. Shutdown immediate
2) Start up the database with nomount
a. startup nomount
3) Alter the control files to one of the control fiels.
a. ALTER SYSTEM SET CONTROL_FILES=file_name
4) Open the database.
a. Alter database open
With these commands my database was up and running and I am done for the day’s learning. I should definitely link this site for helping me out in fixing my issue.
No comments:
Post a Comment