Home » RDBMS Server » Server Administration » controlfile old error
controlfile old error [message #237776] Tue, 15 May 2007 12:52 Go to next message
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.

Re: controlfile old error [message #237779 is a reply to message #237776] Tue, 15 May 2007 12:58 Go to previous messageGo to next message
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.
Re: controlfile old error [message #237801 is a reply to message #237776] Tue, 15 May 2007 13:56 Go to previous messageGo to next message
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
Re: controlfile old error [message #237821 is a reply to message #237801] Tue, 15 May 2007 15:51 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
What you have done, after db was down?
Re: controlfile old error [message #237844 is a reply to message #237801] Tue, 15 May 2007 23:47 Go to previous messageGo to next message
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..?
Re: controlfile old error [message #237891 is a reply to message #237776] Wed, 16 May 2007 01:38 Go to previous message
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?
Previous Topic: ORA-01578
Next Topic: faq
Goto Forum:
  


Current Time: Sat Dec 07 00:42:32 CST 2024