| Suspend the master site form multi master replication [message #348282] |
Tue, 16 September 2008 05:35  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
I want to remove the master site which is in the multi master replication environment.
I have a doubt here. When I try to suspend the master activity,I need to give the gname.
please find the below script
BEGIN
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY (
gname => 'NAGADMIN');
END;
/
Where gname=master group name.But I have 9 master groups in my database. Can anyone tell me whether if i give one of the gname present in the master site will suspend the replication of the entire database from the replication.
eg; i am only giving NAGADMIN gname in the suspend activity script..
I have other gnames like, NAGUSER,NAGAUTH, etc....
|
|
|
|
| Re: Suspend the master site form multi master replication [message #348834 is a reply to message #348282] |
Thu, 18 September 2008 01:12  |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
 
|
|
BEGIN
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY (
gname => 'NAGADMIN');
END;
/
Where gname=master group name.But I have 9 master groups in my database.
Can anyone tell me whether if i give one of the gname present in the master site will suspend the replication of the entire database from the replication.
eg; i am only giving NAGADMIN gname in the suspend activity script..
I have other gnames like, NAGUSER,NAGAUTH, etc....
If more then one group having in master site then if you want suspend from master site you need suspend one by one.
Once suspend from master site. Data Transfer it won't
happen between master and materialized view site in your database.
Babu
[Updated on: Thu, 18 September 2008 01:13] Report message to a moderator |
|
|
|
| Re: Suspend the master site form multi master replication [message #348859 is a reply to message #348834] |
Thu, 18 September 2008 02:45 |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
please help me on the following queries too.
1)Is it possible to suspend the replication from the master site or we have to suspend the replication from master definition site.
2)Please have the same scenario as what I have gave in the initial but in the master definition site and not in the master site.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
