OraFAQ Forum: Backup & Recovery » ORA-00214 / inconsistent with file

Home » RDBMS Server » Backup & Recovery » ORA-00214 / inconsistent with file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00214 / inconsistent with file [message #224385]

Wed, 14 March 2007 02:34

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?

Report message to a moderator

Re: ORA-00214 / inconsistent with file [message #224397 is a reply to message #224385]

Wed, 14 March 2007 02:57

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

Report message to a moderator

Re: ORA-00214 / inconsistent with file [message #224516 is a reply to message #224385]

Wed, 14 March 2007 08:58

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 05:00:11 CDT 2024