ogg操作手册Word格式文档下载.docx
- 文档编号:16845583
- 上传时间:2022-11-26
- 格式:DOCX
- 页数:4
- 大小:15.29KB
ogg操作手册Word格式文档下载.docx
《ogg操作手册Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《ogg操作手册Word格式文档下载.docx(4页珍藏版)》请在冰豆网上搜索。
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;
addextractExtract,tranlog,threads2,beginnow
addexttrail/ogg/dirdat/a5,extractExtract
创建Pump进程
editparamspump
extractpump
passthru
useridCAS_SGCIS,passwordSap12345
rmthost8333
rmttrail/ogg/dirdat/a5
addextractPump,exttrailsource/ogg/dirdat/a5
addrmttrail/ogg/dirdat/a5,extractPump
开启源端进程
GGSCI(rac1)3>
startmgr
startExtract
startPump
查看进程状态
GGSCI(rac1)4>
infoall
ProgramStatusGroupLagatChkptTimeSinceChkpt
MANAGERRUNNING
EXTRACTRUNNINGExtract00:
00:
0000:
07
EXTRACTRUNNINGPump00:
01
2.目标端ogg准备工作
磁盘使用情况
[root@node01~]#df-h
FilesystemSizeUsedAvailUse%Mountedon
/dev/sda3145G19G119G14%/
tmpfs980M457M69%/dev/shm
/dev/sda1291M39M238M14%/boot
创建用户并授权
mysql>
createuser'
dbscale'
@'
%'
identifiedby'
oracle'
;
QueryOK,0rowsaffectedsec)
grantALLPRIVILEGESon*.*to'
;
[root@node01~]#mkdir/ogg
[root@node01~]#..bash_profile
[root@node01~]#unzip
[root@node01~]#tar-xvf
GLOBALS
checkpointtable
addcheckpointtable
创建Manager进程
GGSCI>
editparamsmgr
PORT8333
DYNAMICPORTLIST8334-8999
--AUTOSTARTER*
AUTORESTARTEXTRACT*,RETRIES5,WAITMINUTES3
PURGEOLDEXTRACTS./dirdat/*,usecheckpoints,minkeepdays3
创建Replicat进程
GGSCI(node01)2>
editparamsreplicat
replicatreplicat
sourcedefs/ogg/dirdef/
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('
OPTYPE'
),'
DELETE'
D'
UPDATE'
@CASE(@GETENV('
BEFOREAFTERINDICATOR'
BEFORE'
AFTER'
I'
0),'
PKUPDATE'
INSERT'
SQLCOMPUPDATE'
0),0),informatica_ogg_seq=@COLSTAT(NULL));
addreplicatreplicat,exttrail/ogg/dirdat/a5,checkpointtable
开启目标端进程
startReplicat
查看目标端进程的状态
GGSCI(node01DBLOGINasdbscale)54>
REPLICATRUNNINGReplicat00:
02
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ogg 操作手册