DB Wiki

There are currently no differences between the replicat process in 10g and 12c

REPLICAT REPMOL01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@molbb, PASSWORD password
ASSUMETARGETDEFS
DBOPTIONS SUPPRESSTRIGGERS
DISCARDFILE ./dirrpt/discREPMOL.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
DDL INCLUDE ALL
DDLOPTIONS REPORT
DDLERROR 955 DISCARD
DDLERROR 1031 DISCARD
DDLERROR 24344 DISCARD
REPORTCOUNT EVERY 10 MINUTES, RATE
REPORTROLLOVER AT 00:00 ON MONDAY
INCLUDE ./dirprm/macros/exceptions.inc

-- Exceptions logging removed from USER_TRANSFER_ITEMS
-- This is due to a Cascade Delete foreign key which was filling 
-- EXCEPTIONS table up with "ORA-01403: no data found" messages
MAP MAILONLINE.USER_TRANSFER_ITEM, TARGET MAILONLINE.USER_TRANSFER_ITEM,
      COMPARECOLS (ON DELETE KEY),
   RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
   RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));

MAP MAILONLINE.ARTICLES, TARGET MAILONLINE.ARTICLES,
       COMPARECOLS (ON UPDATE ALLEXCLUDING (ARTICLE_TEXT)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.ARTICLES, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.PARSED_ARTICLES, TARGET MAILONLINE.PARSED_ARTICLES,
      COMPARECOLS (ON UPDATE ALLEXCLUDING (ARTICLE_TEXT)),
   RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
   RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.PARSED_ARTICLES, TARGET GGATE.EXCEPTIONS,
   EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.CMS_SCRATCHPAD, TARGET MAILONLINE.CMS_SCRATCHPAD,
       COMPARECOLS (ON DELETE ALL),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
MAP MAILONLINE.CMS_SCRATCHPAD, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.MODULES, TARGET MAILONLINE.MODULES,
       COMPARECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.MODULES, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.VM_VIDEO, TARGET MAILONLINE.VM_VIDEO,
    COMPARECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.VM_VIDEO, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.QRTZ_SCHEDULER_STATE, TARGET MAILONLINE.QRTZ_SCHEDULER_STATE,
      COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, OVERWRITE)),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD)),
    REPERROR (1, IGNORE);
MAP MAILONLINE.QRTZ_SCHEDULER_STATE, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.ASSET_PUBLISHER_LAST_RUN, TARGET MAILONLINE.ASSET_PUBLISHER_LAST_RUN,
       KEYCOLS(ITEM_TYPE),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (LAST_RUN_DATE)));
MAP MAILONLINE.ASSET_PUBLISHER_LAST_RUN, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.QRTZ_TRIGGER_LISTENERS, TARGET MAILONLINE.QRTZ_TRIGGER_LISTENERS,
       COMPARECOLS (ON DELETE KEY),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
MAP MAILONLINE.QRTZ_TRIGGER_LISTENERS, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.QRTZ_FIRED_TRIGGERS, TARGET MAILONLINE.QRTZ_FIRED_TRIGGERS,
       COMPARECOLS (ON DELETE KEY),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
MAP MAILONLINE.QRTZ_FIRED_TRIGGERS, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.ARTICLES_VERSIONS, TARGET MAILONLINE.ARTICLES_VERSIONS,
       COMPARECOLS (ON UPDATE ALLEXCLUDING (ARTICLE_TEXT, ARTICLE_PARSED_TEXT)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.ARTICLES_VERSIONS, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAPEXCLUDE MAILONLINE.MV_LATEST_ARTICLE_AUTHOR;
MAPEXCLUDE MAILONLINE.SYS_IMPORT_FULL_*;

MAP MAILONLINE.*, TARGET MAILONLINE.*;

REPLICAT REPRDC01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@molbb, PASSWORD password
DBOPTIONS SUPPRESSTRIGGERS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/discREPRDC.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
REPORTCOUNT EVERY 10 MINUTES, RATE
REPORTROLLOVER AT 00:00 ON MONDAY
INCLUDE ./dirprm/macros/exceptions.inc

MAP RDRCOMMENTS.RC_COMMENT, TARGET RDRCOMMENTS.RC_COMMENT,
    COMPARECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, VOTE_COUNT, VOTE_RATING), ON DELETE KEY),
    RESOLVECONFLICT (UPDATEROWEXISTS, (delta_res_method, USEDELTA, COLS (VOTE_COUNT, VOTE_RATING)), (DEFAULT, USEMAX (LAST_UPDATED))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, IGNORE));
MAP RDRCOMMENTS.RC_COMMENT, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP RDRCOMMENTS.RC_USER, TARGET RDRCOMMENTS.RC_USER,
    COMPARECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, VOTE_COUNT, VOTE_RATING)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (delta_res_method, USEDELTA, COLS (VOTE_COUNT, VOTE_RATING)), (DEFAULT, USEMAX (LAST_UPDATED))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP RDRCOMMENTS.RC_USER, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP RDRCOMMENTS.RC_ASSET, TARGET RDRCOMMENTS.RC_ASSET,
    COMPARECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, COMMENT_COUNT)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (LAST_UPDATED))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP RDRCOMMENTS.RC_ASSET, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP RDRCOMMENTS.*, TARGET RDRCOMMENTS.*;

REPLICAT REPREG01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@molbb, PASSWORD password
DBOPTIONS SUPPRESSTRIGGERS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/discREPREG.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
REPORTCOUNT EVERY 10 MINUTES, RATE
REPORTROLLOVER AT 00:00 ON MONDAY
INCLUDE ./dirprm/macros/exceptions.inc

MAP REGISTRATION.REGISTERED_USER, TARGET REGISTRATION.REGISTERED_USER,
    COMPARECOLS (ON UPDATE KEYINCLUDING (UPDATED_DATE), ON DELETE KEY),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (UPDATED_DATE), DISCARD)),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD));
MAP REGISTRATION.REGISTERED_USER, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP REGISTRATION.*, TARGET REGISTRATION.*;

Check the list of schemas below to ensure that there have been no new schemas created recently.

REPLICAT REPOTH01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@molbb, PASSWORD password
ASSUMETARGETDEFS
DBOPTIONS SUPPRESSTRIGGERS
DISCARDFILE ./dirrpt/discREPOTH.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
REPORTCOUNT EVERY 10 MINUTES, RATE
REPORTROLLOVER AT 00:00 ON MONDAY

MAP FBIAGENT.ARTICLE, TARGET FBIAGENT.ARTICLE,
    COMPARECOLS (ON UPDATE ALL),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));

MAP ANALYTICS.*, TARGET ANALYTICS.*;
MAP ANDCOMMUNITIES.*, TARGET ANDCOMMUNITIES.*;
MAP APTECO.*, TARGET APTECO.*;
MAP BOARDSMIG.*, TARGET BOARDSMIG.*;
MAP CLEARSPACE.*, TARGET CLEARSPACE.*;
MAP CSMIG.*, TARGET CSMIG.*;
MAP EAGLEEYE.*, TARGET EAGLEEYE.*;
MAP FBIAGENT.*, TARGET FBIAGENT.*;
MAP GATEKEEPER.*, TARGET GATEKEEPER.*;
MAP GATEKEEPERADMIN.*, TARGET GATEKEEPERADMIN.*;
MAP GKREAD.*, TARGET GKREAD.*;
MAP JIVETILREAD.*, TARGET JIVETILREAD.*;
MAP JOBMANAGER.*, TARGET JOBMANAGER.*;
MAP LEGAL.*, TARGET LEGAL.*;
MAP MAILREAD.*, TARGET MAILREAD.*;
MAP MOFEEDS.*, TARGET MOFEEDS.*;
MAP MOLAPP.*, TARGET MOLAPP.*;
MAP MOLEM.*, TARGET MOLEM.*;
MAP MOLSUPP.*, TARGET MOLSUPP.*;
MAP MOUSER.*, TARGET MOUSER.*;
MAP RCREAD.*, TARGET RCREAD.*;
MAP RCUSER.*, TARGET RCUSER.*;
MAP REGREAD.*, TARGET REGREAD.*;
MAP SCHOOL.*, TARGET SCHOOL.*;
MAP TILDUMMY.*, TARGET TILDUMMY.*;
MAP TIMBOARDS.*, TARGET TIMBOARDS.*;
MAP TIMDEBATE.*, TARGET TIMDEBATE.*;
MAP TRAVELMAIL.*, TARGET TRAVELMAIL.*;