replicat10g
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
replicat10g [2016/10/21 09:12] – created z0hpvk | replicat10g [2025/03/08 22:24] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 2: | Line 2: | ||
==== MailOnline Schema ==== | ==== MailOnline Schema ==== | ||
- | < | + | < |
SETENV (NLS_LANG=" | SETENV (NLS_LANG=" | ||
- | USERID ggate@andracaa, PASSWORD password | + | USERID ggate@molbb, PASSWORD password |
- | TRANLOGOPTIONS DBLOGREADER | + | ASSUMETARGETDEFS |
- | TRANLOGOPTIONS BUFSIZE 4096000 | + | DBOPTIONS SUPPRESSTRIGGERS |
- | TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000 | + | DISCARDFILE ./dirrpt/discREPMOL.dsc, APPEND, MEGABYTES 100 |
- | TRANLOGOPTIONS EXCLUDEUSER GGATE | + | |
- | DISCARDFILE ./dirrpt/discEXTMOL.txt, APPEND, MEGABYTES 100 | + | |
DISCARDROLLOVER ON MONDAY | DISCARDROLLOVER ON MONDAY | ||
- | WARNLONGTRANS 30m, CHECKINTERVAL 5m | + | DDL INCLUDE ALL |
+ | DDLOPTIONS REPORT | ||
+ | DDLERROR 955 DISCARD | ||
+ | DDLERROR 1031 DISCARD | ||
+ | DDLERROR 24344 DISCARD | ||
REPORTCOUNT EVERY 10 MINUTES, RATE | REPORTCOUNT EVERY 10 MINUTES, RATE | ||
REPORTROLLOVER AT 00:00 ON MONDAY | REPORTROLLOVER AT 00:00 ON MONDAY | ||
- | EXTTRAIL | + | INCLUDE |
- | NODYNAMICRESOLUTION | + | -- Exceptions logging removed from USER_TRANSFER_ITEMS |
+ | -- This is due to a Cascade Delete foreign key which was filling | ||
+ | -- EXCEPTIONS table up with " | ||
+ | MAP MAILONLINE.USER_TRANSFER_ITEM, | ||
+ | COMPARECOLS (ON DELETE KEY), | ||
+ | | ||
+ | | ||
- | TABLE MAILONLINE.PARSED_ARTICLES, | + | MAP MAILONLINE.ARTICLES, TARGET MAILONLINE.ARTICLES, |
- | | + | COMPARECOLS |
+ | RESOLVECONFLICT (UPDATEROWEXISTS, | ||
+ | RESOLVECONFLICT (UPDATEROWMISSING, | ||
+ | MAP MAILONLINE.ARTICLES, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE MAILONLINE.ARTICLES, | + | MAP MAILONLINE.PARSED_ARTICLES, |
- | | + | |
+ | | ||
+ | | ||
+ | MAP MAILONLINE.PARSED_ARTICLES, | ||
+ | | ||
- | TABLE MAILONLINE.MODULES, | + | MAP MAILONLINE.CMS_SCRATCHPAD, |
- | | + | COMPARECOLS |
+ | RESOLVECONFLICT (DELETEROWEXISTS, | ||
+ | RESOLVECONFLICT (DELETEROWMISSING, | ||
+ | MAP MAILONLINE.CMS_SCRATCHPAD, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE MAILONLINE.LINK_LIST_GROUP, | + | MAP MAILONLINE.MODULES, TARGET MAILONLINE.MODULES, |
- | | + | COMPARECOLS |
+ | RESOLVECONFLICT (UPDATEROWEXISTS, | ||
+ | RESOLVECONFLICT (UPDATEROWMISSING, | ||
+ | MAP MAILONLINE.MODULES, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE MAILONLINE.CMS_SCRATCHPAD, | + | MAP MAILONLINE.VM_VIDEO, TARGET MAILONLINE.VM_VIDEO, |
- | | + | |
+ | RESOLVECONFLICT (UPDATEROWEXISTS, | ||
+ | RESOLVECONFLICT (UPDATEROWMISSING, | ||
+ | MAP MAILONLINE.VM_VIDEO, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE MAILONLINE.VM_VIDEO, | + | MAP MAILONLINE.QRTZ_SCHEDULER_STATE, |
- | | + | |
+ | RESOLVECONFLICT (UPDATEROWEXISTS, | ||
+ | RESOLVECONFLICT (UPDATEROWMISSING, | ||
+ | RESOLVECONFLICT (DELETEROWEXISTS, | ||
+ | RESOLVECONFLICT (DELETEROWMISSING, | ||
+ | REPERROR (1, IGNORE); | ||
+ | MAP MAILONLINE.QRTZ_SCHEDULER_STATE, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE MAILONLINE.ASSET_PUBLISHER_LAST_RUN, | + | MAP MAILONLINE.ASSET_PUBLISHER_LAST_RUN, |
- | | + | KEYCOLS(ITEM_TYPE), |
+ | | ||
+ | MAP MAILONLINE.ASSET_PUBLISHER_LAST_RUN, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE MAILONLINE.QRTZ_TRIGGER_LISTENERS, | + | MAP MAILONLINE.QRTZ_TRIGGER_LISTENERS, |
+ | | ||
+ | RESOLVECONFLICT (DELETEROWEXISTS, | ||
+ | RESOLVECONFLICT (DELETEROWMISSING, | ||
+ | MAP MAILONLINE.QRTZ_TRIGGER_LISTENERS, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE MAILONLINE.QRTZ_FIRED_TRIGGERS, | + | MAP MAILONLINE.QRTZ_FIRED_TRIGGERS, |
+ | | ||
+ | RESOLVECONFLICT (DELETEROWEXISTS, | ||
+ | RESOLVECONFLICT (DELETEROWMISSING, | ||
+ | MAP MAILONLINE.QRTZ_FIRED_TRIGGERS, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE MAILONLINE.QRTZ_SCHEDULER_STATE, | + | MAP MAILONLINE.ARTICLES_VERSIONS, |
- | | + | COMPARECOLS |
+ | RESOLVECONFLICT (UPDATEROWEXISTS, | ||
+ | RESOLVECONFLICT (UPDATEROWMISSING, | ||
+ | MAP MAILONLINE.ARTICLES_VERSIONS, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE MAILONLINE.ARTICLES_VERSIONS, | + | MAPEXCLUDE |
- | | + | MAPEXCLUDE MAILONLINE.SYS_IMPORT_FULL_*; |
- | TABLE MAILONLINE.USER_TRANSFER_ITEM, GETBEFORECOLS (ON DELETE KEY); | + | MAP MAILONLINE.*, TARGET |
- | + | ||
- | TABLE MAILONLINE.RELATED_ARTICLES, | + | |
- | GETBEFORECOLS (ON UPDATE ALL); | + | |
- | + | ||
- | DYNAMICRESOLUTION | + | |
- | IGNOREUPDATEBEFORES | + | |
- | + | ||
- | DDL INCLUDE ALL, EXCLUDE OBJTYPE ' | + | |
- | DDLOPTIONS REPORT, IGNOREREPLICATES, | + | |
- | + | ||
- | TABLEEXCLUDE MAILONLINE.MV_LATEST_ARTICLE_AUTHOR; | + | |
- | TABLE MAILONLINE.*; | + | |
</ | </ | ||
==== Reader Comments Schema ==== | ==== Reader Comments Schema ==== | ||
- | < | + | < |
SETENV (NLS_LANG=" | SETENV (NLS_LANG=" | ||
- | USERID ggate@andracaa, PASSWORD password | + | USERID ggate@molbb, PASSWORD password |
- | TRANLOGOPTIONS DBLOGREADER | + | DBOPTIONS SUPPRESSTRIGGERS |
- | TRANLOGOPTIONS BUFSIZE 4096000 | + | ASSUMETARGETDEFS |
- | TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000 | + | DISCARDFILE ./dirrpt/discREPRDC.dsc, APPEND, MEGABYTES 100 |
- | TRANLOGOPTIONS EXCLUDEUSER GGATE | + | |
- | DISCARDFILE ./dirrpt/discEXTRDC.txt, APPEND, MEGABYTES 100 | + | |
DISCARDROLLOVER ON MONDAY | DISCARDROLLOVER ON MONDAY | ||
- | WARNLONGTRANS 30m, CHECKINTERVAL 5m | ||
REPORTCOUNT EVERY 10 MINUTES, RATE | REPORTCOUNT EVERY 10 MINUTES, RATE | ||
REPORTROLLOVER AT 00:00 ON MONDAY | REPORTROLLOVER AT 00:00 ON MONDAY | ||
- | EXTTRAIL | + | INCLUDE |
- | NODYNAMICRESOLUTION | + | MAP RDRCOMMENTS.RC_COMMENT, TARGET RDRCOMMENTS.RC_COMMENT, |
- | TABLE RDRCOMMENTS.RC_COMMENT | + | COMPARECOLS |
- | TABLE RDRCOMMENTS.RC_USER | + | |
- | TABLE RDRCOMMENTS.RC_ASSET | + | RESOLVECONFLICT (UPDATEROWMISSING, |
+ | RESOLVECONFLICT (DELETEROWEXISTS, | ||
+ | RESOLVECONFLICT (DELETEROWMISSING, | ||
+ | MAP RDRCOMMENTS.RC_COMMENT, TARGET GGATE.EXCEPTIONS, | ||
+ | EXCEPTIONSONLY, | ||
- | DYNAMICRESOLUTION | + | MAP RDRCOMMENTS.RC_USER, |
+ | COMPARECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, | ||
+ | RESOLVECONFLICT (UPDATEROWEXISTS, | ||
+ | RESOLVECONFLICT (UPDATEROWMISSING, | ||
+ | MAP RDRCOMMENTS.RC_USER, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE RDRCOMMENTS.*;</ | + | MAP RDRCOMMENTS.RC_ASSET, |
+ | COMPARECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, | ||
+ | RESOLVECONFLICT (UPDATEROWEXISTS, | ||
+ | RESOLVECONFLICT (UPDATEROWMISSING, | ||
+ | MAP RDRCOMMENTS.RC_ASSET, | ||
+ | EXCEPTIONSONLY, | ||
+ | |||
+ | MAP RDRCOMMENTS.*, | ||
+ | </ | ||
==== Registration Schema ==== | ==== Registration Schema ==== | ||
- | < | + | < |
SETENV (NLS_LANG=" | SETENV (NLS_LANG=" | ||
- | USERID ggate@andracaa, PASSWORD password | + | USERID ggate@molbb, PASSWORD password |
- | TRANLOGOPTIONS DBLOGREADER | + | DBOPTIONS SUPPRESSTRIGGERS |
- | TRANLOGOPTIONS BUFSIZE 4096000 | + | ASSUMETARGETDEFS |
- | TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000 | + | DISCARDFILE ./dirrpt/discREPREG.dsc, APPEND, MEGABYTES 100 |
- | TRANLOGOPTIONS EXCLUDEUSER GGATE | + | |
- | DISCARDFILE ./dirrpt/discEXTREG.txt, APPEND, MEGABYTES 100 | + | |
DISCARDROLLOVER ON MONDAY | DISCARDROLLOVER ON MONDAY | ||
- | WARNLONGTRANS 30m, CHECKINTERVAL 5m | ||
REPORTCOUNT EVERY 10 MINUTES, RATE | REPORTCOUNT EVERY 10 MINUTES, RATE | ||
REPORTROLLOVER AT 00:00 ON MONDAY | REPORTROLLOVER AT 00:00 ON MONDAY | ||
- | EXTTRAIL | + | INCLUDE |
- | NODYNAMICRESOLUTION | + | MAP REGISTRATION.REGISTERED_USER, |
+ | COMPARECOLS (ON UPDATE KEYINCLUDING (UPDATED_DATE), | ||
+ | RESOLVECONFLICT (UPDATEROWEXISTS, | ||
+ | RESOLVECONFLICT (UPDATEROWMISSING, | ||
+ | RESOLVECONFLICT (DELETEROWEXISTS, | ||
+ | MAP REGISTRATION.REGISTERED_USER, | ||
+ | EXCEPTIONSONLY, | ||
- | TABLE REGISTRATION.REGISTERED_USER GETBEFORECOLS (ON UPDATE ALL, ON DELETE KEY); | + | MAP REGISTRATION.*, TARGET |
- | + | ||
- | DYNAMICRESOLUTION | + | |
- | TABLE REGISTRATION.*; | + | |
</ | </ | ||
==== Other Schemas ==== | ==== Other Schemas ==== | ||
Check the list of schemas below to ensure that there have been no new schemas created recently. | Check the list of schemas below to ensure that there have been no new schemas created recently. | ||
- | < | + | < |
SETENV (NLS_LANG=" | SETENV (NLS_LANG=" | ||
- | USERID ggate@andracaa, PASSWORD password | + | USERID ggate@molbb, PASSWORD password |
- | TRANLOGOPTIONS DBLOGREADER | + | ASSUMETARGETDEFS |
- | TRANLOGOPTIONS BUFSIZE 4096000 | + | DBOPTIONS SUPPRESSTRIGGERS |
- | TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000 | + | DISCARDFILE ./ |
- | TRANLOGOPTIONS EXCLUDEUSER GGATE | + | DISCARDROLLOVER ON MONDAY |
- | WARNLONGTRANS 30m, CHECKINTERVAL 5m | + | |
REPORTCOUNT EVERY 10 MINUTES, RATE | REPORTCOUNT EVERY 10 MINUTES, RATE | ||
REPORTROLLOVER AT 00:00 ON MONDAY | REPORTROLLOVER AT 00:00 ON MONDAY | ||
- | DISCARDFILE ./ | ||
- | DISCARDROLLOVER ON MONDAY | ||
- | EXTTRAIL ./ | ||
- | NODYNAMICRESOLUTION | + | MAP FBIAGENT.ARTICLE, |
- | TABLE FBIAGENT.ARTICLE, | + | COMPARECOLS |
+ | RESOLVECONFLICT (UPDATEROWMISSING, | ||
- | DYNAMICRESOLUTION | + | MAP ANALYTICS.*, |
- | TABLE ANALYTICS.*; | + | MAP ANDCOMMUNITIES.*, |
- | TABLE ANDCOMMUNITIES.*; | + | MAP APTECO.*, TARGET |
- | TABLE APTECO.*; | + | MAP BOARDSMIG.*, |
- | TABLE BOARDSMIG.*; | + | MAP CLEARSPACE.*, |
- | TABLE CLEARSPACE.*; | + | MAP CSMIG.*, TARGET |
- | TABLE CSMIG.*; | + | MAP EAGLEEYE.*, TARGET |
- | TABLE EAGLEEYE.*; | + | MAP FBIAGENT.*, TARGET |
- | TABLE FBIAGENT.*; | + | MAP GATEKEEPER.*, |
- | TABLE GATEKEEPER.*; | + | MAP GATEKEEPERADMIN.*, |
- | TABLE GATEKEEPERADMIN.*; | + | MAP GKREAD.*, TARGET |
- | TABLE GKREAD.*; | + | MAP JIVETILREAD.*, |
- | TABLE JIVETILREAD.*; | + | MAP JOBMANAGER.*, |
- | TABLE JOBMANAGER.*; | + | MAP LEGAL.*, TARGET |
- | TABLE LEGAL.*; | + | MAP MAILREAD.*, TARGET |
- | TABLE MAILREAD.*; | + | MAP MOFEEDS.*, TARGET |
- | TABLE MOFEEDS.*; | + | MAP MOLAPP.*, TARGET |
- | TABLE MOLAPP.*; | + | MAP MOLEM.*, TARGET |
- | TABLE MOLEM.*; | + | MAP MOLSUPP.*, TARGET |
- | TABLE MOLSUPP.*; | + | MAP MOUSER.*, TARGET |
- | TABLE MOUSER.*; | + | MAP RCREAD.*, TARGET |
- | TABLE RCREAD.*; | + | MAP RCUSER.*, TARGET |
- | TABLE RCUSER.*; | + | MAP REGREAD.*, TARGET |
- | TABLE REGREAD.*; | + | MAP SCHOOL.*, TARGET |
- | TABLE SCHOOL.*; | + | MAP TILDUMMY.*, TARGET |
- | TABLE TILDUMMY.*; | + | MAP TIMBOARDS.*, |
- | TABLE TIMBOARDS.*; | + | MAP TIMDEBATE.*, |
- | TABLE TIMDEBATE.*; | + | MAP TRAVELMAIL.*, |
- | TABLE TRAVELMAIL.*;</ | + | </ |
replicat10g.1477041166.txt.gz · Last modified: 2025/03/08 22:23 (external edit)