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 as sysdba
> @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 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
> insert into TCUSTMER
values ('BBB','BBB CCC','SEATTLE','WA');
DDL
> drop table emp2;

6. OGG升級注意事項

下載合適的軟體
備份當前使用的軟體
檢查BR中最舊的日誌
預留維護時間視窗
DDL清除和開啟的順序

7. 參考文件

SR ： 3-6329765821
Doc： Upgrade Instructions

GoldenGate軟體升級步驟

相關文章