Re: Replication

Roger Raymond wrote:
>
> I'm running 2 sparc100 unix servers. I would like to run Oracle 7.3 on one of them
> and use the other for backup in case the server goes down. Both servers are
> attached to individual 40gig storage arrays. What is the best approach to quickly
> recover one box to the other? Should I run duplicate oracles on both boxes and
> trigger DML's to the other? SHould I use replication? Becaus of Suns disk
> configurations on the array, I'm told I cannot share disk.
> Anyone interested in researching with me or have an experience to share?
Roger,

You've got four basic options:

1. A hot standby, where the standby database is a copy of the online database with archived redo applied to the standby to keep it current,
2. A warm standby using Oracle's Parallel Server option, but as your disk array isn't sharable by both machines, this isn't viable, and
3. Replication, either yours or Oracle's, which is limited by your transaction rates, network bandwidth, server loads (both machines), etc.
4. Periodic cold backup of the online system, and a restore to standby system, with the backup frequency dependant upon your service level.

Hope this helps.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.