Ogg Process Split

Source: Internet
Author: User

12 tables in 36 databases target-side inbound process splitbecause the target side of the Ogg inbound process synchronization of more tables, large amounts of data, resulting in the storage process delays. In the case of sufficient host CPU and memory, it is possible to split a process with a delay, divide multiple tables from one process to another process, or synchronize a table with a large amount of data in several processes. process description for split process:1) Find the process where the split table is located 2) the process that the split table is located in 3) gets the seqno and RBA number 4 of the process in which the splitter table is located (mapexclude) 5) Add split process 6) specify the split process Read seqno and RBA of queue files 7) Edit split new process 8) Start Process Note: Please read the above process first, then do the following! 1. Determine the table that needs to split the process (this example splits 12 tables)      hx_sb.sb_dkdj_skbg                  This table splits 3 processes     hx_sb.sb_sbb                        This table splits 6 processes     HX_ sb.sb_zzs_fb_zzsjmssbmxb_msxm    This table splits 3 processes     hx_sb.sb_zzs_xgm          nbsp         This table splits 6 processes     hx_sb.sb_zzs_xgm_fb_flzl            The table splits 3 Process     HX_SB. sb_zzs_ybnsr                  This table splits 3 processes     HX_SB. sb_zzs_ybnsr_fb_jxsejgmxb      This table splits 6 processes     HX_SB. sb_zzs_ybnsr_fb_ygzsffxcsm    This table splits 3 processes     HX_SB. sb_zzs_ybnsr_fb_ynseayskm      This table splits 3 processes     HX_SB. sb_zzs_ybnsr_fb1_bqxsqkmx      This table splits 6 processes     HX_SB. sb_zzs_ybnsr_fb2_bqjxsemx      This table splits 6 processes     HX_SB. sb_zzs_ybnsr_fb5_bdcfqdkb&nbsp     This table splits 3 processes    2. The process of the above 12 tables is the one that needs to be split. Find the process that contains the 12 tables you want to split:Example: View param rzg_ff2b--HX_SB. SB_SBB view param rzg_ff2h--hx_sb. SB_ZZS_YBNSR_FB1_BQXSQKMX view param rzg_ff2i--hx_sb. Sb_zzs_ybnsr_fb2_bqjxsemx view param rzg_ff2j--hx_sb. SB_ZZS_YBNSR HX_SB. SB_ZZS_XGM view param rzg_ff2n--hx_sb. Sb_zzs_xgm_fb_flzl view param RZG_FF2A-Contains the remaining 6 sheets 3, stop the need to split (row table) of the inbound processStop rzg_ff2b Stop rzg_ff2h stop rzg_ff2i stop rzg_ff2j stop rzg_ff2n stop RZG_FF2A 4, take the current seqno and RBA number, such as XX units as follows  Example:    Ggsci (nmsthxffdb01) 3> info rzg_ff2b     replicat   RZG_FF2B  Last Started 2017-01-14 19:07   status running    Checkpoint lag       01:23:38 (U pdated 02:20:38 ago)     Log Read checkpoint  File ./dirdat/zb002751          &NBSP ;              2017-01-14 17:22:34.052064  RBA 347329296     Info RZG _ff2b       --  zb002751 RBA 347329296     Info rzg_ff2h      &NBSP ;--  zb002751 RBA 347335602     Info rzg_ff2i       --  zb002751 RBA 34733560 2     Info rzg_ff2j       --  zb002751 RBA 347335602     Info rzg_f f2n       --  zb002751 RBA 347378402     Info rzg_ff2a       - -  zb002751 RBA 347521117    5. Schedule the original process (edit process, add the statement to exclude the table, if there are only 1 tables in the process, do not need to exclude)Example (add the following mapexclude list statement, added below the last parameter, and then save exit): Eidt param rzg_ff2a mapexclude hx_sb. SB_DKDJ_SKBG, Mapexclude HX_SB. SB_ZZS_YBNSR_FB_JXSEJGMXB, Mapexclude HX_SB. SB_ZZS_YBNSR_FB_YGZSFFXCSM, Mapexclude HX_SB. SB_ZZS_YBNSR_FB_YNSEAYSKM, Mapexclude HX_SB. SB_ZZS_FB_ZZSJMSSBMXB_MSXM, Mapexclude HX_SB. SB_ZZS_YBNSR_FB5_BDCFQDKB; 6, add the split process, according to the amount of data found above to split a process for multiple processes (3 or 6 processes), the new process naming format: rsb_p**, where "*" represents a number, and increments from 01Example: split three processes as follows:Add Replicat rsb_p01, Exttrail./dirdat/zb add Replicat rsb_p02, Exttrail./dirdat/zb add Replicat rsb_p03, exttrail./d Irdat/zb split six processes as follows:Add Replicat rsb_p04, Exttrail./dirdat/zb add Replicat rsb_p05, Exttrail./dirdat/zb add Replicat rsb_p06, exttrail./d IRDAT/ZB add Replicat rsb_p07, Exttrail./dirdat/zb add Replicat rsb_p08, Exttrail./dirdat/zb add Replicat RSB_P09, E Xttrail./dirdat/zb 7. Specify seqno and RBA of new process, above "info process name" (Note process name correspondence) split three processes as follows:Alter Replicat RSB_P01, Extseqno 002751, Extrba 347521117 alter Replicat RSB_P02, Extseqno 002751, Extrba 347521117 alte R Replicat rsb_p03, Extseqno 002751, Extrba 347521117 split six processes as follows:Alter Replicat RSB_P04, Extseqno 002751, Extrba 347329296 alter Replicat RSB_P05, Extseqno 002751, Extrba 347329296 alte R Replicat rsb_p06, Extseqno 002751, Extrba 347329296 alter Replicat rsb_p07, Extseqno 002751, Extrba 347329296 alter RE Plicat rsb_p08, Extseqno 002751, Extrba 347329296 alter Replicat rsb_p09, Extseqno 002751, Extrba 347329296 8. Edit the new process of splittingNote:    1) replicat rsb_p01  2) discardfile./dirrpt/rsb_p01.dsc,append,megabytes 100  3) split table name   Example:     edit param rsb_p01     replicat rsb_p01    SETENV (oracle_sid= "Nmsthxff" )     SETENV (Nls_lang=american_america. Al32utf8)     Userid Ggs,password AACAAAAAAAAAAAIAUCOJGDDFPFHEGCPD, BLOWFISH, Encryptkey default    01:59    Reportrollover at 02:00    Cachemgr, CACHESIZE 256mb    Reperror DEFAULT, abend    discardfile/dirrpt/rsb_p01.dsc,append,megabytes 100    Discardrollover at 06:00  & nbsp gettruncates    numfiles 3000    eofdelaycsecs 30    assumetargetdefs    allownoopupdates    dynamicresolution    getupdatebefores    nocompressdeletes      MAP HX_SB. SB_DKDJ_SKBG, TARGET HX_SB. SB_DKDJ_SKBG, Colmap (usedefaults,  &      &NBSp SJTB_SJ = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("Juliantimestamp")), FILTER (@RANGE (1,4));--1 Here is the first process of a table split, and 4 is the total split into 4 processes 9, start the process (note: Must start the new split process, and so the new process does not delay, and then start the original process)Example:--Split new process start Rsb_p01 start RSB_P02 start rsb_p03--original process start RZG_FF2A-Split new process start rsb_p04 start RSB_P05 sta RT rsb_p06 Start rsb_p07 start rsb_p08 start rsb_p09--original process start RZG_FF2B--OK!!

Ogg Process Split

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.