ogg操作手册.docx
《ogg操作手册.docx》由会员分享，可在线阅读，更多相关《ogg操作手册.docx（4页珍藏版）》请在冰豆网上搜索。
ogg操作手册
ogg操作手册
版本：
1.源端库准备工作
[oracle@rac1~]$ps-ef|grepogg|grep-vgrep
ash_profile
exportOGG_HOME=/ogg
[oracle@rac1~]$..bash_profile
上传ogg软件到相关目录
[oracle@rac1ogg]$unzip
[oracle@rac1ogg]$tar-xvf
ggsci
GGSCI（rac1）1>createsubdirs
defgenparamfile./dirprm/
dirdat/*,usecheckpoints,minkeepdays3
LAGREPORTHOURS1
LAGINFOMINUTES30
LAGCRITICALMINUTES45
创建Extract进程
GGSCI（rac1）2>editparamsextract
extractextract
GETTRUNCATES
GETUPDATEBEFORES
FETCHOPTIONSFETCHPKUPDATECOLS
dynamicresolution
useridCAS_SGCIS,passwordSap12345
TRANLOGOPTIONSASMUSERsys@asm,ASMPASSWORDoracle
exttrail/ogg/dirdat/a5
table;
GGSCI（rac1）2>addextractExtract,tranlog,threads2,beginnow
GGSCI（rac1）2>addexttrail/ogg/dirdat/a5,extractExtract
创建Pump进程
GGSCI（rac1）2>editparamspump
extractpump
passthru
dynamicresolution
useridCAS_SGCIS,passwordSap12345
rmthost8333
rmttrail/ogg/dirdat/a5
table;
GGSCI（rac1）2>addextractPump,exttrailsource/ogg/dirdat/a5
GGSCI（rac1）2>addrmttrail/ogg/dirdat/a5,extractPump
开启源端进程
GGSCI（rac1）3>startmgr
GGSCI（rac1）3>startExtract
GGSCI（rac1）3>startPump
查看进程状态
GGSCI（rac1）4>infoall
ProgramStatusGroupLagatChkptTimeSinceChkpt
MANAGERRUNNING
EXTRACTRUNNINGExtract00:
00:
0000:
00:
07
EXTRACTRUNNINGPump00:
00:
0000:
00:
01
2.目标端ogg准备工作
磁盘使用情况
[root@node01~]#df-h
FilesystemSizeUsedAvailUse%Mountedon
/dev/sda3145G19G119G14%/
tmpfs980M457M69%/dev/shm
/dev/sda1291M39M238M14%/boot
创建用户并授权
mysql>createuser'dbscale'@'%'identifiedby'oracle';
QueryOK,0rowsaffectedsec）
mysql>grantALLPRIVILEGESon*.*to'dbscale'@'%';
QueryOK,0rowsaffectedsec）
[root@node01~]#mkdir/ogg
ash_profile
exportOGG_HOME=/ogg
[root@node01~]#..bash_profile
上传ogg软件到相关目录
[root@node01~]#unzip
[root@node01~]#tar-xvf
ggsci
GGSCI（rac1）1>createsubdirs
GLOBALS
checkpointtable
GGSCI（rac1）1>addcheckpointtable
创建Manager进程
GGSCI>editparamsmgr
PORT8333
DYNAMICPORTLIST8334-8999
--AUTOSTARTER*
AUTORESTARTEXTRACT*,RETRIES5,WAITMINUTES3
PURGEOLDEXTRACTS./dirdat/*,usecheckpoints,minkeepdays3
LAGREPORTHOURS1
LAGINFOMINUTES30
LAGCRITICALMINUTES45
创建Replicat进程
GGSCI（node01）2>editparamsreplicat
replicatreplicat
sourcedefs/ogg/dirdef/
GETTRUNCATES
applynoopupdates
dboptionsnolimitrows
INSERTUPDATES
INSERTDELETES
INSERTALLRECORDS
REPERROR（DEFAULT,ABEND）
TARGETDB:
23306,useriddbscale,passwordoracle
Map,target,colmap（usedefaults,informatica_row_id=@GETENV（'RECORD','ROWID'）,informatica_date_time=@GETENV（'GGHEADER','COMMITTIMESTAMP'）,informatica_flag=@CASE（@GETENV（'GGHEADER','OPTYPE'）,'DELETE','D','UPDATE',@CASE（@GETENV（'GGHEADER','BEFOREAFTERINDICATOR'）,'BEFORE','D','AFTER','I',0）,'PKUPDATE',@CASE（@GETENV（'GGHEADER','BEFOREAFTERINDICATOR'）,'BEFORE','D','AFTER','I',0）,'INSERT','I','SQLCOMPUPDATE',@CASE（@GETENV（'GGHEADER','BEFOREAFTERINDICATOR'）,'BEFORE','D','AFTER','I',0）,0）,informatica_ogg_seq=@COLSTAT（NULL））;
GGSCI（node01）2>addreplicatreplicat,exttrail/ogg/dirdat/a5,checkpointtable
开启目标端进程
GGSCI（node01）2>startmgr
GGSCI（node01）2>startReplicat
查看目标端进程的状态
GGSCI（node01DBLOGINasdbscale）54>infoall
ProgramStatusGroupLagatChkptTimeSinceChkpt
MANAGERRUNNING
REPLICATRUNNINGReplicat00:
00:
0000:
00:
02
升级会员 