Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

complete oracle replication example?

SOLVED
Go to solution
abc_18
Regular Advisor

complete oracle replication example?

Is there a complete oracle replication example
out there somewhere? I'm just looking for a tiny example, but one that shows *all* the steps. And hopefully one that's been debugged (ie, no typos, etc).

Ideally, I'd like to find an example of each
flavor of replication, ie:
a) streams replication, and
b) "advanced" replication

This is for a Oracle 10gR2 configuration, on
HP-UX 11.11

Thanks in advance!
4 REPLIES
Yogeeraj_1
Honored Contributor
Solution

Re: complete oracle replication example?

hi abc,

unfortunately, i can only direct you to the Oracle documentations.

see:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/repoverview.htm#sthref13

http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/repoverview.htm#REPLN001

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14227/raroverview.htm#sthref12


hope this helps!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: complete oracle replication example?

hi again,

for streams replication, see:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14228/gen_rep.htm#BABFIDJE


hope this helps too!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric Antunes
Honored Contributor

Re: complete oracle replication example?

Hi abc,

Here are some docs from Metalink:

Note 298877.1 (10g Streams Recommended Configuration), which also points you to other notes;

Note 150904.1 (Oracle9i Replication New Feature, Master Replication of User-Defined Types);

Note 250413.1 (Replication Setup; Backup and Recovery; Adding New Node to DRG);

...

Doing an Advanced search in metalink with the the following 2 words: "replication" and "example", you will get much more.

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: complete oracle replication example?

Some more:

Note 138181.1 (Designing for Survivability - Advanced Replication : A Practical Example);

Note 150905.1 (Oracle9i Materialized View New Feature, Replication of User-Defined Types);

Note 313478.1 (Performing Manual DDL in a Streams Environment);

...

Best Regards,

Eric Antunes


Each and every day is a good day to learn.