Re: Oracle 8 replication

I have setup Oracle multimaster replication a few times before, and I have read many different Oracle replication whitepapers/notes etc on support.oracle.com, as well as provided by third party. So in terms of resources it is quite a lot.

In the pre-Replication Manager era, setting up the MM replication is extremely complicated, as the scripts to run and setup is rather long. But using RepMgr 1.4 and after, it has been extremely simplified. I was able to setup MM replication between 2 different site within half an hour. The steps I have documented are in

http://web.singnet.com.sg/~petermag/oracle.html ---> "Replication Setups Procedures", which is a word file.

If u search for the word "Replication" within this web page, u can also find many different rep-related whitepapers etc.

Tapan Trivedi wrote:
>
> Sandra,
> Hi. We have multimaster replication at our site here. Help me
> understand when you say 'real time combined with replication about twice
> a day' what exactly do you mean by the same ? What OS is this on ? Are
> you open to use of tools ? Go on the Oracle Corp home page and look up
> the advanced replication options.
>
> Also orafans.com has a good replication conference.
> The thing is that replication (especially mulitmaster replication)
> resources are kinda scarce on the web or any place else for that matter.
> Even when you call Oracle Support you do not get people who really know
> a lot about the same . So ususally you get someone only after your tar
> is escalated couple of times.
>
> Also the repsig list might help. It does require 70 $ registration
>
> http://www.oracle.com/database/replication/repsig.html
>
> Hope this helps and keep in touch regarding the same.
>
> Tapan
>
> Sandra Timmermans wrote:
> >
> > For the project I am currently working on we are going to replicate
> > databases.
> >
> > This will be a 2 master situation with real time
> > replication combined with replication about twice a day.
> > Does anyone have experience with replication in Oracle 8. I am interested in
> > their experience and would like to know which problems they encountered.

--

      \\\|///          Peter Teoh
    \\  - -  //        Oracle Certified Professional
     (  @ @  )
__oOOo-(_)-oOOo____________________________________
|                                           _____  |
|                                          (~._.~) |
|Email:petermag_at_singnet.com.sg             _{ Y }_ |
|Phone:97813086(HP)                       ()_~~~_()|
|Pager:96047971                            (_)-(_) |
|http://web.singnet.com.sg/~petermag/              |
|__________________________________________________|