Home » RDBMS Server » Backup & Recovery » control file directory missing (RAC/10g / hp unix)
control file directory missing [message #495545] Sun, 20 February 2011 20:05 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 20247
Registered: January 2009
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 Go to previous message
Michel Cadot
Messages: 54719
Registered: March 2007
Location: Nanterre, France, http://...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 20 06:53:29 CDT 2013

Total time taken to generate the page: 0.20498 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.