info on Oracle 10g streams

[Ratzie]

We will be incorporating:
replication between two databases.
Both will be masters.

We will be putting this on Oracle 10g.
What I am looking for is some how to, or decent docs regarding this.
The two databases should be identical, in diff. cities.

[Court Campbell]

My first thought would be to look at the documentation on oracle's website. But this seems promising:

http://www.oracle-base.com/articles/9i/Streams9i.php

[Steven E. Protter]

Shalom,

This decision is generally made based on bandwidth considerations. That and licensing costs.

Oracle dataguard can handle copying the data from one site to another.

Its also possible to simply copy the archive logs and apply them to the secondary database.

However, you use the term both systems are masters. That implies they will both be hot and running. That means Oracle RAC is your product of choice and that requires common shared storage.

SEP

[Yogeeraj_1]

hi,

Indeed, it is recommended going forward that Streams be used to do replication.

For documentations, see:
"Oracle® Streams Concepts and Administration 10g Release 2 (10.2)"
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14229.pdf


Kind regards
yogeeraj

[Ratzie]

appreciated