Oracle Rman Replication

[RYAN]

Hi All,

I am new to Oracle and I have some question that I hope that someone out
there can help me.

I have heard the Oracle Rman can do replication of Archives logs. In this
way, one can setup some sort or Oracle Instances replication accross 2
machine at different sites.

1. Does amyone know how is the performance of this method of replication as
compared to replication software such as veritas?
2. Lets say if the transcation is about 256kbps can Oracle replication to be
configured to replicate across 2 2Mbps WAN link so that at any time of
failure, only 15 min of data is loss?
3. If anyone would recommend, which mothod to replication is better? Oracle
or Veritas VVR?

Thanks,
TSH

[Joel Garry]

Re: Oracle Rman Replication

"RYAN" <sh_toh@hotmail .comwrote in message news:<4025e4dd$ 1@news.starhub. net.sg>...

Hi All,
>
I am new to Oracle and I have some question that I hope that someone out
there can help me.
>
I have heard the Oracle Rman can do replication of Archives logs. In this
way, one can setup some sort or Oracle Instances replication accross 2
machine at different sites.
>
1. Does amyone know how is the performance of this method of replication as
compared to replication software such as veritas?

Assuming you mean standby database, as others explained.

2. Lets say if the transcation is about 256kbps can Oracle replication to be
configured to replicate across 2 2Mbps WAN link so that at any time of
failure, only 15 min of data is loss?

You have to, one way or another, copy the original db over there. If
the db is much larger than your link, you have to be real swift about
taping it and jumping on a plane, while continuing manually to ship
the logs until the syncronization is complete. This can be difficult
because Oracle can decide to use multiple archive processes, so you
have to be certain each archive is complete before shipment.

Of course, in normal operations you are periodically shipping archived
logs which are a collection of those transactions. That is burstier
than 256kpbs. The originating db has to wait for that to complete.
If something happens, it can stall the db (perhaps fixed in the newest
version).

3. If anyone would recommend, which mothod to replication is better? Oracle
or Veritas VVR?

Depends on your needs and goals. Don't short the network for either
way.

>
Thanks,
TSH

jg
--
@home.com is bogus.

http://www.kpbs.org/