How to get the archived log sequence# and rba# of integrated extract checkpoint?

(Doc ID 2006932.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.2 and later
Information in this document applies to any platform.

Goal

In integrated extract, 'info <ext>, showch' does not show the archvied log seq# and rba#.  How can I get them?

GGSCI (ogg-wkshp.us.oracle.com) 2> info e1 showch

EXTRACT E1 Last Started 2015-03-12 12:21 Status ABENDED
Checkpoint Lag 00:00:02 (updated 623:25:23 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2015-04-09 10:28:17
SCN 0.28442453 (28442453)


Current Checkpoint Detail:

Read Checkpoint #1

Oracle Integrated Redo Log

Startup Checkpoint (starting position in the data source):
Timestamp:
SCN: 0.25564788 (25564788)

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Timestamp: 2015-04-08 22:00:32.000000
SCN: 0.28423752 (28423752)

Current Checkpoint (position of last record read in the data source):
Timestamp: 2015-04-09 10:28:17.000000
SCN: 0.28442453 (28442453)

BR Previous Recovery Checkpoint:
Timestamp: 2015-03-12 12:21:48.257971
SCN: Not available

BR Begin Recovery Checkpoint:
Timestamp: 2015-04-08 12:28:20.000000
SCN: 0.28384901 (28384901)

BR End Recovery Checkpoint:
Timestamp: 2015-04-08 12:28:20.000000
SCN: 0.28384901 (28384901)

Write Checkpoint #1

GGS Log Trail

Current Checkpoint (current write position):
Sequence #: 30
RBA: 68179320
Timestamp: 2015-04-09 10:28:19.787066
Extract Trail: ./dirdat/e1
Trail Type: EXTTRAIL

Header:
Version = 2
Record Source = A
Type = 13
# Input Checkpoints = 1
# Output Checkpoints = 1

File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0

Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0

Status:
Start Time = 2015-03-12 12:21:50
Last Update Time = 2015-04-09 10:28:19
Stop Status = A
Last Result = 520



 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms