Home » RDBMS Server » Backup & Recovery » Need options for standby DB (10g SE, 10.2.0.4, RHEL 4 x64)
Need options for standby DB [message #569466] Fri, 26 October 2012 13:02 Go to next message
taylorjp84
Messages: 3
Registered: October 2012
Location: California
Junior Member
Hello,

I am looking for reliable but cost effective options for replication to a standby database. We are running 10g SE on RHEL 4 and working on a DR plan that involves a standby DB at an offsite location. There is a VPN between the two sites and our goal is to have close to real-time replication. I have looked at DataGuard, GoldenGate, and SharePlex, all look like solid options but way too expensive, the SE licenses alone are already taxing our budget. I'm considering setting up the standby DB manually, but it looks to be a pretty involved process; I only recently inherited DBA duties and am by no means and expert. Does anyone have any other suggestions/options?

Thanks much,
Re: Need options for standby DB [message #569467 is a reply to message #569466] Fri, 26 October 2012 13:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/mv/msg/139482/490232/102589/#msg_490232

Regards
Michel
Re: Need options for standby DB [message #569468 is a reply to message #569466] Fri, 26 October 2012 14:35 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
The manual standby is a good solution, and not actually that complex to setup. Google around, and you will find examples of scripts to automate the process. If you have trouble, I have some scripts somewhere that I can dig out. You can limit the maximum data loss to single digit minutes.
If licence costs really are a problem, an alternative is to use RMAN incrementally updated backups. You can achieve a similarly low worst case data loss, without needing to licence a second machine at all.

ps - welcome to the forum.
Re: Need options for standby DB [message #569470 is a reply to message #569468] Fri, 26 October 2012 17:30 Go to previous messageGo to next message
taylorjp84
Messages: 3
Registered: October 2012
Location: California
Junior Member
Thanks Michel, I think I will be watching several of those videos!
Re: Need options for standby DB [message #569471 is a reply to message #569470] Fri, 26 October 2012 17:31 Go to previous messageGo to next message
taylorjp84
Messages: 3
Registered: October 2012
Location: California
Junior Member
Thanks John, we're doing a daily RMAN backup now, our recovery time with that plan is about 8 hours though, being asked to get that much closer to real-time. It's looking more and more like manual standby is the way we'll go. I think I have it mostly worked out, it's just not really my area of expertise, yeah any scripts you are willing to share would be much appreciated. Thanks again.
Re: Need options for standby DB [message #569479 is a reply to message #569471] Sat, 27 October 2012 00:47 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In Part 6 Stéphane explains the principles and show how to set up a handmade standby database (including scripts for Linux, fot a 10 minutes lag).

Regards
Michel

[Updated on: Sat, 27 October 2012 00:49]

Report message to a moderator

Previous Topic: incremental rman backups (merged)
Next Topic: recovery from RAC to standalone
Goto Forum:
  


Current Time: Thu Mar 28 07:57:17 CDT 2024