Oracle GoldenGate 18c升級
發(fā)布于：2021-02-04 14:10:20
本說明概述了將GoldenGate 12.3升級到最新18c版本（18.1.0.0.0）所遵循的步驟。
注意：
如果要從Oracle GoldenGate 11.2.1.0.0或更早版本升級，還需要通過GGSCI命令upgrade checkpoint table升級Replicat checkpoint表[所有者表]
如果我們使用基于觸發(fā)器的DDL復(fù)制支持，然后需要執(zhí)行其他步驟，這些步驟在下面的URL中概述的GoldenGate升級文檔中有更詳細(xì)的描述：https://docs.oracle.com/en/middleware/goldengate/core/18.1/upgrade/upgrading-release-oracle-database.html#GUID-9B490BE5-F0AE-44D1-B63C-F5299B9DFD16
在本例中，源數(shù)據(jù)庫版本高于11.2.0.4，我們使用集成的Extract，其中DDL捕獲支持集成到數(shù)據(jù)庫日志挖掘服務(wù)器中。
確認(rèn)沒有未結(jié)和未提交的交易。
GGSCI (rac01.localdomain) 2> send ext1 showtrans
Sending SHOWTRANS request to EXTRACT EXT1 ...
No transactions found.
GGSCI (rac01.localdomain) 3> send ext1 logend
Sending LOGEND request to EXTRACT EXT1 ...
YES
停止提?。ê统樗?。
GGSCI (rac01.localdomain) 5> stop extract *
Sending STOP request to EXTRACT EXT1 ...
Request processed.
Sending STOP request to EXTRACT PUMP1 ...
Request processed.
在停止Replicat之前，請確保Replicat已處理完Oracle GoldenGate跟蹤中的所有當(dāng)前DML和DDL數(shù)據(jù)。
發(fā)出帶有STATUS選項的SEND REPLICAT命令，直到它返回“At EOF”狀態(tài)，表示它已完成對trail文件中所有數(shù)據(jù)的處理。
GGSCI (rac01.localdomain) 4> send rep1 status
Sending STATUS request to REPLICAT REP1 ...
Current status: At EOF
Sequence #: 2
RBA: 1,538
0 records in current transaction.
GGSCI (rac01.localdomain) 6> stop replicat *
Sending STOP request to REPLICAT REP1 ...
Request processed.
停止管理器進程。
GGSCI (rac01.localdomain) 7> stop mgr !
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
備份源系統(tǒng)和目標(biāo)系統(tǒng)上的當(dāng)前Oracle GoldenGate安裝目錄，以及為共享文件系統(tǒng)（例如dirprm，dircrd，dirchk，BR，dirwlt，dirrpt等）上的集群配置安裝的所有工作目錄。
我們不需要備份包含跟蹤文件的dirdat文件夾。
建議同時升級源環(huán)境和目標(biāo)Oracle GoldenGate環(huán)境。
如果我們不是在升級源系統(tǒng)的同時升級目標(biāo)系統(tǒng)上的Replicat，請將以下參數(shù)添加到提取參數(shù)文件中，以指定在目標(biāo)系統(tǒng)上運行的Oracle GoldenGate的版本。
此參數(shù)導(dǎo)致Extract寫入與舊版本的Replicat兼容的trail版本。
{EXTTRAIL | RMTTRAIL} file_name FORMAT RELEASE major.minor
例如：
EXTTRAIL ./dirdat/lt FORMAT RELEASE 12.3
在源和目標(biāo)Goldengate環(huán)境上，都使用Oracle Universal Installer（OUI）將Oracle GoldenGate 18c（18.1.0）安裝到現(xiàn)有的Oracle GoldenGate目錄中。
注意：確保啟動管理器的復(fù)選框沒有勾選。
[oracle@rac01 sf_software]$ cd 181000_fbo_ggs_Linux_x64_shiphome
[oracle@rac01 181000_fbo_ggs_Linux_x64_shiphome]$ cd fbo_ggs_Linux_x64_shiphome/
[oracle@rac01 fbo_ggs_Linux_x64_shiphome]$ cd Disk1
oracle@rac01 Disk1]$ ./runInstaller
將GoldenGate軟件根目錄中的ulg.sql腳本作為SYSDBA執(zhí)行。該腳本將現(xiàn)有的補充日志組轉(zhuǎn)換為新版本要求的格式。
[oracle@rac01 goldengate]$ sqlplus sys as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 8 11:26:34 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> @ulg.sql
Oracle GoldenGate supplemental log groups upgrade script.
Please do not execute any DDL while this script is running. Press ENTER to continue.
PL/SQL procedure successfully completed.
安裝/升級完成后，通過etrolover命令更改主提取過程以及相關(guān)的數(shù)據(jù)泵提取過程，以寫入新的跟蹤序列號。
重新定位現(xiàn)有的提取泵和Replicat進程，以開始讀取和處理新的trail文件。
[oracle@rac01 goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Sep 29 2018 04:22:21
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.
GGSCI (rac01.localdomain) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED EXT1 00:00:00 01:13:55
EXTRACT STOPPED PUMP1 00:00:00 01:13:55
GGSCI (rac01.localdomain) 2> alter extract ext1 etrollover
2019-01-08 00:44:13 INFO OGG-01520 Rollover performed. For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically.
EXTRACT altered.
GGSCI (rac01.localdomain) 3> alter extract pump1 etrollover
2019-01-08 00:44:51 INFO OGG-01520 Rollover performed. For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically.
EXTRACT altered.
GGSCI (rac01.localdomain) 4> info ext1 detail
EXTRACT EXT1 Initialized 2019-01-07 14:36 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:53 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2019-01-07 23:29:38
SCN 0.3272690 (3272690)
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/ogg1/lt 3 0 500 EXTTRAIL
GGSCI (rac01.localdomain) 5> alter pump1 extseqno 3 extrba 0
EXTRACT altered.
GGSCI (rac01.localdomain) 6> info pump1 detail
EXTRACT PUMP1 Initialized 2019-01-08 00:45 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint File /acfs_oh/app/goldengate/dirdat/ogg1/lt000000003
First Record RBA 0
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/ogg2/rt 3 0 500 RMTTRAIL
GGSCI (rac01.localdomain) 7> alter rep1 extseqno 3 extrba 0
2019-01-08 00:46:08 INFO OGG-06594 Replicat REP1 has been altered. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start REP1 with NOFILTERDUPTRANSACTIONS option.
REPLICAT (Integrated) altered.
在新的GoldenGate 18c環(huán)境中啟動所有GoldenGate流程
GGSCI (rac01.localdomain) 8> start mgr
Manager started.
GGSCI (rac01.localdomain) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:02:06
EXTRACT STARTING PUMP1 00:00:00 00:00:50
REPLICAT STARTING REP1 00:00:00 00:00:11
GGSCI (rac01.localdomain) 10>
GGSCI (rac01.localdomain) 10> !
info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:06
EXTRACT RUNNING PUMP1 00:00:00 00:00:07
REPLICAT RUNNING REP1 00:00:00 00:00:03
