Catatan kerja

Database beberapa permasalahan yang terjadi di tempat kerja

ORA-00214: Controlfile Version Inconsistent on Startup or Shutdown October 28, 2008

Filed under: Oracle — aderahman @ 4:03 am

Problem Description:
——————-
ORA-00214: control file version inconsistent with file .

Cause of The Problem:
——————-
Oracle detects an inconsistency between the mirrored copies of the control file.

All copies of the control file must have the same internal sequence number for oracle to start up the database or shut it down in normal or immediate mode.

If the database is running and the checkpoint in the file header could not be advanced the datafile will be taken offline.

Typical scenarios in which you may receive an ORA-00214 include:

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).

Fix:
To fix the error start your database with single copy of the control file and then shut the database down and then copy the version of good copy of control file onto the other mirror copies.

Steps:

1) If database is still up do a shutdown abort.
2) Edit the CONTROL_FILES parameter from init.ora and modify it to include just one copy of control file.
3) Start the database in restricted mode. startup restrict
If it is fine go to step 4.

If instead you get ORA-1122, ORA-1110, and ORA-1207, go back to step 2 and try with another controlfile.

If you have already tried each and every one of the mirrored copies unsuccessfully, you must create a new control file for the database.

If you get ORA-1113 and ORA-1110 pointing to one of the datafiles, it means the copy of the control file you picked is good, but the referenced datafile must be recovered before the database can be opened.Then RECOVER DATBASE, apply the log it prompt and ALTER DATABASE OPEN.

4. Shut the database down.

5. Copy the good mirrored copy of the control file that you just used to bring the database up onto all other copies, as originally listed in the CONTROL_FILES parameter of your init.ora file.

6. Edit the init.ora file’s CONTROL_FILES parameter to include all mirror copy again.

7. Start the database.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s