Original: Goldengate upgrade from 11.2 to 12.1.2

Goldengate upgrade from 11.2 to 12.1.2

1. Stop the extraction process

Ggsci (001.oracle.drs.dc.com) 286> stop EXTSJ01

2. Stop the post and copy process

Wait for the delivery process to finish transferring and the copy process has finished loading. When the write Checkpoint of the delivery process is the same as the sequence and RBA of the current Checkpoint, the synchronization is complete.

2.1 Check the delivery process:

Ggsci (001.oracle.drs.dc.com) 202> info puptdb2p,showch EXTRACT puptdb2p last Started 2016-05-04 20:32 Status STOPPED Checkpoint Lag 00:00:00 (updated 01:12:12 ago) Log Read Checkpoint File./dirdat/exttrdbk/ex000006 First Record RBA 1151 Current Checkpoint Detail: Read Checkpoint #1 GGS Log Trail Startup Checkpoint (starting position in the data source): Sequence #: 6 rba:1151 timestamp:2016-04-29 14:40:29.589038 Extract Trail:./dirdat/exttrdbk/ex Current Checkpoint (position of last record, read in the data source): Sequence #: 6 rba:1151 Timestamp:not Available Extract Trail:./dirdat/exttrdbk/ex Write Checkpoint #1 GGS Log Trail Current Checkpoint (current write position): Sequence #: 7 rba:1183 timestamp:2016-05-04 20:35:56.803177 Extract Trail:/home/ggt/goldengate/dirdat/reptdb2p/re Trail Type:exttrail

2.2 Checking the replication process

Ggsci (001.oracle.drs.dc.com) 209> info reptdb2p,showch Replicat reptdb2p last Started 2016-05-04 20:32 Status STOPPED Checkpoint Lag 00:00:00 (updated 01:14:28 ago) Log Read Checkpoint File./dirdat/reptdb2p/re000007 2016-05-04 20:32:43.741679 RBA 1183 Current Checkpoint Detail: Read Checkpoint #1 GGS Log Trail Startup Checkpoint (starting position in the data source): Sequence #: 6 rba:1246 timestamp:2016-04-29 14:40:29.589110 Extract Trail:./dirdat/reptdb2p/re Current Checkpoint (position of last record, read in the data source): Sequence #: 7 rba:1183 Timestamp: 2016-05-04 20:32:43.741679 Extract Trail:./dirdat/reptdb2p/re

2.3 Stopping the delivery process and the replication process

Ggsci (001.oracle.drs.dc.com) 209> STOP puptdb2p Ggsci (001.oracle.drs.dc.com) 210> STOP reptdb2p

3. Stop the management process

Ggsci (001.oracle.drs.dc.com) 210> STOP Mgr

4. Back up the original goldengate

[Email protected] ~]$ MV Goldengate goldengate11.2

5. Installing Goldengate 12.1

[Email protected] ~]$ Unzip 121200_fbo_ggs_linux_x64_shiphome.zip [Email protected] ~]$ CD Fbo_ggs_linux_x64_shiphome/disk1 [Email protected] ~]$./runinstaller

Select the database version, mine is Oracle 11G

Select Installation Location: Specify the location to the original version; Select whether to start the management process automatically

6. Check installation validity

[Email protected] goldengate]$./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.1.2.0.0 17185003 Oggcore_12.1.2.0.0_platforms_130924.1316_fbo Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2013 00:31:13 Operating system Character set identified as UTF-8. Copyright (C) 1995, Oracle and/or its affiliates. All rights reserved.

7. Copy the original version of the relevant directory to the new version

[Email protected] goldengate]$ Cp-r/home/ggt/goldengate11.2/dirchk/. Cp-r/home/ggt/goldengate11.2/dirdat/. Cp-r/home/ggt/goldengate11.2/dirdef/. Cp-r/home/ggt/goldengate11.2/dirpcs/. Cp-r/home/ggt/goldengate11.2/dirprm/. Cp-r/home/ggt/goldengate11.2/dirrpt/. Cp-r/home/ggt/goldengate11.2/dirsql/. Cp-r/home/ggt/goldengate11.2/dirtmp/. Cp-r/home/ggt/goldengate11.2/br/.

8. Checkpointtable of the upgrade replication process

Ggsci (001.oracle.drs.dc.com) 20> dblogin userid [email  PROTECTED]_KX, password  pwd Successfully logged into database. Ggsci (001.oracle.drs.dc.com) 22> upgrade checkpointtable chk_mpayb2p   Successfully upgraded checkpoint table chk_mpayb2p.   Note: This step must be done, otherwise the following error is reported: 2016-05-05 16:31:56  error   ogg-00868  OCI ERROR ORA-00904: " LOG_BSN ": invalid identifier (status = 904). Updating checkpoint table Chk_mpay b2p, group repmpb2p, Key 169,822,320 (0x000000000a1f4870), SQL < UPDATE chk_mpayb2p SET last_update_ts = sysdate, seqno =: seqno, RBA =: RBA, Audit_ts =: audit_ts, LOG_BSN =: log_bs N, LOG_CSN =: LOG_CSN, Log_xid =: Log_xid, LOG_CMPLT_CSN =: LOG_CMPLT_CSN, Log_cmplt_xids =: log_cmplt _xids, Versio n =: Version WHERE group_name =: group_name and group_key  =: key>.

