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>