Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> urgent : multi master Replication problem

urgent : multi master Replication problem

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Tue, 05 Dec 2000 18:12:44 +0530
Message-Id: <10701.123638@fatcity.com> 





--------------F54A79C8B937EBA594F45303




Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit




Hi all


problem :  I didn't get any error in the deferror in the same way no data is
also replicated.



some of the replication status through replication tables after the
configuration and replication resume command



SQL> @c:\repmon.sql


select sname, masterdef, dblink from   sys.dba_repschema;
Replication schemas/ sites



SchemaName           MasterDef? DBLink


-------------------- ---------- -----------------------------------


SCOTT_SK             Y          ORACLE8.SHAFIKA.VETRI.COM
SCOTT_SK             N          GXDB.THIRU.VETRI.COM





1 rows selected.



RepCat Log (after a while you should see no entries):
select request, status, message, errnum from   sys.dba_repcatlog;

REQUEST                       STATUS         MESSAGE


ERRNUM



----------------------------- -------------- -------------------------




COPY_FLAVOR_DEFINITIONS       AWAIT_CALLBACK
RESUME_MASTER_ACTIVITY        AWAIT_CALLBACK
CREATE_MASTER_REPOBJECT       AWAIT_CALLBACK
GENERATE_INTERNAL_PKG_SUPPORT AWAIT_CALLBACK
END_GEN_INTERNAL_PKG_SUPPORT  READY
ADD_MASTER_DATABASE           AWAIT_CALLBACK
ADD_MASTER_DATABASE           READY
RESUME_MASTER_ACTIVITY        READY





8 rows selected.



Entries in the job queue


select job, last_date, last_sec, next_date, next_sec, broken, failures,
what from   sys.dba_jobs where  schema_user = 'REPADMIN';



      JOB LAST_DATE LAST_SEC NEXT_DATE NEXT_SEC Broken  FAILURES


--------- --------- -------- --------- -------- ------ ---------

WHAT






       49 05-DEC-00 17:53:19 05-DEC-00 18:03:19 N              0

dbms_repcat.do_deferred_repcat_admin('"SCOTT_S"', FALSE);



       48 05-DEC-00 17:53:50 05-DEC-00 18:03:50 N              0

dbms_repcat.do_deferred_repcat_admin('"SCOTT_LAST"', FALSE);



       50 05-DEC-00 17:56:54 05-DEC-00 18:06:54 N              0

dbms_repcat.do_deferred_repcat_admin('"SCOTT_SK"', FALSE);




3 rows selected.



Replication Status:



select sname, master, status from   sys.dba_repcat;



SchemaName           M STATUS


-------------------- - ---------




SCOTT_SK             Y QUIESCED


1 rows selected.



select gname, type||' '||sname||'.'||oname object, status from
sys.dba_repobject;



Objects registered for replication


GroupName            OBJECT                              STATUS


-------------------- ----------------------------------- ---------


SCOTT_SK             TABLE SCOTT.S                       VALID
SCOTT_SK             PACKAGE SCOTT.S$RP                  VALID
SCOTT_SK             PACKAGE BODY SCOTT.S$RP             VALID





3 rows selected.



Thanks and Regards


suganya









"Weerd Kirsten, E.C. de" wrote:


> Hi,
>
>         I asked for a script, and have recevied several for which I thank
> you all, for automatically recreating indexes.
>
>         One thing I'm wondering about B4 I try it all out :
>
>         When a table is created with a PK or Uniqe-constraint, indexes are
> created, right ??? But if I drop these indexes en recreate them, is the
> PK/U-constraint still valid, or do these indexe shave to be filtered out of
> the mass ???
>
> Greets,
>
> Kirsten
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Weerd Kirsten, E.C. de
>   INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).





--------------F54A79C8B937EBA594F45303




Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit



<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>


&nbsp;


<br>Hi all


<br>problem :&nbsp; I didn't get any error in the deferror in the same
way no data is also replicated.


<p>some of the replication status through replication tables after the
configuration and replication resume command
<p>SQL> @c:\repmon.sql


<br><font color="#3366FF">select sname, masterdef, dblink from&nbsp;&nbsp;
sys.dba_repschema;</font>


<br>Replication schemas/ sites


<p>SchemaName&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
MasterDef? DBLink

<br>-------------------- ---------- -----------------------------------


<br>SCOTT_SK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ORACLE8.SHAFIKA.VETRI.COM
<br>SCOTT_SK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GXDB.THIRU.VETRI.COM

<p>1 rows selected.
<p>RepCat Log (after a while you should see no entries):
<br><font color="#3366FF">select request, status, message, errnum from&nbsp;&nbsp;


sys.dba_repcatlog;</font>


<br>REQUEST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
STATUS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MESSAGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
ERRNUM


<br>----------------------------- -------------- -------------------------





<br>COPY_FLAVOR_DEFINITIONS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AWAIT_CALLBACK
<br>RESUME_MASTER_ACTIVITY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AWAIT_CALLBACK
<br>CREATE_MASTER_REPOBJECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AWAIT_CALLBACK
<br>GENERATE_INTERNAL_PKG_SUPPORT AWAIT_CALLBACK
<br>END_GEN_INTERNAL_PKG_SUPPORT&nbsp; READY
<br>ADD_MASTER_DATABASE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


AWAIT_CALLBACK



<br>ADD_MASTER_DATABASE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
READY


<br>RESUME_MASTER_ACTIVITY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; READY
<p>8 rows selected.
<p>Entries in the job queue
<br><font color="#3333FF">select job, last_date, last_sec, next_date, next_sec,


broken, failures,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; what from&nbsp;&nbsp;
sys.dba_jobs where&nbsp; schema_user = 'REPADMIN';</font>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JOB LAST_DATE LAST_SEC NEXT_DATE NEXT_SEC
Broken&nbsp; FAILURES

<br>--------- --------- -------- --------- -------- ------ ---------
<br>WHAT
<br>----------------------------------------------------------------------------------------------------
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 49 05-DEC-00 17:53:19 05-DEC-00


18:03:19 N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0

<br>dbms_repcat.do_deferred_repcat_admin('"SCOTT_S"', FALSE);
<br>&nbsp;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48 05-DEC-00 17:53:50 05-DEC-00


18:03:50 N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0

<br>dbms_repcat.do_deferred_repcat_admin('"SCOTT_LAST"', FALSE);
<br>&nbsp;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50 05-DEC-00 17:56:54 05-DEC-00


18:06:54 N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0

<br>dbms_repcat.do_deferred_repcat_admin('"SCOTT_SK"', FALSE);
<br>&nbsp;
<p>3 rows selected.
<p>Replication Status:
<p><font color="#3366FF">select sname, master, status from&nbsp;&nbsp;


sys.dba_repcat;</font>


<p>SchemaName&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
M STATUS


<br>-------------------- - ---------




<br>&nbsp;


<br>SCOTT_SK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Y QUIESCED



<p>1 rows selected.


<p><font color="#3366FF">select gname, type||' '||sname||'.'||oname object,
status from&nbsp;&nbsp; sys.dba_repobject;</font>
<p>Objects registered for replication


<p>GroupName&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
OBJECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
STATUS


<br>-------------------- ----------------------------------- ---------


<p>SCOTT_SK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
TABLE SCOTT.S&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
VALID



<br>SCOTT_SK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE SCOTT.S$RP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
VALID



<br>SCOTT_SK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE BODY SCOTT.S$RP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
VALID


<p>3 rows selected.
<p>Thanks and Regards
<br>suganya
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<p>"Weerd Kirsten, E.C. de" wrote:
<blockquote TYPE=CITE>Hi,
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I asked for a script, and


have recevied several for which I thank


<br>you all, for automatically recreating indexes.
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; One thing I'm wondering about
B4 I try it all out :


<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When a table is created with
a PK or Uniqe-constraint, indexes are


<br>created, right ??? But if I drop these indexes en recreate them, is
the


<br>PK/U-constraint still valid, or do these indexe shave to be filtered
out of

<br>the mass ???
<p>Greets,
<p>Kirsten
<br>--
<br>Please see the official ORACLE-L FAQ: <a href="http://www.orafaq.com">http://www.orafaq.com</a>
<br>--
<br>Author: Weerd Kirsten, E.C. de
<br>&nbsp; INET: Kirsten.deWeerd_at_Oranjewoud.nl
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;


FAX: (858) 538-5051



<br>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --
Public Internet access / Mailing Lists

<br>--------------------------------------------------------------------
<br>To REMOVE yourself from this mailing list, send an E-Mail message


<br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
<br>the message BODY, include a line containing: UNSUB ORACLE-L
Received on Tue Dec 05 2000 - 06:42:44 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US