OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » controlfile error

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

controlfile error [message #262944]

Tue, 28 August 2007 10:10

vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY

Senior Member

Hello sir

Suddenly we got controlfile error,So i have start the database in nomount status then i have tried mount status it shows error like check the alert message controlfile not open error

I have checked the alert file it shows

ORA-00202 : controlfile : ' path'
ORA-27041: unable to open file
ORA-205 signalled during : alter database mount ..message

I have checked the controlfiles in oracle_home/oradata/name/
>show parameter control_file
it shows 2 path
then i have checked that control_file path
> controlfiles not available(controlfiles missing)

we have updated controlfile trace files(both textform and binary form)

plz help me how to recover the controlfiles by using trace files.

- Thanx in advance

Report message to a moderator

Re: controlfile error [message #262945 is a reply to message #262944]

Tue, 28 August 2007 10:16

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

ORA-27041: unable to open file

You have binary control file backup or text file ???

if binary file then edit control_file parameter in init.ora file and point binary ctl file backup

otherwise if you have text file backup then create new control file from text file backup.

Regards
Taj

Report message to a moderator

Re: controlfile error [message #262955 is a reply to message #262945]

Tue, 28 August 2007 10:43

vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY

Senior Member

We have both files text file and binary file backups i need help to recover from binary file

what is the way to recover from binary file

eg: binary file in /mnt/ora_backup/ctl.bkp path

actual controlfile path 1 path in /oradata/test/....
2 path in /oradata1/test/...

pfile in home/dba/pfile(parameter)

control_file= path1,path2

plz give me the command to recover the controlfile from binary trace file.

-Thanx

Report message to a moderator

Re: controlfile error [message #262959 is a reply to message #262955]

Tue, 28 August 2007 10:50

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Restoring the Control File

This example restores the control file to its default location, 
replicates it to all CONTROL_FILES locations, 
and mounts the database:

startup nomount;
run { 
     restore controlfile; 
     alter database mount; 
}

http://www.csee.umbc.edu/help/oracle8/server.815/a67773/rmansy35.htm

[Updated on: Wed, 29 August 2007 00:45] by Moderator

Report message to a moderator

Re: controlfile error [message #263040 is a reply to message #262944]

Tue, 28 August 2007 22:10

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Mohammad Taj already pointed your solution whether you have binary or text of backup. If you don't want to follow anyone of them, then use,

SQL>rman target /
rman>startup nomount;

Restore controlfile to '/oradata/test/' from '/mnt/ora_backup/ctl.bkp'

Restore controlfile to '/oradata1/test/' from '/mnt/ora_backup/ctl.bkp'

Report message to a moderator

Re: controlfile error [message #263243 is a reply to message #262944]

Wed, 29 August 2007 08:42

vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY

Senior Member

Thank you arju and dreamz now it works.

Report message to a moderator

Previous Topic:	Number of connections
Next Topic:	pfile and spfile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 10:44:04 CDT 2024