| Oracle failover options [message #364705] |
Tue, 09 December 2008 13:29  |
revo1059
Messages: 4
Registered: August 2006
|
Junior Member |
|
|
Hi, I'm trying to figure out the most "cost effective (cough,CHEAP,cough)" way to implement a failover database. We are using Oracle 10g Standard Edition One (if 11g offers something 10g doesn't for this I can switch). Here is what I need
The client has a 24 hour retail location, but late at night it's fairly dead. Right now all they are doing is running exports (on a 15GB database it takes a couple of hours). Not the best method, but it has saved us in the past (except a full import takes FOREVER). What I want to do is have a 2nd machine that can be quickly used if the main machine goes down. I don't need the 2nd machine to sync back with the main machine, so it's a 1 way sync. Is there a cheap way to do this on Standard Edition One? It also needs to be fairly automatic as far as the syncing goes. If they need to switch because of a failure, we could handle that. Even if it's a daily sync so the most they would potentially lose is 24 hours of data, I could live with that.
Any help would be appreciated.
P.S. Oracle is running on Suse Enterprise 10 and the location has a WinXP system with oracle server installed as well. If this can be done cross platfrom, great, if not then the client will get a spare Linux box.
[Updated on: Tue, 09 December 2008 13:33] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: Oracle failover options [message #394581 is a reply to message #364955] |
Fri, 27 March 2009 19:57  |
mlaunce
Messages: 3
Registered: March 2009
|
Junior Member |
|
|
Take a look at Dbvisit (www.dbvisit.com). This is an alternative to Data Guard but works for Oracle Standard Edition, Standard One and XE. Works with all versions of Oracle from 8i onwards.
Has all the features of Data Guard including Graceful Switchover, failover, multiple standby databases, reporting standby databases and supports Oracle RAC, but is much simpler to use.
Compresses the archive log files before transfer so saving on bandwidth. Has build-in alerting and monitoring.
There is a free 30 day trial. New version 5.2 will even automatically create the standby database.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
