Re: Oracle database replication

Mukesh:

Two school of thoughts on this. Replication from Oracle can be implemented either
Synchronous or Asynchronous. Sychronous should be attempted if and only if you
know your network will never go down. If for any reason, the synchronous Master site
goes down, it will take down/hang the dependant nodes with it. Use asynchronous replication.

Asynchronous Multi-Master Replication is easy on the DBA. Oracle is supposed to manage the synchronization
including database object changes. This is very helpful when you make a change, gets propagated everywhere.

You wont have to worry about script FTPing the archived redo logs in the case of a hot standby server.
In the case of a hot standby server, the two/more boxes have to be exact replicas, same OS, RAM, hard-drive
access etc. The replicated boxers are always then in a state of continuos recovery.

I haven't quite done it, but shall be doing a project with replication in few months. I plan on trying out
both possibilities. For some funny reason, when we called Oracle they suggested the hot backup server option vs replication.

Have fun,

Raman Batra, Oracle DBA

m_patel99_at_hotmail.com wrote:
>
> Is it possible to mirror a "central" oracle database running on one
> machine to other "backup" machine(s) ? All amendments will only be made
> on the central database and all these changes need to be mirrored to all
> backups. The the backups will only be queried and no amendments will be
> made to them.
>
> Thankyou in advance for all the responses.
>
> Thanks,
>
> Mukesh
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Wed Jan 14 1998 - 00:00:00 CST