Ogg process split (single table split into multiple processes)

Source: Internet
Author: User

ogg process split (single table split into multiple processes) Overview:The OGG process split describes how to split multiple tables in one inbound process into another process. This article will focus on how to use multiple processes to library a single table at the same time. Applicable conditions:1) The inbound process synchronizes only one table, but still has a delay of 2) target segment host CPU, memory pressure is not large enough to have sufficient resources to add a new inbound processThis example sets the HX_SB in Rzg_cxi2. SB_CWBB_XQYKJZZ_ZCFZB table split into the rzg_cxi1-rzg_cxi8 of the 8 processes 1. Create a configuration file for the newly added processEdit params Rzg_cxi1# #添加以下内容 # #Replicat rzg_cxi1SETENV (oracle_sid= "hasthxcx1") SETENV (Nls_lang=american_america. Al32utf8) Userid Ggs,password aacaaaaaaaaaaaiaucojgddfpfhegcpd, BLOWFISH, Encryptkey defaultreport at 01:59reportrollover at 02:00cachemgr, CACHESIZE 256MBREPERROR default,abenddiscardfile./dirrpt/rzg_cxi1.dsc,append, Megabytes 100DISCARDROLLOVER at 06:00gettruncatesnumfiles 3000EOFDELAYCSECS 30ASSUMETARGETDEFSALLOWNOOPUPDATESDYNAMICRESOLUTIONGETUPDATEBEFORESNOCOMPRESSDELETESMAP HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, TARGET HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, Colmap (usedefaults, & sjtb_sj = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("JUL Iantimestamp ")), FILTER (@RANGE (1, 8));# #结束 # #Edit params Rzg_cxi2# #开始 # #Replicat rzg_cxi2setenv (oracle_sid= "hasthxcx1") SETENV (Nls_lang=american_america. Al32utf8) Userid Ggs,password aacaaaaaaaaaaaiaucojgddfpfhegcpd, BLOWFISH, Encryptkey defaultreport at 01:59reportrollover at 02:00cachemgr, CACHESIZE 256MBREPERROR default,abenddiscardfile./dirrpt/rzg_cxi2.dsc,append, Megabytes 100DISCARDROLLOVER at 06:00gettruncatesnumfiles 3000EOFDELAYCSECS 30ASSUMETARGETDEFSALLOWNOOPUPDATESDYNAMICRESOLUTIONGETUPDATEBEFORESNOCOMPRESSDELETESMAP HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, TARGET HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, Colmap (usedefaults, & sjtb_sj = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("JUL Iantimestamp ")), FILTER (@RANGE (2, 8));# #结束 # #Edit params Rzg_cxi3# #开始 # #Replicat rzg_cxi3setenv (oracle_sid= "hasthxcx1") SETENV (Nls_lang=american_america. Al32utf8) Userid Ggs,password aacaaaaaaaaaaaiaucojgddfpfhegcpd, BLOWFISH, Encryptkey defaultreport at 01:59reportrollover at 02:00cachemgr, CACHESIZE 256MBREPERROR default,abenddiscardfile./dirrpt/rzg_cxi3.dsc,append, Megabytes 100DISCARDROLLOVER at 06:00gettruncatesnumfiles 3000EOFDELAYCSECS 30ASSUMETARGETDEFSALLOWNOOPUPDATESDYNAMICRESOLUTIONGETUPDATEBEFORESNOCOMPRESSDELETES MAP HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, TARGET HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, Colmap (usedefaults, & sjtb_sj = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("JUL Iantimestamp ")), FILTER (@RANGE (3, 8));# #结束 # #Edit params Rzg_cxi4# #开始 # #Replicat rzg_cxi4setenv (oracle_sid= "hasthxcx1") SETENV (Nls_lang=american_america. Al32utf8) Userid Ggs,password aacaaaaaaaaaaaiaucojgddfpfhegcpd, BLOWFISH, Encryptkey defaultreport at 01:59reportrollover at 02:00cachemgr, CACHESIZE 256MBREPERROR default,abenddiscardfile./dirrpt/rzg_cxi4.dsc,append, Megabytes 100DISCARDROLLOVER at 06:00gettruncatesnumfiles 3000EOFDELAYCSECS 30ASSUMETARGETDEFSALLOWNOOPUPDATESDYNAMICRESOLUTIONGETUPDATEBEFORESNOCOMPRESSDELETES MAP HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, TARGET HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, Colmap (usedefaults, &SJTB_SJ = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("Juliantimestamp")), FILTER (@RANGE (4, 8));# #结束 # #Edit params Rzg_cxi5# #开始 # #Replicat rzg_cxi5setenv (oracle_sid= "hasthxcx1") SETENV (Nls_lang=american_america. Al32utf8) Userid Ggs,password aacaaaaaaaaaaaiaucojgddfpfhegcpd, BLOWFISH, Encryptkey defaultreport at 01:59reportrollover at 02:00cachemgr, CACHESIZE 256MBREPERROR default,abenddiscardfile./dirrpt/rzg_cxi5.dsc,append, Megabytes 100DISCARDROLLOVER at 06:00gettruncatesnumfiles 3000EOFDELAYCSECS 30ASSUMETARGETDEFSALLOWNOOPUPDATESDYNAMICRESOLUTIONGETUPDATEBEFORESNOCOMPRESSDELETES MAP HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, TARGET HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, Colmap (usedefaults, & sjtb_sj = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("JUL Iantimestamp ")), FILTER (@RANGE (5, 8));# #结束 # #Edit params Rzg_cxi6# #开始 # #Replicat rzg_cxi6setenv (oracle_sid= "hasthxcx1") SETENV (Nls_lang=american_america. Al32utf8) Userid Ggs,password aacaaaaaaaaaaaiaucojgddfpfhegcpd, BLOWFISH, Encryptkey defaultreport at 01:59reportrollover at 02:00cachemgr, CACHESIZE 256MBREPERROR default,abenddiscardfile./dirrpt/rzg_cxi6.dsc,append, Megabytes 100DISCARDROLLOVER at 06:00gettruncatesnumfiles 3000EOFDELAYCSECS 30ASSUMETARGETDEFSALLOWNOOPUPDATESDYNAMICRESOLUTIONGETUPDATEBEFORESNOCOMPRESSDELETESMAP HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, TARGET HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, Colmap (usedefaults, &SJTB_SJ = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("Juliantimestamp")), FILTER (@RANGE (6, 8));# #结束 # #Edit params Rzg_cxi7# #开始 # #Replicat rzg_cxi7setenv (oracle_sid= "hasthxcx1") SETENV (Nls_lang=american_america. Al32utf8) Userid Ggs,password aacaaaaaaaaaaaiaucojgddfpfhegcpd, BLOWFISH, Encryptkey defaultreport at 01:59reportrollover at 02:00cachemgr, CACHESIZE 256MBREPERROR default,abenddiscardfile./dirrpt/rzg_cxi7.dsc,append, Megabytes 100DISCARDROLLOVER at 06:00gettruncatesnumfiles 3000EOFDELAYCSECS 30ASSUMETARGETDEFSALLOWNOOPUPDATESDYNAMICRESOLUTIONGETUPDATEBEFORESNOCOMPRESSDELETES MAP HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, TARGET HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, Colmap (usedefaults, & sjtb_sj = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("JUL Iantimestamp ")), FILTER (@RANGE (7, 8));# #结束 # #Edit params Rzg_cxi8# #开始 # #Replicat rzg_cxi8setenv (oracle_sid= "hasthxcx1") SETENV (Nls_lang=american_america. Al32utf8) Userid Ggs,password aacaaaaaaaaaaaiaucojgddfpfhegcpd, BLOWFISH, Encryptkey defaultreport at 01:59reportrollover at 02:00cachemgr, CACHESIZE 256MBREPERROR default,abenddiscardfile./dirrpt/rzg_cxi8.dsc,append, Megabytes 100DISCARDROLLOVER at 06:00gettruncatesnumfiles 3000EOFDELAYCSECS 30ASSUMETARGETDEFSALLOWNOOPUPDATESDYNAMICRESOLUTIONGETUPDATEBEFORESNOCOMPRESSDELETESMAP HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, TARGET HX_SB. SB_CWBB_XQYKJZZ_ZCFZB, Colmap (usedefaults, &SJTB_SJ = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("Juliantimestamp")), FILTER (@RANGE (8, 8));# #结束 # # 1, view the log sequence number and RBA ( note When adding a process change trail filename, log sequence number, RBA)After stop view info rzg_cx2i ggsci (hasthxcxdb01) 33> info rzg_cx2i replicat rzg_cx2i last Started 2016-06-02 11:39 St                     ATUs runningcheckpoint Lag 91:53:11 (updated 03:12:24 ago) Log Read Checkpoint File./dirdat/za003124 2016-05-30 19:43:03.015049 RBA 114276026 2, log in to the databaseDblogin Userid Ggs,password AACAAAAAAAAAAAIAUCOJGDDFPFHEGCPD, BLOWFISH, Encryptkey DEFAULT# #密文部分为OGG用户ggs的密码, also available in clear text 3., add process Rzg_cxiAbove has edited 8 process parameter files, here Add process Can $ ggsci add Replicat rzg_cxi1, Exttrail./dirdat/za add Replicat rzg_cxi2, Exttrail./dird at/za add Replicat rzg_cxi3, Exttrail./dirdat/za add Replicat rzg_cxi4, Exttrail./dirdat/za Add Replicat RZG_CXI5, Exttrail./dirdat/za add Replicat rzg_cxi6, Exttrail./dirdat/za add Replicat rzg_cxi7, Exttrail./dirdat/za Add re Plicat rzg_cxi8, Exttrail./dirdat/za 4. Modify the process checkpoint$ ggsci alter Replicat RZG_CXI1, Extseqno 3124, Extrba 114276026 alter Replicat RZG_CXI2, Extseqno 3124, Extrba 11427    6026 alter Replicat Rzg_cxi3, Extseqno 3124, Extrba 114276026 alter Replicat RZG_CXI4, Extseqno 3124, Extrba 114276026 Alter Replicat RZG_CXI5, Extseqno 3124, Extrba 114276026 alter Replicat Rzg_cxi6, Extseqno 3124, Extrba 114276026 A Lter replicat rzg_cxi7, extseqno 3124, Extrba 114276026 alter Replicat rzg_cxi8, Extseqno 3124, Extrba 114276026 5, start the new 8 processesStart rzg_cxi* 6, log in to the database again, delete the original processDblogin Userid Ggs,password AACAAAAAAAAAAAIAUCOJGDDFPFHEGCPD, BLOWFISH, Encryptkey DEFAULT Delete rzg_cx2i

Ogg process split (single table split into multiple processes)

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.