How to See the OGG Extract BR (Bounded Recovery) Checkpoint Information in GGSCI [ID 1373138.1]

Applies to:

Oracle GoldenGate - Version: 11.1.1.1.0 and later   [Release: 11.1.1.1 and later ]
Information in this document applies to any platform.

Goal

How can the Extract BR (bounded recovery) checkpoint information in Oracle GoldenGate (OGG) be seen?

Solution

The BR checkpoint information is shown in the SHOWCH output starting with OGG v11.1.1.1

Following is an example showing the BR checkpoint information on the extract along with the
standard recovery checkpoint details


GGSCI 3> info e1, showch

EXTRACT E1 Last Started 2011-11-02 10:40 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint Oracle Redo Logs
2011-11-02 16:45:30 Seqno 849, RBA 4947968


Current Checkpoint Detail:

Read Checkpoint #1

Oracle Redo Log

Startup Checkpoint (starting position in the data source):
Sequence #: 848
RBA: 35910160
Timestamp: 2011-11-02 10:39:34.000000
Redo File: C:\APP\RGOVINDASWAMY\ORADATA\ORA11G\REDO02.LOG

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Sequence #: 849
RBA: 4938768
Timestamp: 2011-11-02 16:45:30.000000
Redo File: C:\APP\RGOVINDASWAMY\ORADATA\ORA11G\REDO03.LOG

Current Checkpoint (position of last record read in the data source):
Sequence #: 849
RBA: 4947968
Timestamp: 2011-11-02 16:45:30.000000
Redo File: C:\APP\RGOVINDASWAMY\ORADATA\ORA11G\REDO03.LOG

BR Previous Recovery Checkpoint:
Sequence #: 0
RBA: 0
Timestamp: 2011-11-02 10:40:07.236000
Redo File:

BR Begin Recovery Checkpoint:
Sequence #: 849
RBA: 2529280
Timestamp: 2011-11-02 14:37:48.000000
Redo File:

BR End Recovery Checkpoint:
Sequence #: 849
RBA: 2529280
Timestamp: 2011-11-02 14:37:48.000000
Redo File:

Write Checkpoint #1

GGS Log Trail

Current Checkpoint (current write position):
Sequence #: 1
RBA: 1402
Timestamp: 2011-11-02 16:46:13.546000
Extract Trail: dirdat\e1

Header:
Version = 2
Record Source = A
Type = 4
# 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 = 2011-11-02 10:40:07
Last Update Time = 2011-11-02 16:46:13
Stop Status = A
Last Result = 400