OGG拆分程式

1.檢視延時程式佇列資訊
GGSCI (gdsthxcxdb01) 3> info Rep2


REPLICAT   Rep2  Last Started 2015-01-22 00:50   Status RUNNING
Checkpoint Lag       01:13:01 (updated 00:00:01 ago)
Log Read Checkpoint  File ./dirdat/za001758
                     2015-01-23 10:58:06.053631  RBA 328742766


2.KILL 延時程式，引數檔案新增排除表
GGSCI (gdsthxcxdb01) 4> kill Rep2    


Sending KILL request to MANAGER ...
Killed process (44761796) for REPLICAT Rep2       
                     
GGSCI (gdsthxcxdb01) 5> edit param Rep2


MAPEXCLUDE HR.HR_CWBB_XQYKJZZ;
MAPEXCLUDE HR.HR_CWBB_XQYKJZZ_LRB;
MAPEXCLUDE HR.HR_CWBB_XQYKJZZ_XJLLB;




3.正常啟動延時程式




4.新增延時大表新程式,先開啟handlecollisions 引數，待新程式延時追平後重啟程式刪除此引數


GGSCI (gdsthxcxdb01) 10> dblogin Userid ggs,PASSWORD ggs


GGSCI (gdsthxcxdb01) 11> add replicat Rep3,exttrail ./dirdat/za, checkpointtable ggs.checkpoint


GGSCI (gdsthxcxdb01) 12> edit param Rep3


replicat Rep3
SETENV (ORACLE_SID="orcl")
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
Userid ggs,PASSWORD ggs
REPORT AT 01:59
REPORTROLLOVER AT 02:00
CACHEMGR, CACHESIZE 256MB
REPERROR DEFAULT,ABEND
DISCARDFILE ./dirrpt/Rep3.dsc,APPEND,MEGABYTES 100
DISCARDROLLOVER AT 06:00
GETTRUNCATES
NUMFILES 3000
EOFDELAYCSECS 30
ASSUMETARGETDEFS
ALLOWNOOPUPDATES
DYNAMICRESOLUTION
GETUPDATEBEFORES
NOCOMPRESSDELETES
handlecollisions


MAP HR.HR_CWBB_XQYKJZZ, TARGETHR.HR_CWBB_XQYKJZZ;
MAP HR.HR_CWBB_XQYKJZZ_LRB, TARGET HR.HR_CWBB_XQYKJZZ_LRB;
MAP HR.HR_CWBB_XQYKJZZ_XJLLB, TARGETHR.HR_CWBB_XQYKJZZ_XJLLB;




5.修改大表新程式佇列檔案號至原延時程式後，正常啟動程式
alter Rep3, EXTSEQNO 1758,extrba 328742766




GGSCI (gdsthxcxdb01) 19> start Rep3