topic Re: control file problem in Operating System - HP-UX

control file problem

Pankaj K. Bharne — Wed, 26 May 2010 07:07:19 GMT

hi !
i try to restore my offline backup data from my tape device to my system.
-sap ecc 5.0 , hp ux os is in use
now by using Brtools utility i started recovey option but due to changes in my hardware(2 hard disk are replaced due to damage and mount with new filesystem) there is error in control file
ie
-- incositancy in control files showing timestamp
so then i update parameter in pfile ie control files to single file so that oracle server can read single control file and removes insonsitancy but now there is another error mesage ie

--error in identifying control file ora 00205
some part of alertlog is attach
plz go through it and help me to solve the error ragading the control file and procedure of backup of db

any infor requires then provide ..

thanks you...!

Re: control file problem

Jean-Luc Oudart — Wed, 26 May 2010 10:11:50 GMT

Hi

when you say yo restored your offline backup data , were the control file(s) included ?

the error in your alert log suggest the control file is not in the indicated location.
D/oracle/GMD/origlogA/cntrl/cntrlGMD.dbf' => is this the control filename ?

earlier in the alert log 3 control files were indicated. If a control file is damaged it can be replaced with a good one (but the database must be shut down).

Regards
Jean-Luc

Re: control file problem

Schneider H.-P. — Thu, 27 May 2010 03:57:07 GMT

Hello,

are there special (wrong) characters in the controlfile name?

Tue May 25 22:16:14 2010
ORA-00202: controlfile: 'oracle [D [D [D [D [D [D/oracle/GMD/origlogA/cntrl/cntrlGMD.dbf'
ORA-27037: unable to obtain file status

greetings H.-P.

Re: control file problem

Jean-Luc Oudart — Thu, 27 May 2010 09:40:27 GMT

If the control file information was changed to something oracle does not understand (cf. the non readable characters), you must change it
.

This can be done with :
- shutdown the intance
- startup nomount => the control file is not opened yet.
- alter system set control_files =
'//controlctl1.ctl',
'//controlctl2.ctl'
scope=spfile;

(I used 2 control files but you should probably put 3 as you had originally)
then shutdown/startup

you can check the controlfiles location with :
select name, value from v$spparameter
where name = 'control_files';

Regards
Jean-Luc