OraFAQ Forum: Data Guard » Standby database question

Home » Server Options » Data Guard » Standby database question

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

Standby database question [message #150793]

Fri, 09 December 2005 14:43

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

My question is very simple... I had created standby database which was runing fine and after some time i stoped the primary database and then i started standby database & changed that standby database to primary now i want to convert. my original first primary database into standby database .... I just want to know is it possible or not in my case or i have to create standby database from scratch using my current primary database.

I hope experts are able to understand my question....

Thanks & regards
Sunilkumar

Report message to a moderator

Re: Standby database question [message #150986 is a reply to message #150793]

Mon, 12 December 2005 08:33

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Have you done a switch-over or fail-over (the difference is described in the manual)?

I bet you've done a fail-over. After a fail-over you will have to start from scratch and recreate your primary DB as a standby database.

Best regards.

Frank

Report message to a moderator

Re: Standby database question [message #151795 is a reply to message #150986]

Mon, 19 December 2005 04:50

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

thanks frank i got my answer .. actually i did failover ....

Fail over is doen when there is physical disaster to the primary database .. which is unrecoverable. As i was working on test server so for testing purpose i did fail over.

when some one want to change some hardware, or to upgarde some thing at primary database server, than switch over is doen to standby server. And once all maintanence work is over at primary database server again switch over is doen to primary database server.

Thats it...

Thanks & Regards
Sunilkumar

Report message to a moderator

Previous Topic:	What happens to the standby redo log
Next Topic:	automatic transfering of arch logs.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 17:25:26 CDT 2024