cancel
Showing results for 
Search instead for 
Did you mean: 

info on Oracle 10g streams

Ratzie
Super Advisor

info on Oracle 10g streams

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.
4 REPLIES
Court Campbell
Honored Contributor

Re: info on Oracle 10g streams

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
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Steven E. Protter
Exalted Contributor

Re: info on Oracle 10g streams

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Yogeeraj_1
Honored Contributor

Re: info on Oracle 10g streams

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Ratzie
Super Advisor

Re: info on Oracle 10g streams

appreciated