Hi Gurus,
Please help
I had multimaster replication but machine which contained master
defination
site crashed and I am not able to make it up .
I am not able to remove replication from other site as it show the error
of
not being master defination site.
We have create another master group and tried to add objects in it but we
are
not able to do so as it give an error of being adding already existing
objects.
We have tried
use_existing_object => TRUE/FALSE
both but nothing worked.
I have tried DBMS_REPCAT.RELOCATE_MASTERDEF but unable to run it as it
shows below errors
SQL> Select gname,MASTER,SNAME from dba_repgroup ;
GNAME M SNAME
------------------------------ - ------------------------------
MEDS Y MEDS
SQL> select GNAME,DBLINK ,MASTERDEF from DBA_REPSITES;
GNAME
DBLINK M
------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------
MEDS MEPP.WORLD
Y
MEDS MEPS.WORLD
N
MEPYY MEPY.WORLD
Y
SQL> BEGIN
2 DBMS_REPCAT.RELOCATE_MASTERDEF (
3 gname => 'MEDS',
4 old_masterdef => 'MEPP.WORLD',
5 new_masterdef => 'MEPY.WORLD',
6 notify_masters => TRUE,
7 include_old_masterdef => FALSE);
8 END;
9 /
BEGIN
*
ERROR at line 1:
ORA-23313: object group "PUBLIC"."MEDS" is not mastered at MEPY.WORLD
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2893
ORA-06512: at "SYS.DBMS_REPCAT_UTL4", line 885
ORA-06512: at "SYS.DBMS_REPCAT_UTL4", line 2853
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 3308
ORA-06512: at "SYS.DBMS_REPCAT", line 818
ORA-06512: at line 2
SQL> select * from sys.props$ where name = 'GLOBAL_DB_NAME';
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
COMMENT$
--------------------------------------------------------------------------------
GLOBAL_DB_NAME
MEPY.WORLD
Global database name
Jyoti Goyal
Application Implementation Support
-Release Management
Orange Business Services
Infinity Towers B & C *th floor DLF City
Gurgaon,INDIA
CVS: 7-357-6600
Phone: +91-124-4358333
http://www.orange-business.com
*********************************
This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised
use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or
falsified.
If you are not the intended addressee of this message, please cancel it immediately and inform the sender.
********************************
Oracle LazyDBA home page