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)
