OraFAQ Forum: Data Guard » Problem in Switch over

Home » Server Options » Data Guard » Problem in Switch over (Oacle 10g)

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

Problem in Switch over [message #477764]

Mon, 04 October 2010 05:06

rushi123
Messages: 3
Registered: October 2010
Location: India

Junior Member

Hello Experts,

I new to data guard concept .And facing some problem ....................

I am using oracle 10g with data guard configured , I have primary ( A ) and standby database ( B ) .But because of
some unavoidable conditions the primary database ( A ) got shutdown and was not starting , We shifted the standby database ( B )
at new location and changed it to primary with following command ,

startup mount;

alter database recover managed standby database finish;

alter database commit to switchover to physical primary;

shutdown;

startup;

This new primary ( B ) was open for end users for 2 days during which old primary ( A ) was shutdown .

I took the backup of ( B ) and restored it on A AND shutdown the B . Now A is acting as Primary database. Server B
is shutdown .

I want to change server B to standby database with A running as Primary .Is it possible ?

Thanks,
Rushi123

Report message to a moderator

Re: Problem in Switch over [message #477773 is a reply to message #477764]

Mon, 04 October 2010 06:55

babuknb
Messages: 1702
Registered: December 2005
Location: NJ

Senior Member

Instead of database restore why you didn't try switch over from standby to primary ?

Thanks

Report message to a moderator

Re: Problem in Switch over [message #477775 is a reply to message #477773]

Mon, 04 October 2010 07:13

rushi123
Messages: 3
Registered: October 2010
Location: India

Junior Member

That as the mistake we did .........hum.....Is there way to solve this situatuion ?

Report message to a moderator

Re: Problem in Switch over [message #477777 is a reply to message #477775]

Mon, 04 October 2010 07:18

babuknb
Messages: 1702
Registered: December 2005
Location: NJ

Senior Member

Anyway you already restored standby database to primary.

Configure physical standby database configuration on your current primary database and standby database by using http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i63561

Or You can go with RMAN Duplicate standby database.

Thanks, Babu

Report message to a moderator

Re: Problem in Switch over [message #477813 is a reply to message #477777]

Mon, 04 October 2010 09:59

rushi123
Messages: 3
Registered: October 2010
Location: India

Junior Member

Thanks for your prompt reply,
Currentely Server A is runing as Primary Server from last 2 days and Server B is shutdown

during this period .
Please correct me if I am wrong...
1 .Now I shuld tale backup of server A AND restore the same on server B.
2 .Create physical stand by database for primary server A . This standby database will be on
server B .

One more question ..If my application is SAP does this process of creating Standby database changes or Do i have to consider some special point ? Please help..
Thanks,
Rushi123

Report message to a moderator

Re: Problem in Switch over [message #477831 is a reply to message #477813]

Mon, 04 October 2010 12:44

babuknb
Messages: 1702
Registered: December 2005
Location: NJ

Senior Member

>>1 .Now I shuld tale backup of server A AND restore the same on server B.

You said already restore done from B to A, Why again your asking ??

>>Create physical stand by database for primary server A . This standby database will be on
server B

What's your problem ? Already given link to you please check before asking question.

>>f my application is SAP does this process of creating Standby database changes or Do i have to consider some special point ? Please help..

What do you mean by standby database changes ?? Do you mean by special point ?

Thanks, Babu

Report message to a moderator

Previous Topic:	one primary and 2 physical standby databases
Next Topic:	Physical standby with same SID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 01:55:41 CDT 2013

Total time taken to generate the page: 0.07064 seconds