Re: Multi-Master database replication

From: Bostjan Stupica <bostjan.stupica_at_ixtlan.si>
Date: 1998/01/31
Message-ID: <01bd2e7f$1609fec0$33ab4dc1@pc_bostjans>#1/1

Hoj!

You have too options:
1.
By creating replication environment use the following command: DBMS_REPCAT.ADD_MASTER_DATABASE(

	gname => 'group_name',
	master => 'destination_site',
	propagation_mode => 'asynchronous');

You explicitly tell what kind of propagation mode will be used!

2.
By altering replication environment you can use: DBMS_REPCAT.ALTER_MASTER_PROPAGATION(

	gname => 'group_name',
	master => 'master_site',
	dblink_list => 'destiantion_site',
	propagation_mode => 'synchronous');

Hope this help!

-- 
Boštjan Štupica

Johnson Family <johnson_at_obeliskltd.demon.co.uk> wrote in article
<34D30577.2F433905_at_obeliskltd.demon.co.uk>...


> I was wondering if any of the Oracle DBA type gurus could answer a

> question for

> me?

> I have been asked to set up a replication system for an application we

> are building,

> it consists of two NT 4.0 machines running Oracle Server 7.3.4 connected

> via a

> LAN.  We have the same schemas on both servers, and both machines run

> the same

> application software.  Users connected to either machine can alter thier

> subscription

> information so we need to replicate the changes from one machine to the

> other.  I have

> proposed we use multi-master replication (updatable snapshots?) with

> async data

> propagation.  We also have an administration tool which alters some of

> the tables,

> which also need replication.  What I want to do is use Synchronous

> propasgation here

> to ensure the other database is updated.  The admin people will be able

> to ensure that

> both servers are operating before makeing the changes so Sync

> propagation wont be a

> problem.

> Now after all that the question is:

> 

> How do I set up the replication to use synchronous propagation for one

> replication group

> and asynchronous for the other, when both groups are in the same

> schemas.

> Any help or pointers to where I can find info would be appreciated.  I

> have checked the

> Oracle Magazine archives already and the info there is not too clear.

> 

> I would prefer mail back to me as I dont get to browse this group that

> often.

> 

> Thanks

> Darren

> .........A future DBA? :)

Received on Sat Jan 31 1998 - 00:00:00 CST