Home » RDBMS Server » Server Administration » controlfile error
controlfile error [message #262944] Tue, 28 August 2007 10:10 Go to next message
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


Re: controlfile error [message #262945 is a reply to message #262944] Tue, 28 August 2007 10:16 Go to previous messageGo to next message
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
Re: controlfile error [message #262955 is a reply to message #262945] Tue, 28 August 2007 10:43 Go to previous messageGo to next message
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

Re: controlfile error [message #262959 is a reply to message #262955] Tue, 28 August 2007 10:50 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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'
Re: controlfile error [message #263243 is a reply to message #262944] Wed, 29 August 2007 08:42 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member


Thank you arju and dreamz now it works.
Previous Topic: Number of connections
Next Topic: pfile and spfile
Goto Forum:
  


Current Time: Thu Dec 05 01:35:39 CST 2024