OraFAQ Forum: Server Administration » controlfile old error

Home » RDBMS Server » Server Administration » controlfile old error

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

controlfile old error [message #237776]

Tue, 15 May 2007 12:52

vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY

Senior Member

Hello sir

Suddenly we have one problem,ur database went up down immediately,we have strat the database ,but it shows this following error

ORA-01207: file is more recent than controlfile - old controlfile
ORA-01122: database file 4 failed verification check

After that i gave

>alter database datafile 4 offline;

it shows

ORA-01145: offline immediate disallowed unless media recovery enabled.

oracle version 8.1.7

plz help me what can i do

Thanx.

Report message to a moderator

Re: controlfile old error [message #237779 is a reply to message #237776]

Tue, 15 May 2007 12:58

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

01207, 00000, "file is more recent than controlfile - old controlfile"
// *Cause: The controlfile change sequence number in the data file is
// greater than the number in the controlfile. This implies that
// the wrong controlfile 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
// controlfile change sequence number until it is great enough.
// *Action: Use the current controlfile or do backup controlfile recovery to
// make the controlfile current. Be sure to follow all restrictions
// on doing a backup controlfile recovery.

Report message to a moderator

Re: controlfile old error [message #237801 is a reply to message #237776]

Tue, 15 May 2007 13:56

vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY

Senior Member

hello sir
i have used this following command to trace out the controlfile

alter database backup controlfile to trace;

i have got trace file in udump after that what can i do,it also shows some error in trace file

it shows
version name
sid name
oracle process number :0
956
session id
ora-01089 immediate shutdown in progress - no operations are permitted.

- plz help me

Report message to a moderator

Re: controlfile old error [message #237821 is a reply to message #237801]

Tue, 15 May 2007 15:51

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

What you have done, after db was down?

Report message to a moderator

Re: controlfile old error [message #237844 is a reply to message #237801]

Tue, 15 May 2007 23:47

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

hi,
can you upload your trace file (which you have created using that command) over here..?

Report message to a moderator

Re: controlfile old error [message #237891 is a reply to message #237776]

Wed, 16 May 2007 01:38

kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA

Junior Member

Hi,
Control file pointed in control_files parameter given in init file are correct?

Report message to a moderator

Previous Topic:	ORA-01578
Next Topic:	faq

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 12:32:39 CST 2024