Friday, September 4, 2009

ORA-00214: Controlfile Inconsistent Error

Error Description:

During database Startup noticed the below Error in alert log file:
ORA-00214: control file 'ORACLE_HOME\CONTROL02.CTL' version 3016
inconsistent with file 'ORACLE_HOME\CONTROL01.CTL' version 2993

Resolution:

Step 1: Shutdown the database abruptly (SQL>shutdown abort)
Step 2: Create the pfile using spfile (SQL>create pfile='ORACLE_HOME\pfile.ora' using spfile)
Step 3: Edit the ORACLE_HOME\pfile.ora file
Step 4: Set CONTROL_FILES Parameter in pfile.ora with only one copy of control file. If more than one exists, delete it.
(CONTROL_FILES='ORACLE_HOME\CONTROL02.CTL')
Step 5: Start the database using pfile (SQL> startup using pfile='ORACLE_HOME\pfile.ora')
Step 6: If you find any below error, execute step 3, 4 and 5 again with another control file location (CONTROL_FILES='ORACLE_HOME\CONTROL01.CTL')

01122, 00000, "database file %s failed verification check"
// *Cause: The information in this file is inconsistent with information
// from the control file. See accompanying message for reason.
// *Action: Make certain that the db files and control files are the correct
// files for this database.

01207, 00000, "file is more recent than control file - old control file"
// *Cause: The control file change sequence number in the data file is
// greater than the number in the control file. This implies that
// the wrong control file is being used. Note that repeatedly causing
// this error can make it stop happening without correcting the real
// problem. Every attempt to open the database will advance the
// control file change sequence number until it is great enough.
// *Action: Use the current control file or do backup control file recovery to
// make the control file current. Be sure to follow all restrictions
// on doing a backup control file recovery.

Step 7: If you find any below error, Recover the database (SQL>recover database)

01113, 00000, "file %s needs media recovery"
// *Cause: An attempt was made to online or open a database with a file that
// is in need of media recovery.
// *Action: First apply media recovery to the file.

Step 8: Open the database (SQL>alter database open)
Step 9: Shutdown the database (SQL>shutdown)
Step 10: Copy the good control file which you used to startup the database onto all other copies, whatever listed in the CONTROL_FILES Paramater in spfile.ora before editing (Step 2).
Step 11: Start the database (SQL>Startup).

No comments: