OraFAQ Forum: Replication » Changing Master Definition Site

Home » Server Options » Replication » Changing Master Definition Site

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Changing Master Definition Site [message #75207]

Mon, 08 July 2002 05:33

Mayank
Messages: 8
Registered: July 2002

Junior Member

I am working on Multi Master Site Replication env. But some how my master definition site has been corrupted hence to continue work I have to make my second master site Master definition site. For this I have run the following procedure.

for this i had to connect

repadmin/repadmin@lko

(Since i can not connect to repadmin/repadmin@gg since GG is down)

BEGIN
DBMS_REPCAT.RELOCATE_MASTERDEF(
GNAME => 'PF_MG',
OLD_MASTERDEF => 'GG',
NEW_MASTERDEF => 'LKO',
NOTIFY_MASTERS => TRUE,
INCLUDE_OLD_MASTERDEF => TRUE);
END;

the following error message is coming

ORA-23312: not the masterdef according to LKO

now tell me what should i do.

Thanks in advance

Mayank

Report message to a moderator

Re: Changing Master Definition Site [message #75215 is a reply to message #75207]

Sun, 21 July 2002 17:26

David Simpson
Messages: 29
Registered: May 2002

Junior Member

Mayank,
I suggest setting the references to the previous master site = FALSE since it is down:
NOTIFY_MASTERS => FALSE,
INCLUDE_OLD_MASTERDEF => FALSE);

David Simpson
www.dotcomsolutionsinc.net

Report message to a moderator

Previous Topic:	Replication of functions and views
Next Topic:	Two databases in sync

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 17:55:00 CST 2025