9. Start the management process

Ggsci (001.oracle.drs.dc.com) 23>start Mgr

10. Start the extraction process

Note: Before starting, to modify the format of the trail file or to roll the trail's ordinal number forward one sequence number, otherwise the following error will be reported:

ERROR OGG-01416 File./dirdat/lt000005, with Format RELEASE 11.2, does not match current format specification of Releas E 12.1. Modify the parameter file to specify format RELEASE 11.2 or issue etrollover prior to restart.

Method One: Change the format of the trail file: Open the parameter file, add format RELEASE 11.2 after Exttrail./dirdat/sj01/ex

Ggsci (001.oracle.drs.dc.com) 23>edit params extsj01 Modify Exttrail./dirdat/sj01/ex to Exttrail./dirdat/sj01/ex, FORMAT RELEASE 11.2

Method Two: The trail's ordinal is rolled forward one ordinal

Ggsci (001.oracle.drs.dc.com) 262> alter Extsj01,etrollover 2016-05-05 10:14:51 INFO OGG-01520 Rollover performed. For each affected output trail of Version 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 would not happen automatically. EXTRACT altered.

Start the extraction process

Ggsci (001.oracle.drs.dc.com) 262>start extsj01

11. Start the delivery process

If you use method one in the 10th step, you can start the delivery process and the replication process directly, if you must do the following actions with method two

11.1 Record the read and write checkpoints of the delivery process

Ggsci (001.oracle.drs.dc.com) 258> info pupmpbk2,showch EXTRACT PUPMPBK2 last Started 2016-05-05 10:01 Status abended Checkpoint Lag 00:44:46 (updated 00:00:21 ago) Log Read Checkpoint file/home/ggt/goldengate/dirdat/sj01/ex194468 2016-05-05 09:16:27.000000 RBA 2244115 Current Checkpoint Detail: Read Checkpoint #1 GGS Log Trail Startup Checkpoint (starting position in the data source): Sequence #: 194468 rba:2244115 Timestamp:2016-05-05 09:16:27.000000 Extract Trail:/home/ggt/goldengate/dirdat/sj01/ex Current Checkpoint (position of last record, read in the data source): Sequence #: 194468 rba:2244115 Timestamp:2016-05-05 09:16:27.000000 Extract Trail:/home/ggt/goldengate/dirdat/sj01/ex Write Checkpoint #1 GGS Log Trail Current Checkpoint (current write position): Sequence #: 6184 rba:36936583 Timestamp:2016-05-05 09:16:30.784940 Extract Trail:/home/ggt/goldengate/dirdat/repmpaybak/re Trail Type:rmttrail Header: Version = 2 Record Source = A Type = 1 # Input checkpoints = 1 # Output checkpoints = 1 File Information: Block Size = 2048 Max Blocks = 100 Record Length = 2048 Current Offset = 0 Configuration: Data Source = 0 Transaction Integrity = 1 Task Type = 0 Status: Start time = 2016-05-05 10:01:08 Last Update time = 2016-05-05 10:01:13 Stop Status = A Last Result = 0

11.2 Modifying read Checkpoint and write Checkpoint

Ggsci (001.oracle.drs.dc.com) 262> alter Pupmpbk2,etrollover 2016-05-05 10:14:51 INFO OGG-01520 Rollover performed. For each affected output trail of Version 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 would not happen automatically. EXTRACT altered. Ggsci (001.oracle.drs.dc.com) 262> alter Pupmpbk2,extseqno 194469 Extrba 0 Note: Extseqno 194469 is in read Checkpoint's sequence #: 194468 plus 1 because a sequence number is rolled forward with etrollover on the extraction process Ggsci (001.oracle.drs.dc.com) 262>start PUPMPBK2

11.3 Start the delivery process

Ggsci (001.oracle.drs.dc.com) 262>start PUPMPBK2

12. Start the replication Process 12.1 View the load location of the replication process

Ggsci (001.oracle.drs.dc.com) 21> info repmpb2p,showch Replicat repmpb2p last Started 2016-05-05 16:31 Status abended Checkpoint Lag 00:00:00 (updated 00:04:42 ago) Log Read Checkpoint File./dirdat/repmpb2p/re000083 First Record RBA 0 Current Checkpoint Detail: Read Checkpoint #1 GGS Log Trail Startup Checkpoint (starting position in the data source): Sequence #: 6184 rba:36936583 Timestamp:not Available Extract Trail:./dirdat/repmpb2p/re Current Checkpoint (position of last record, read in the data source): Sequence #: 6184 rba:36936583 Timestamp:not Available Extract Trail:./dirdat/repmpb2p/re

12.2 Modifying the sequence of the replication process #和RBA

Ggsci (001.oracle.drs.dc.com) 22>alter repmpb2p extseqno 6185 Extrba 0 Note: extseqno 6185 is the sequence #: 6184 plus 1 in current checkpoint, because a sequence number is rolled forward with etrollover on the delivery process

12.3 Start the replication process

Ggsci (001.oracle.drs.dc.com) 22>start repmpb2p

13 Upgrade Complete

Congratulations, you have successfully completed the Goldengate 11g to 12c upgrade.

Original: Goldengate upgrade from 11.2 to 12.1.2