How to Drop Replication Group

Problem :

This is after tddevlopmentcop1 became inactive , without  properly terminating/stopping  GG groups . Below  is the error we get when we start the extract ( example RGNL01) .

Control  RSG’s were created on tddevcop1  and now this system is not accessible for VAM and tddevcop2 doesn’t get recognized .

We may need RSG’s to be reset.

2015-06-23 22:56:08  ERROR   OGG-00146  VAM function VAMInitialize returned unexpected result: error 600 - VAM Client Report <VAMInitialize:    Error response return

ed from RSG 0 for data signon (Data connection to this Vproc is invalid.)>.

Remedy :

You need to bypass access right and execute below commands :

1.       This update break relationship between replication group and its members

a.       For all tables

update dbc.tvm

set TblStatus ='D',tblrole=null,      RSGroupID =null

where TblStatus is not null

b.      For particular table/member

update dbc.tvm

set TblStatus ='D',tblrole=null,      RSGroupID =null

where tvmname = 'N_FIN_DEPT_TO_PIN_LINK'  and databaseid in ( sel databaseid from dbc.databases2 where databasename = 'ENGGDB_DDR');

2.       To drop such groups you need to execute below statements  

DELETE from DBC.RepGroup ;

 DELETE from DBC.RepGroupTables ;

 DELETE from DBC.RepRulesetTbl ;

 DELETE from DBC.RepCaptureRulesTbl ;

3.       Now you can test by creating new group and adding member into it.

create replication group test1;

alter replication group test1 drop sysdba.statsinfo;

help replication group test1;

sel * from dbc.repgroup;

drop replication group test1