Tom Kyte Availability Option Questions / OPS newbie

From: Doug C <dcowles_at_i84.net>
Date: Mon, 19 Feb 2001 21:27:52 -0500
Message-ID: <fgl39tcl713ngoqoo41p51mf4cjuhi7c4g@4ax.com>

I was looking at an article by Thomas Kyte about the various availability options for Oracle, which is at :
http://www.oracle.com/oramag/oracle/00-May/o30tom.html but i will sumarize the options.
There are 5

1) OPS
2) Replication
3) Standby Database
4) OS- Oriented solutions - such as dual ported RAID devices.
5) Architecture

My question revolves exclusively around this comment he makes:

"In terms of OPS compared with replication:

If failover and availability are the key issues, using OPS wins out in my opinion. If redundancy is the main issue, then using replication is the answer (because using OPS is not a redundant solutionâ€”you have only one database)."

Since we have only one database, and that box could crash, how does this come in the lead for availability? I can see how one appserver fails over to another, but if there is something wrong with you db server, seems like availability is down the drain.

Comments, insights?
I would pose this to Tom directly, but he is pretty swamped.

Received on Mon Feb 19 2001 - 20:27:52 CST