Home » Server Options » Data Guard » Poor man's dataguard role: reversal primary becomes standby and vice versa (Oracle Database Standard Edition, 10.2.0.4, windows 2003)
Poor man's dataguard role: reversal primary becomes standby and vice versa [message #525726] Tue, 04 October 2011 20:36 Go to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
Is it possible to quickly sync a former primary database with the new Standby after failover?
If possible without dataguard or third party (like dbvisit,tvdstandby,shareplex)?.

Scenario:
MyOld site x running
MyStandby remote site y running
Continuous applying logs to MyStandby.
MyOld takes a long nap.
Failover to MyStandby (yey promotion), processing new entries.
(open database reset logs)

Goal: Reuse MyOld as standby when it wakes up without transferring terabytes across the network.

New situation:
MyStandby: primary
MyOld: standby

Report message to a moderator

Re: Poor man's dataguard role: reversal primary becomes standby and vice versa [message #525747 is a reply to message #525726] Wed, 05 October 2011 02:10 Go to previous messageGo to next message
John Watson
Messages: 8804
Registered: January 2010
Location: Global Village
Senior Member
You can this if you have enabled database flashback. But as flashback requires Enterprise Edition licences, which I don't think you have or you would be using Data Guard, there is no way.

Report message to a moderator

Re: Poor man's dataguard role: reversal primary becomes standby and vice versa [message #526866 is a reply to message #525747] Thu, 13 October 2011 07:03 Go to previous message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
Thanks for your answer.

Report message to a moderator

Previous Topic: Dataguard Query
Next Topic: Stand By Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Mar 26 16:50:22 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.