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 R e p3


replicat R e p3
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/ R e p3.dsc,APPEND,MEGABYTES 100
DISCARDROLLOVER AT 06:00
GETTRUNCATES
NUMFILES 3000
EOFDELAYCSECS 30
ASSUMETARGETDEFS
ALLOWNOOPUPDATES
DYNAMICRESOLUTION
GETUPDATEBEFORES
NOCOMPRESSDELETES
handlecollisions


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




5.修改大表新进程队列文件号至原延时进程后，正常启动进程
alter R e p3, EXTSEQNO 1758,extrba 328742766




GGSCI (gdsthxcxdb01) 19> start R e p3

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29863023/viewspace-1472463/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29863023/viewspace-1472463/