Thinking Out Loud

June 27, 2012

GoldenGate Integrated Extract Upgrade

Filed under: 11g,GoldenGate — mdinh @ 1:43 am

Oracle GoldenGate: Compressed tables are not supported until v11.2.0.3 Integrated Extract. [ID 1266389.1]

11.2.0.3 Database specific bundle patch for Integrated Extract 11.2.x [ID 1411356.1]

One reason to upgrade to integrate extract is to support compression. Oracle database must be as least 11.2.0.3 and Patch 13560925 applied.

GGSCI 1> DBLOGIN USERID gguser, PASSWORD AADAAAAAAAAAAA, ENCRYPTKEY key1

Successfully logged into database.

GGSCI 2> INFO ALL

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING PHA02 00:00:00 00:00:04
EXTRACT RUNNING XHA02 00:00:00 00:00:06
REPLICAT RUNNING RHA02 01:08:54 00:00:00

GGSCI 3> INFO *

EXTRACT PHA02 Last Started 2012-06-26 14:44 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/xb000002
2012-06-26 14:44:47.060732 RBA 1056

EXTRACT XHA02 Last Started 2012-06-26 14:44 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint Oracle Redo Logs
2012-06-26 16:05:41 Seqno 31, RBA 149897728
SCN 0.506201 (506201)

REPLICAT RHA02 Last Started 2012-06-26 14:44 Status RUNNING
Checkpoint Lag 01:08:56 (updated 00:00:00 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/pa000006
2012-06-26 14:56:55.999661 RBA 484181887

GGSCI 4> STOP EXTRACT XHA02

Sending STOP request to EXTRACT XHA02 …
Request processed.

GGSCI 5> REGISTER EXTRACT XHA02 DATABASE

2012-06-26 16:07:38 INFO OGG-02003 Extract XHA02 successfully registered with database at SCN 511623.

GGSCI 6> ALTER EXTRACT XHA02, UPGRADE INTEGRATED TRANLOG
ERROR: Extract XHA02 is not ready to be upgraded because recovery SCN 509446 has not reached SCN 511623.

GGSCI 7> INFO *

EXTRACT PHA02 Last Started 2012-06-26 14:44 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/xb000002
2012-06-26 14:44:47.060732 RBA 1056

EXTRACT XHA02 Last Started 2012-06-26 14:44 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:01:40 ago)
Log Read Checkpoint Oracle Redo Logs
2012-06-26 16:06:41 Seqno 31, RBA 220454400
SCN 0.509446 (509446)

REPLICAT RHA02 Last Started 2012-06-26 14:44 Status RUNNING
Checkpoint Lag 01:11:15 (updated 00:00:00 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/pa000007
2012-06-26 14:57:07.908678 RBA 77768545

SWITCH SEVERAL LOGFILES AND WENT HOME :=)

GGSCI 13> START EXTRACT XHA02

Sending START request to MANAGER …
EXTRACT XHA02 starting

GGSCI 14> INFO *

EXTRACT PHA02 Last Started 2012-06-26 14:44 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/xb000003
2012-06-26 17:29:09.247516 RBA 1056

EXTRACT XHA02 Last Started 2012-06-26 17:29 Status RUNNING
Checkpoint Lag 01:18:50 (updated 00:00:05 ago)
Log Read Checkpoint Oracle Redo Logs
2012-06-26 16:10:29 Seqno 36, RBA 38589788
SCN 0.535937 (535937)

REPLICAT RHA02 Last Started 2012-06-26 14:44 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/pa000008
2012-06-26 15:58:18.055952 RBA 484588045

NOTICE TIME DIFFERENCE

GGSCI 15> STOP EXTRACT XHA02

Sending STOP request to EXTRACT XHA02 …
Request processed.

GGSCI 16> ALTER EXTRACT XHA02, UPGRADE INTEGRATED TRANLOG
Extract XHA02 successfully upgraded to integrated capture.

GGSCI 17> START EXTRACT XHA02

Sending START request to MANAGER …
EXTRACT XHA02 starting

GGSCI 18> INFO *

EXTRACT PHA02 Last Started 2012-06-26 14:44 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/xb000003
2012-06-26 17:29:09.247516 RBA 1056

EXTRACT XHA02 Initialized 2012-06-26 17:29 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:16 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2012-06-26 17:29:23
SCN 0.623184 (623184)

REPLICAT RHA02 Last Started 2012-06-26 14:44 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/pa000008
2012-06-26 15:58:18.055952 RBA 484588045

GGSCI 19>

About these ads

2 Comments »

  1. Can u help me… im stuck at DBLOGIN… it says
    dblogin ggs_owner, password ggs_owner
    Error: Unable to connect to database using user ggs_owner. Please check privileges.
    ORA-12162: TNS:net service name is incorrectly specified…

    Comment by Najeeb Ahmed — October 8, 2012 @ 9:09 am | Reply

    • Are you able to connect from SQL*Plus as a test case? Try granting DBA to ggs_owner. The correct syntax is: dblogin userid ggs_owner, password ggs_owner. Also, make sure you are pointing to the correct ORACLE_HOME and ORACLE_SID.

      Comment by mdinh — October 9, 2012 @ 1:31 am | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 314 other followers

%d bloggers like this: