ogg操作手册.docx

1、ogg操作手册ogg操作手册版本：1. 源端库准备工作oraclerac1 $ps -ef|grep ogg|grep -v grepash_profileexport OGG_HOME=/oggoraclerac1 $. .bash_profile上传ogg软件到相关目录oraclerac1 ogg$ unzip oraclerac1 ogg$ tar -xvf ggsciGGSCI (rac1) 1 create subdirsdefgen paramfile ./dirprm/dirdat/*,usecheckpoints, minkeepdays 3LAGREPORTHOURS 1LA

2、GINFOMINUTES 30LAGCRITICALMINUTES 45创建Extract进程GGSCI (rac1) 2 edit params extractextract extractGETTRUNCATESGETUPDATEBEFORESFETCHOPTIONS FETCHPKUPDATECOLSdynamicresolutionuserid CAS_SGCIS,password Sap12345 TRANLOGOPTIONS ASMUSER sysasm, ASMPASSWORD oracleexttrail /ogg/dirdat/a5table ;GGSCI (rac1) 2

3、add extract Extract,tranlog,threads 2,begin nowGGSCI (rac1) 2 add exttrail /ogg/dirdat/a5,extract Extract创建Pump进程GGSCI (rac1) 2 edit params pumpextract pumppassthrudynamicresolutionuserid CAS_SGCIS,password Sap12345rmthost 8333rmttrail /ogg/dirdat/a5table ;GGSCI (rac1) 2 add extract Pump,exttrailsou

4、rce /ogg/dirdat/a5GGSCI (rac1) 2 add rmttrail /ogg/dirdat/a5,extract Pump开启源端进程GGSCI (rac1) 3start mgrGGSCI (rac1) 3start ExtractGGSCI (rac1) 3start Pump查看进程状态GGSCI (rac1) 4 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING EXTRACT RUNNING Extract 00:00:00 00:00:07 EXTRACT RU

5、NNING Pump 00:00:00 00:00:01 2. 目标端ogg准备工作磁盘使用情况rootnode01 # df -hFilesystem Size Used Avail Use% Mounted on/dev/sda3 145G 19G 119G 14% /tmpfs 980M 457M 69% /dev/shm/dev/sda1 291M 39M 238M 14% /boot创建用户并授权mysql create user dbscale% identified by oracle;Query OK, 0 rows affected sec)mysql grant ALL P

6、RIVILEGES on *.* to dbscale% ;Query OK, 0 rows affected sec) rootnode01 # mkdir /oggash_profileexport OGG_HOME=/oggrootnode01 #. .bash_profile上传ogg软件到相关目录rootnode01 # unzip rootnode01 # tar -xvf ggsciGGSCI (rac1) 1 create subdirsGLOBALScheckpointtable GGSCI (rac1) 1add checkpointtable 创建Manager进程GGS

7、CIedit params mgrPORT 8333 DYNAMICPORTLIST 8334-8999-AUTOSTART ER *AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 3LAGREPORTHOURS 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45创建Replicat进程GGSCI (node01) 2edit params replicatreplicat replicatsourcedefs /

8、ogg/dirdef/GETTRUNCATESapplynoopupdatesdboptions nolimitrowsINSERTUPDATESINSERTDELETESINSERTALLRECORDSREPERROR (DEFAULT, ABEND)TARGETDB:23306,userid dbscale,password oracleMap ,target ,colmap(usedefaults,informatica_row_id=GETENV(RECORD,ROWID),informatica_date_time=GETENV (GGHEADER, COMMITTIMESTAMP)

9、,informatica_flag=CASE(GETENV(GGHEADER,OPTYPE),DELETE,D,UPDATE,CASE(GETENV(GGHEADER,BEFOREAFTERINDICATOR),BEFORE,D,AFTER,I,0),PK UPDATE,CASE(GETENV(GGHEADER,BEFOREAFTERINDICATOR),BEFORE,D,AFTER,I,0),INSERT,I,SQL COMPUPDATE,CASE(GETENV(GGHEADER,BEFOREAFTERINDICATOR),BEFORE,D,AFTER,I,0),0),informatica

10、_ogg_seq=COLSTAT(NULL); GGSCI (node01) 2add replicat replicat,exttrail /ogg/dirdat/a5,checkpointtable 开启目标端进程GGSCI (node01) 2start mgrGGSCI (node01) 2start Replicat查看目标端进程的状态GGSCI (node01 DBLOGIN as dbscale) 54 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING REPLICAT RUNNING Replicat 00:00:00 00:00:02