SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2262048 bytes
Variable Size 624954336 bytes
Database Buffers 436207616 bytes
Redo Buffers 5513216 bytes
ORA-00214: control file '+DGDUP/control01.ctl' version 1960 inconsistent with file '+DGDUP/control02.ctl' version 1956
Error: ORA 214
Text: control file version inconsistent with file version
-------------------------------------------------------------------------------
Cause: An inconsistent set of control files, datafiles/logfiles, and redo files was used.
Action: Use a consistant set of control files, datafiles/logfiles, and redo log files.
That is, all the files must be for the same database and from the same time period.
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2262048 bytes
Variable Size 624954336 bytes
Database Buffers 436207616 bytes
Redo Buffers 5513216 bytes
ORA-00214: control file '+DGDUP/control01.ctl' version 1960 inconsistent with file '+DGDUP/control02.ctl' version 1956
Error: ORA 214
Text: control file
-------------------------------------------------------------------------------
Cause: An inconsistent set of control files, datafiles/logfiles, and redo files was used.
Action: Use a consistant set of control files, datafiles/logfiles, and redo log files.
That is, all the files must be for the same database and from the same time period.
- fact: Oracle Server - Enterprise Edition
- symptom: Startup mount fails
- symptom: ORA-00214: control file
version inconsistent with file - symptom: Following error(s) appear while database is running
- symptom: ORA-01171: datafile %s going offline due to error advancing checkpoint
- symptom: ora-01115: IO error reading block from file %s (block # %s)
- symptom: ORA-01110 datafile %s: %d
- cause: An ORA-00214 is issued whenever Oracle detects an inconsistency between two 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 "init.ora& quot; file for this instance (or config.ora in an ifile configuration). 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).
No comments:
Post a Comment