My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.