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 !!!!
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: 22539
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
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: 58625
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
Previous Topic: Accidentally delete a data file
Next Topic: undo datafile lost.
Goto Forum:
  


Current Time: Wed Jul 30 20:27:26 CDT 2014

Total time taken to generate the page: 0.11793 seconds