Re: Replication in N Master-Site

Oracle8i Advanced Replication

Another solution for disaster planning is Oracle8i Advanced Replication. Oracle8i Advanced Replication allows an application to update any replicas of a database, and have those changes automatically propagate to other databases, while ensuring global transactional consistency and data integrity. In the event of a disaster at one of the sites, the surviving databases remain online.

"The Views expressed here are my own and not necessarily those of Oracle Corporation"
Allen <allen500_at_ms15.hinet.net> wrote in message news:8242n9$ikg_at_netnews.hinet.net...
> Hi, All:
>
> My customer had 2 DB with the same Schema in different machine (SID=A,
B)
> All they want to do is to duplicate some data (where condition was
> defined) from A To B, and they can do any I/O in
> both DB, and partial data will automatic replicate to each other.
>
> As I know, Oracle Snapshot can solve my problem, but B site must to be
> "View", but I can not drop their old schema
> to recreate snapshot view for many reasons.
>
> I had builded the replcation definition and master-site already, and I
> tried to modify the trigger (Table$RR), but I
> can not make sure is there any bug or problem will be occurs, also I do
not
> know how Oracle Replication will
> start to execute these Triggers.
>
> So, Can anyone give me some kind of suggestions to build 2 master-site
for
> partial replication without
> using master-site -> snapshot-site? and Does Oracle or other 3rd Party
> develops other useful tools ?
>
> I am working on an Oracle 8.0.5.1 database running on SUN Spark
>
> Any information you can provide will be greatly appreciated.
> Thanks a lots
>
> Best Regard,
> Allen
>
>
Received on Wed Dec 01 1999 - 23:44:34 CST