Home » Server Options » Replication » Changing Master Definition Site
Changing Master Definition Site [message #75207] Mon, 08 July 2002 05:33 Go to next message
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
Re: Changing Master Definition Site [message #75215 is a reply to message #75207] Sun, 21 July 2002 17:26 Go to previous message
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
Previous Topic: Replication of functions and views
Next Topic: Two databases in sync
Goto Forum:
  


Current Time: Tue Jul 14 22:05:32 CDT 2020