Home » Server Options » Data Guard » How to convert the primary control file for standby ? (oracle 11g, suse linux 10, )
How to convert the primary control file for standby ? [message #436923] Tue, 29 December 2009 10:15 Go to next message
dingfuhai
Messages: 1
Registered: December 2009
Junior Member

hi expert:
I try to recover standby db from a primary db backup set,but the standby control file is different.

to create primary controlfile by rman:
backup control file format '/home/cur_control';

to create standby controlfile:
backup control file for standby format '/home/std_control';

I want to know if there is method to convert cur_control to std_control.

Report message to a moderator

Re: How to convert the primary control file for standby ? [message #436927 is a reply to message #436923] Tue, 29 December 2009 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter database create standby controlfile as '...';

Regards
Michel

Report message to a moderator

Re: How to convert the primary control file for standby ? [message #551398 is a reply to message #436923] Tue, 17 April 2012 23:53 Go to previous messageGo to next message
gazge_mitab
Messages: 2
Registered: April 2012
Location: pune
Junior Member
hey thanks Michel Cadot for your reply
but now i am facing another error
ORA- 01665: controlfile is not a standby controlfile

so how to solve this error when i am trying switchover or i am trying to start MRP its giving me this error, your help will be appriciated,
thanks

Report message to a moderator

Re: How to convert the primary control file for standby ? [message #551412 is a reply to message #551398] Wed, 18 April 2012 01:05 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but now i am facing another error
ORA- 01665: controlfile is not a standby controlfile


When? What did you do? ...
Copy and paste ALL what you did and got.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Previous Topic: Dataguard Fail back
Next Topic: setting up Dataguard
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 22:08:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.