6. Update the Extract/Pump parameter files on the source to include the scott.test table as part of replication.

7. Update the Replicat parameter file on the target to include scott.test.

B. Upgrade Steps

1. Stop the OGG monitoring (crontab) on both source and target to avoid unnecessary alerts and pages.

2. On the source, stop the OGG 11.1 extract process, use the LOGEND command and make a note of the stop timestamp. This timestamp will be used to re-position the extract to pickup the transactions from the archive or the redo logs, generated during the OGG upgrade.

Where version specifies an Oracle GoldenGate release version. The major value is the major version number, and minor is the minor version number, such as 11.1 or 11.2. Make certain to include the dot.

Example: EXTTRAIL /u01/app/11.2/dirdat/es format 11.1

3. Stop the OGG Pump and Replicat processes on the source and target enviornments respectively. Wait for some time and make sure that there is NO LAG at the PUMP and the REPLICAT processes. Then stop PUMP and REPLICAT processes.

SourceGGSCI (source) 3> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
Target:
GGSCI (target) 3> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
5. Backup the current OGG 11.1 directory. Make sure that you have sufficient space before making a copy. Perform this step on both source and target.

$ cd /u01/app
$ df -h
$ cp -pR 11.1 11.1_bkp
$ ls -l 11.1_bkp

6. Rename the 11.1 directory to 11.2 and copy the contents from 11.2_software to the new 11.2 directory. Perform this step on both source and target.

$ cd /u01/app
$ mv 11.1 11.2
$ cd 11.2
$ chmod -R u+rw *

$ cd /u01/app/11.2_software
$ cp * /u01/app/11.2/

7. Update the .bash_profile file for the GGS user with the new OGG location “/u01/app/11.2”. Perform this step on both source and target.

12. Rename or move the OLD trail files available under the /u01/app/11.2/dirdat directory so that the extract/pump starts from the new trail sequence 000000.

Source$ cd /u01/app/11.2/dirdat/
$ mkdir bkup
$ mv es* bkup/

Target$ cd /u01/app/11.2/dirdat/
$ mkdir bkup
$ mv et* bkup/

13. Start the OGG Extract/Pump processes on the source and replicat process on the target.

Source
If you have NOT already created extract process to BEGIN at the stop timestamp captured in previous steps you can now alter the extract to BEGIN at stop timestamp captured earier. Finally start the extract process.

Join over 3,000 others My posts. Your Inbox. Beautiful.

Database GoldenGate

About Natik Ameen

Natik Ameen is an Oracle Production DBA, Oracle Certified RAC Expert and a DBA track Certification trainer for over 17 years. He is an Oracle Evangelist and has presented at IOUG & UTOUG conferences. He writes on topics such as Database Administration, RAC, GoldenGate and the Cloud. Stay connected with Natik at LinkedIn or FaceBook.