OraFAQ Forum: Backup & Recovery » control file directory missing

Home » RDBMS Server » Backup & Recovery » control file directory missing (RAC/10g / hp unix)

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

control file directory missing [message #495545]

Sun, 20 February 2011 20:05

mmee
Messages: 38
Registered: July 2007

Member

Hi

In our production server having DB RAC and ASM enviroment in 10g. everyday we have copied from production server to reporting server through BCV technolegy

here we have problem with when mounting from production server to reporting server.

error like this..

ORA-00202: control file: '+DG_xxx/xxxxx/control01.ctl'
ORA-17503: ksfdopn:2 Failed to open file +DG_xxxx/xxxxx/control01.ctl
ORA-15173: entry 'control01.ctl' does not exist in directory 'brmdb'

in prod server controlfile kept in three location
/++++/control01.ctl
/+++1/control02.ctl
/++++2/control03.ctl

Im really Appreciate if any one give clue or help !!!!

Report message to a moderator

Re: control file directory missing [message #495547 is a reply to message #495545]

Sun, 20 February 2011 20:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>in prod server controlfile kept in three location
>/++++/control01.ctl
>/+++1/control02.ctl
>/++++2/control03.ctl

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

using COPY & PASTE post proof these files exist on BVC clone

Report message to a moderator

Re: control file directory missing [message #495554 is a reply to message #495545]

Sun, 20 February 2011 23:28

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Remove this control file from the control_files parameter in your spfile (using alter system in nomount mode) or init.ora file (using vi, notepad...).

Regards
Michel

Report message to a moderator

Previous Topic:	Accidentally delete a data file
Next Topic:	undo datafile lost.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:07:37 CST 2024