Home » Server Options » Replication » Multi Master Replication (Oracle 9i, HP -UX)
Multi Master Replication [message #347907] Mon, 15 September 2008 00:50
Messages: 104
Registered: September 2008
Senior Member

I have a replication environment developed on multi-master replication.Here I have 1 master definition site and others are master sites.

I found the data mismatch between the master definition site and a master site when replicating. So I have decided to drop the master site DB2and decided to rebuild the database by exporting the database from DB1. Can I know the steps to copy the database DB1 to DB2 and to stop the replication and restart again on Db2.

As i came to know that we cannot truncate the database, I have decided to drop the entire database from the replication environment and build it same as master definition site DB1(parameters and tables,etc).

Please can anyone come with the steps to drop the database DB2 from multi master environment and create a new databse as DB1 and add the database DB2 into the replication again.

Pls ... anyone help on this..

the oracle version we are using is Release

The OS on which databases installed are HP-ux.

Note.Both the databases are in 2 different servers..


[Updated on: Mon, 15 September 2008 05:13]

Report message to a moderator

Previous Topic: Materialized View Issues
Next Topic: Suspend the master site form multi master replication
Goto Forum:

Current Time: Sun Dec 05 23:54:37 CST 2021