Control file Error Codes

Every Oracle Database has a control file, which is a small binary file that records the physical structure of the database.  The control file must be available for writing by the Oracle Database server whenever the database is open. Without the control file, the database cannot be mounted and recovery is difficult.

ORA-00200 controlfile could not be created
ORA-00201 controlfile version string incompatible with ORACLE version string
ORA-00202 controlfile: ‘string’
ORA-00203 using the wrong controlfiles
ORA-00204 error in reading (block string, # blocks string) of controlfile
ORA-00205 error in identifying controlfile, check alert log for more info
ORA-00206 error in writing (block string, # blocks string) of controlfile
ORA-00207 controlfiles are not for the same database
ORA-00208 number of controlfile names exceeds limit of string
ORA-00210 cannot open the specified controlfile
ORA-00211 controlfile does not match previous controlfiles
ORA-00213 cannot reuse controlfile; old file size string, string required
ORA-00214 controlfile ‘string’ version string inconsistent with file ‘string’ version string
ORA-00215 must be at least one controlfile
ORA-00216 controlfile could not be resized for migration from 8.0.2
ORA-00217 controlfile could not be resized for migration from 9.0.1
ORA-00218 block size string of controlfile does not match DB_BLOCK_SIZE (string)
ORA-00219 required controlfile size string exceeds maximum allowable size string
ORA-00220 controlfile not mounted by first instance, check alert log for more info
ORA-00221 error on write to controlfile
ORA-00222 operation would reuse name of a currently mounted controlfile
ORA-00224 controlfile resize attempted with illegal record type (string)
ORA-00225 expected size string of controlfile differs from actual size string
ORA-00226 operation disallowed while alternate controlfile open
ORA-00227 corrupt block detected in controlfile: (block string, # blocks string)
ORA-00228 length of alternate controlfile name exceeds maximum of string
ORA-00229 operation disallowed: already hold snapshot controlfile enqueue
ORA-00230 operation disallowed: snapshot controlfile enqueue unavailable
ORA-00231 snapshot controlfile has not been named
ORA-00232 snapshot controlfile is nonexistent, corrupt, or unreadable
ORA-00233 copy controlfile is corrupt or unreadable
ORA-00234 error in identifying or opening snapshot or copy controlfile
ORA-00235 controlfile fixed table inconsistent due to concurrent update
ORA-00236 snapshot operation disallowed: mounted controlfile is a backup
ORA-00237 snapshot operation disallowed: controlfile newly created
ORA-00293 controlfile out of sync with redo log
ORA-00338 log string of thread string is more recent than controlfile
ORA-01103 database name ‘string’ in controlfile is not ‘string’
ORA-01104 number of controlfiles (string) does not equal string
ORA-01178 file string created before last CREATE CONTROLFILE, cannot recreate
ORA-01190 controlfile or data file string is from before the last RESETLOGS
ORA-01207 file is more recent than controlfile – old controlfile
ORA-01215 enabled thread string is missing after CREATE CONTROLFILE
ORA-01216 thread string is expected to be disabled after CREATE CONTROLFILE
ORA-01233 file string is read only – cannot recover using backup controlfile
ORA-01244 unnamed datafile(s) added to controlfile by media recovery
ORA-01503 CREATE CONTROLFILE failed
ORA-01582 unable to open controlfile for backup
ORA-01583 unable to get block size of controlfile to be backed up
ORA-01584 unable to get file size of controlfile to be backed up
ORA-01587 error during controlfile backup file copy
ORA-01610 recovery using the BACKUP CONTROLFILE option must be done
ORA-01649 operation not allowed with a backup controlfile
ORA-01665 controlfile is not a standby controlfile
ORA-01666 controlfile is for a standby database
ORA-01669 standby database controlfile not consistent
ORA-01671 controlfile is a backup, cannot make a standby controlfile
ORA-01672 controlfile may be missing files or have extra ones
ORA-01696 controlfile is not a clone controlfile
ORA-01697 controlfile is for a clone database
ORA-01967 invalid option for CREATE CONTROLFILE
ORA-01970 You must specify a database name for CREATE CONTROLFILE
ORA-12710 CREATE CONTROLFILE character set is not known
ORA-12711 this CREATE CONTROLFILE character set is not allowed
ORA-19571 string recid string stamp string not found in controlfile
ORA-19589 string is not a snapshot or backup controlfile
ORA-19594 controlfile already included as string
ORA-19606 Cannot copy or restore to snapshot controlfile
ORA-19607 string is an active controlfile
ORA-19627 cannot read backup pieces during controlfile application
ORA-19632 file name not found in controlfile
ORA-19633 controlfile record string is out of sync with recovery catalog
ORA-19654 must use backup controlfile to switch file incarnations
ORA-19666 cannot do incremental restore of the controlfile
RMAN-05572: Controlfile backup not found for database string with DBID number created before string in string
RMAN-05573: CONTROLFILE backup not found for database with DBID number created before string in string
RMAN-05574: CONTROLFILE backup not found for database string created before string in string
RMAN-05575: CONTROLFILE backup created before string not found in string
RMAN-05576: CONTROLFILE backup not found for database string with DBID number in string
RMAN-05577: CONTROLFILE backup not found for database with DBID number in string
RMAN-05578: CONTROLFILE backup not found for database string in string
RMAN-05579: CONTROLFILE backup not found in string
RMAN-05590: Reenabling controlfile options for auxiliary database
NID-00132: CHECKPOINT_CHANGE# in datafile “string”: string in the future of controlfile: string
NID-00143: Mismatched controlfile string