Retrieve an existing Checkpoint Position Information
get
/services/{version}/mpoints/{item}/positionEr
Request
Path Parameters
-
item: string
Minimum Length:
1
Maximum Length:32
-
version: string
Oracle GoldenGate Service API version.
Allowed Values:[ "v2" ]
Response
Supported Media Types
- application/json
200 Response
Root Schema : Oracle GoldenGate Position details for ER processes
Type:
object
Title:
Show Source
Oracle GoldenGate Position details for ER processes
-
$schema(optional):
Allowed Values:
[ "mpoints:positionEr" ]
-
endOfFile(optional):
boolean
End of file indicator
-
highWatermarkLagMs(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Lag of the high watermark (milliseconds) -
highWatermarkTs(optional):
highWatermarkTs
Time of the high watermark
-
inputCheckpoint(optional):
object inputCheckpoint
Input checkpoint position
-
lastCheckpointTs(optional):
lastCheckpointTs
Time of last checkpoint
-
lastOperationLagMs(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Lag of last operation (milliseconds) -
lastOperationTs(optional):
lastOperationTs
Time of last operation processed
-
lowWatermarkLagMs(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Lag of the low watermark (milliseconds) -
lowWatermarkTs(optional):
lowWatermarkTs
Time of the low watermark
-
outputCheckpoint(optional):
object outputCheckpoint
Output checkpoint position
-
trailTimesAtEof(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Number of Times Read Hit End of File
Nested Schema : inputCheckpoint
Type:
object
Input checkpoint position
Show Source
-
rba(optional):
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Relative Byte Address -
redoThread(optional):
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Redo Thread Id -
scn(optional):
string
Minimum Length:
1
Maximum Length:32
SCN number -
sequence(optional):
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Sequence Number -
timestamp(optional):
timestamp
Time of last read checkpoint
Nested Schema : outputCheckpoint
Type:
object
Output checkpoint position
Show Source
-
rba(optional):
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Relative Byte Address -
sequence(optional):
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Sequence Number -
timestamp(optional):
timestamp
Time of last write checkpoint
-
trail(optional):
string
Minimum Length:
1
Maximum Length:64
Trail Path
Example Response (application/json)
{
"$schema":"api:standardResponse",
"response":{
"$schema":"mpoints:positionEr",
"lastOperationLagMs":2100,
"lastOperationTs":null,
"lastCheckpointTs":"2015-06-10T11:06:48.462Z",
"inputCheckpoint":{
"redoThread":1,
"sequence":20,
"rba":1530,
"timestamp":"2015-06-09 17:11:32.997Z",
"scn":"0.2415487 (2415487)"
},
"outputCheckpoint":{
"sequence":31,
"rba":1530,
"timestamp":"2015-06-09 11:06:48.462Z",
"trail":"/net/slc03flg/scratch/jdivinc/view_storage/jdivinc_db2/tklocal/ggora/dirdat/bb"
},
"endOfFile":true,
"trailTimesAtEof":1
},
"messages":[
],
"links":[
]
}