Upgrade Goldengate 11.1.1.1.2 to 11.2.1.0.1

配置环境:Source:OGG:11.2.1.0.1Name:zbdba1Target:OGG:11.1.1.1.2Name:zbdba2现在将Target升级到与源端一样的版本备份Target ogg安装目录:[root@zbdba2 /]# cp -R ogg/ /database/

查看Source端抽取进程是否active:

GGSCI (zbdba1) 6> send extract ext1 logendSending LOGEND request to EXTRACT EXT1 …YES.GGSCI (zbdba1) 7> send extract ext2 logendSending LOGEND request to EXTRACT EXT2 …YES.发现没有抽取和传输数据,,可以停止进程查看Target端复制进行是否active:

GGSCI (zbdba2) 2> send replicat rep1 statusSending STATUS request to REPLICAT REP1 … Current status: At EOF Sequence #: 3 RBA: 2434 0 records in current transaction停止所有进程:

Source:GGSCI (zbdba1) 13> info allProgramStatusGroupLag at Chkpt Time Since ChkptMANAGERSTOPPEDEXTRACTSTOPPEDEXT100:00:0000:01:35 EXTRACTSTOPPEDEXT200:00:0000:01:32 Target:GGSCI (zbdba2) 6> info allProgramStatusGroupLagTime Since ChkptMANAGERSTOPPEDREPLICAT STOPPEDREP100:00:0000:01:26 Target:删除以前ogg安装目录中的内容,将新版本的ogg解压在里面

[ogg@zbdba2 ogg]$ ./ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.GGSCI (zbdba2) 1> info allProgramStatusGroupLag at Chkpt Time Since ChkptMANAGERSTOPPEDGGSCI (zbdba2) 2> dblogin userid ogg,password ogg;Successfully logged into database.GGSCI (zbdba2) 3> upgrade checkpointtable ogg.checkpointSuccessfully upgraded checkpoint table ogg.checkpoint.在target数据库中:

Installing the DDL objects:1、Run the @marker_setup.sql script. This script installs support for the Oracle GoldenGatemarker system, which is required for DDL support. You will be prompted for the nameof the Oracle GoldenGate schema.drop trigger ggs_ddl_trigger_before;grant create table,create view,create sequence to ogg;2、Run the @ddl_setup.sql script Script that installs the Oracle GoldenGate DDL extraction andreplication objects. (Oracle installations)3、Run the @role_setup.sql script. This script drops and creates the role needed for DDLsynchronization. It grants DML permissions on the Oracle GoldenGate DDL objects4、Grant the role to all Oracle GoldenGate Extract users. You may need to make multiplegrants if the processes have different user names.Run the @ddl_enable.sql script to enable the DDL trigger.5、To improve the performance of the DDL trigger, make the ddl_pin script part of the databasestartup. It must be invoked with the Oracle GoldenGate DDL user name, as in:@?/rdbms/admin/dbmspool.sqlSQL> @ddl_pin oggTo improve the performance of the DDL trigger This script pins the PL/SQL package that is used by the trigger into memory. If executingthis script from SQL*Plus, connect as SYSDBA from the Oracle GoldenGate home directory.This script relies on the Oracle dmbs_shared_pool system package, so install that packagebefore using ddl_pin.配置Target:

view param mgrport 7839DYNAMICPORTLIST 7840-7914USERID ogg,PASSWORD oggAUTORESTART REPLICAT *,RETRIES 5,WAITMINUTES 3PURGEOLDEXTRACTS ./DIRDAT/*,MINKEEPDAYS 3PURGEDDLHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10,FREQUENCYMINUTES 30PURGEMARKERHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10LAGREPORTHOURS 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45GGSCI (zbdba2) 1> create subdirsGGSCI (zbdba2) 1> view param ./GLOBALSGGSCHEMA oggCHECKPOINTTABLE ogg.checkpointGGSCI (zbdba2) 2> add replicat rep1,exttrail /ogg/dirdat/sa, checkpointtable ogg.checkpointGGSCI (zbdba2) 19> edit param rep1REPLICAT rep1ASSUMETARGETDEFSUSERID ogg, PASSWORD oggdiscardfile ./dirdat/rep1_discard.txt,append,megabytes 5DDL INCLUDE MAPPEDDDLOPTIONS REPORT–BATCHSQLDBOPTIONS DEFERREFCONSTDBOPTIONS LOBWRITESIZE 102400HANDLECOLLISIONSDDLERROR DEFAULT DISCARD RETRYOP MAXRETRIES 5 RETRYDELAY 20–grouptransops 1–maxtransops 1APPLYNOOPUPDATESMAP zbdba.*, TARGET zbdba.*;Source:将版本控制参数 format release去掉

GGSCI (zbdba1) 44> view param ext1EXTRACT EXT1setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )USERID ogg,PASSWORD oggDDL &INCLUDE MAPPED OBJTYPE 'TABLE' &INCLUDE MAPPED OBJTYPE 'IDNEX' &INCLUDE MAPPED OBJTYPE 'SEQUENCE' &INCLUDE MAPPED OBJTYPE 'VIEW' &INCLUDE MAPPED OBJTYPE 'PROCEDURE' &INCLUDE MAPPED OBJTYPE 'FUNCTION' &INCLUDE MAPPED OBJTYPE 'PACKAGE' &INCLUDE MAPPED OBJTYPE 'MATERIALIZED VIEW' &EXCLUDE OPTYPE COMMENTDDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORTREPORTCOUNT EVERY 1 MINUTES,RATEDISCARDFILE ./dirrpt/EXTSA.DSC,APPEND,MEGABYTES 1024THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000 IOLATENCY 60000DBOPTIONS ALLOWUNUSEDCOLUMNWARNLONGTRANS 2H,CHECKINTERVAL 3M–exttrail ./dirdat/sa,format release 11.1exttrail ./dirdat/saFETCHOPTIONS NOUSESNAPSHOT,FETCHPKUPDATECOLS,MISSINGROW REPORTtable zbdba.*;GGSCI (zbdba1) 45> view param ext2EXTRACT EXT2passthruRMTHOST 192.168.56.61,MGRPORT 7839,COMPRESS–RMTTRAIL ./dirdat/sa,format release 11.1RMTTRAIL ./dirdat/satable zbdba.*;因为版本问题,以前trail文件将不可用,迫使抽取进程写一个新的trail文件:

勇士面前无险路。

Upgrade Goldengate 11.1.1.1.2 to 11.2.1.0.1

相关文章:

你感兴趣的文章:

标签云: