DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, March 19, 2018

Upgrade Classic Extract to Integrated Capture on Oracle Goldengate

Upgrade Classic Extract to Integrated Capture

1. Upgrading Classic Capture

EXTRACT EXT1
USERID ggsuser, 'PASSWORD' ggsuser
EXTTRAIL /u01/app/gghome/dirdat/xn
TRANLOGOPTIONS EXCLUDEUSER ggsuser
TABLE user1.*;


2.Add and Register the Extract
From GGSCI add the extract process.

ADD EXTRACT EXT1, TRANLOG, BEGIN NOW
ADD EXTTRAIL /u01/app/gghome/dirdat/xn EXTRACT EXT1, megabytes 100

3.Then register the extract process in the database.

GGSCI (ggsdb01) 6> dblogin USERID ggsuser, PASSWORD ggsuser
Successfully logged into VST database.

GGSCI (ggsdb01) 7> register extract EXT1 database
2018-01-24 11:01:32 INFO OGG-02003 Extract EXT1 successfully registered with database at SCN 293836.

Note: It takes a while to register.

4. Upgrade Classic Extract to Integrated Capture
Try upgrading the registered process. An error will be returned.

GGSCI (ggsdb01) 3> info EXT1 upgrade
ERROR: Extract EXT1 is not ready to be upgraded because recovery SCN 293631 has not reached SCN 293836.

5. Reset to the process to the current SCN as it is not able to start after the upgrade with it still positioned to a point in the past.

GGSCI (ggsdb01) 5> alter extract EXT1, integrated tranlog, begin now
EXTRACT altered.

GGSCI (ggsdb01) 6> start EXT1
Sending START request to MANAGER ...
EXTRACT EXT1 starting

6. Verify the status of the Extract.

GGSCI (ggsdb01) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:03 00:00:00

7. Upgrade to Integrated Capture

GGSCI (ggsdb01) 9> info EXT1 upgrade
ERROR: Extract EXT1 is not ready to be upgraded because recovery SCN values are not set.
Reset Extract SCN
So all that needs to be done is restart the process for it to update the extract to the new SCN number.

GGSCI (ggsdb01) 11> info EXT1
EXTRACT EXT1 Last Started 2018-01-24 11:20 Status RUNNING

Checkpoint Lag 00:00:39 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Redo Logs
2018-01-24 11:19:39 Seqno 502, RBA 28160
SCN 0.0 (0) <

Wait a little while for the till SCN 0.0 (0) value to be updated. Then verify the status again.

GGSCI (ggsdb01) 14> info EXT1
EXTRACT EXT1 Last Started 2018-01-24 11:20 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint Oracle Redo Logs
2018-01-24 11:19:56 Seqno 503, RBA 1024
SCN 0.344145451 (344145451)

GGSCI (ggsdb01) 23> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:01:29 00:00:17

No comments: