Home » RDBMS Server » Backup & Recovery » ORA-00214 / inconsistent with file
ORA-00214 / inconsistent with file [message #224385] Wed, 14 March 2007 02:34 Go to next message
ddaannyy
Messages: 13
Registered: March 2007
Junior Member
Hi,

we have a oracle 9.2.0.6. database. Yesterday evening the server chrashed due no energy. Now we try to restart our database and get this error

ORA-00214: controlfile 'xxx/control02DII_001.ctl' version 29898
inconsistent with file 'xxx/control02DII_001.ctl' version 29897

I understand, he want an special control-file, but i can not understand the version. I have no other control-files. Have anybody a good idea?




Re: ORA-00214 / inconsistent with file [message #224397 is a reply to message #224385] Wed, 14 March 2007 02:57 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
If you have no backup of your control file then you should create new control file with current database structure.

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 7271
LOGFILE
GROUP 1 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG' SIZE 10M,
GROUP 2 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02.LOG' SIZE 10M,
GROUP 3 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO03.LOG' SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF',
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DBF',
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF',
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF',
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE01.DBF',
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS02.DBF'
CHARACTER SET WE8MSWIN1252
;




regards
Taj
Re: ORA-00214 / inconsistent with file [message #224516 is a reply to message #224385] Wed, 14 March 2007 08:58 Go to previous message
salaku
Messages: 9
Registered: March 2007
Junior Member
Hi

You could update the control_files parameter in init.ora file with the first copy of the control file and delete all other entries and try performing

startup restrict

If the database comes up then it shutdown normal and copy that file to all mirrored copies (take copies of all controlfiles before you try this ) and restore the control_files parameter in the init.ota file and restart

if not try modifying the control_files parameter to the next mirrored copy and retry the steps above .

thanks
Previous Topic: Timestamp of rman backup
Next Topic: How to delete RMAN backup and set configuration parameter in oracle 8.1.7.4
Goto Forum:
  


Current Time: Sun Dec 04 06:38:34 CST 2016

Total time taken to generate the page: 0.06599 seconds