Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am trying to figure out how to use RHEL cluster to have automatic failover of an oracle 9 database from one physical machine to another. Ideally this solution would be fully hardware redundant in that there would be no single piece of hardware that could fail that would take down the database.

I'm happy to get answers that simply point to documentation or even descriptions themselves.

Thanks

edit: I wanted to note that I would like to not have to use oracle RAC or a SAN to keep costs down.

share|improve this question
    
Which edition are you using? Standart, Enterprise? –  Benoit Sep 16 '09 at 7:52
    
9.2 Enterprise Edition –  Nathan Feger Sep 16 '09 at 14:00
add comment

2 Answers

I don't know about RHEL cluster or Oracle 9 in particular, but one of my colleagues has just done a Heartbeat/Oracle 10 XE HA installation, and had the good sense to blog about it:

http://www.anchor.com.au/blog/2009/07/oracle-why-dost-thou-sucketh-so-prodigiously/ http://www.anchor.com.au/blog/2009/08/improving-your-quality-of-life-with-oracle/ http://www.anchor.com.au/blog/2009/09/when-ha-wont-play-the-way-you-want-it-to/

Hopefully they'll give you some pointers in the right direction, even if the recipes aren't directly applicable.

share|improve this answer
add comment

Oracle 9i introduced RAC (Real Application Cluster) an option that provides software for clustering and high availability.

You should find all the documentation you may need on metalink, the Oracle web site or the Interweb.


Edit:

If you don't want to use RAC, you could always use Data Guard.

Dataguard allows you to synchronize your primary database with up to nine db, called "standby" database.

If your primary server crashes, you just have to open one of the standby databases.

share|improve this answer
    
Oracle RAC costs way too much money to be an option. I should have specified that in the question. –  Nathan Feger Sep 14 '09 at 22:08
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.