Re: Is Oracle 24*365 possible?

The answer is equally trivial - yes. Especially since you are quoting the 'guaranteeing'.

The best method and cost depends basically on the problems you think you need to guard against, and the rate of data and nature of data input.

Given that a catastrophe can always happen, you also need to determine the maximum down-time you are going to allow for unexpected catastrophes (as opposed to planned catastrophes)

In the case of a 'world-wide airline' you are presumably going to have a very rapid rate of data entry, with perhaps 5 to 10 times as many queries as entries (looking up flight options etc.) so you have to get quite expensive on volume of hardware to combine response time with resilience.

It is unlikely that any form of replication will be a safe bet - partly because the data change rate may make it insecure to depend on asynchronous replication. And synchronous replication simply introduces a new point of failure and overhead).

24 x 7 x 365 could be approached using parallel server technology - but the partitioning will have to be a little cunning to avoid excessive pinging due to conflicting write requests.

An alternative approach is the 'bloody big server' with a high level of mirroring at the end of a fibre link, combined with a fast fail-over to cater for machine failure.

Problems to consider are -

    How to eliminate the need for data re-organisation     How to cope with dumping old data without impacting performance     Backup and (it'll never happen) recovery

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Johan Wegener wrote in message <7s7ru9$raj$1_at_news101.telia.com>...
>To state this question is trivial; the answer is surely less so:
>
>Is it possible to have an Oracle instance and its data online around the
>clock, 365 days a year while "guaranteeing" against loss of data?
>
>I am interested in knowing what such a setup could look like. There are no
>restrictions whatsoever, technically or financially. Has anybody on planet
>Earth achieved this? The scope of the configuation is in the "world-wide
>airline" range.
>
>As I am basically not a DBA, I would highly appreciate if somebody could
>point me in the right direction. I've heard that it should be possible
using
>a kind of "three-way replication". Does anybody know any details?
>
>Thanks,
>Johan
>
>
Received on Tue Sep 21 1999 - 09:04:11 CDT