From: Ellen K. 

Well, Mike suggested OpenVMS and you guys screamed when I said I was
looking for an availability / disaster recovery solution for my SQL Server
databases.  So I was just pointing out that you also didn't select
something that didn't support the other pieces of your solution.

The latest for Oracle is that we are using something called DataGuard. I
haven't seen any documentation but it sounds like continuous transactional
replication with the subscriber box automatically knowing if and when it
has to take over.  The part that sucks bigtime is that ORACLE CHARGES FOR
DOUBLE LICENSES IN THIS CASE, i.e. you have to pay for full licensing for
the standby box.  (For the record, Microsoft does NOT charge for licenses
for standby boxes.)

I asked whether you were using the ESB to do your replication because when
I read your previous post a light went on that actually an ESB could be
used to create multiple "master" copies of the data, i.e. since
what it does is send messages, and the number of message receivers is not
limited, you could have two (or more) boxes listening for "message to
Oracle database x".  However, that would only work if ALL
modifications to the data were made via the ESB, which to me seems kinda
convoluted, but I guess it would certainly be possible.

It also occurred to me that I guess we need two instances of Sonic also,
because if a whole location is taken out due to some giant disaster, and
that location is where Sonic is, then duplicate databases are lovely but we
still can't work.  However, how that could be sync'd I have no idea.

On Mon, 13 Jun 2005 10:18:03 +0100, Adam
 wrote in message
:

>Ellen K wrote:
>> My point was that you selected an availability / disaster recovery solution
>> that works with all the other pieces of your solution.
>>
>
>The foundation was Oracle & how best to create identical replicas of the
>data where each can be the master & where there are serious implictions
>wrt the non-availability of the system as a whole.
>
>> Does your comment mean you are using the ESB to do the replication?
>>
>>
>That requires a long answer which will use more than a few acronyms.
>
>
>Adam

--- BBBS/NT v4.01 Flag-5