GoldenGate软件升级步骤

1. OGG软件升级准备
1.1 备份OGG安装目录
tar cvf gg1101.tar gg/*
将新的软件解压到独立的目录
mkdir /u01/gg1102
tar xvf /tmp/fbo_ggs_Linux_x64_ora11g_64bit.tar -C /u01/gg1102
在BR模式下，确定最旧的归档日志
GGSCI > info all
GGSCI > info extract extora, showch

1.2 暂停所有的DDL，DML
暂停日志捕获
GGSCI > send extract extora logend
暂停EXTRACT进程
GGSCI > stop extora
暂停DDL捕获
$ sqlplus /nolog
@> connect sys/oracle_4U@orcl as sysdba
SYS@orcl> @ddl_disable
1.3 停止所有进程
检查REPLICAT检查状态，确认为AT EOF
GGSCI > send replicat repora status
Current status: At EOF
暂停REPLICAT进程
GGSCI > stop repora
暂停MGR进程
GGSCI > stop mgr

2. OGG软件升级
将新的软件覆盖原先目录
chmod -R 775 gg/*
cp -Rv gg1102/* gg/
升级Checkpoint table
GGSCI > view params ./GLOBALS
CHECKPOINTTABLE ggs.ggchkpts
GGSCHEMA ggs
GGSCI > DBLOGIN USERID ggs@sbdb password ggs
Successfully logged into database.
GGSCI > upgrade checkpointtable ggs.ggchkpts
Successfully upgraded checkpoint table ggs.ggchkpts.

3. OGG软件升级后配置
3.1 OGG软件升级DDL捕获清除
@ddl_remove
ggs
ddl_remove_spool.txt
@marker_remove
ggs
marker_remove_spool.txt

3.2 OGG软件升级supplemental log

@ulg.sql
This script. converts the existing supplemental log groups to the new format that is required for version 11.2.1.
---- Upgrade completed successfully.

3.3 OGG软件升级重新定位trail文件

升级后会改变trail文件的格式，所以要对trail文件重新定位
GGSCI > alter extract extora etrollover
GGSCI > info extract extora, detail

GGSCI > alter replicat repora, extseqno 9, extrba 0

3.4 OGG软件升级DDL重建

@marker_setup
@ddl_setup
@role_setup
@ddl_enable.sql

4. OGG软件升级启动进程
GGSCI > start mgr
GGSCI > start extora
GGSCI > start repora
GGSCI > info all

5. OGG升级后校验
DML
SCOTT@orcl> insert into TCUSTMER
values ('BBB','BBB CCC','SEATTLE','WA');
DDL
SCOTT@orcl> drop table emp2;

6. OGG升级注意事项

下载合适的软件
备份当前使用的软件
检查BR中最旧的日志
预留维护时间窗口
DDL清除和开启的顺序

7. 参考文档

SR ： 3-6329765821
Doc： Upgrade Instructions

ITPub博客

GoldenGate软件升级步骤

最新文章