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:
Allowed Values:
[ "mpoints:positionEr" ]
-
endOfFile:
boolean
End of file indicator
-
inputCheckpoint:
object inputCheckpoint
Input checkpoint position
-
lastCheckpointTs:
lastCheckpointTs
Time of last checkpoint
-
lastOperationLagMs:
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Lag of last operation (milliseconds) -
lastOperationTs:
lastOperationTs
Time of last operation processed
-
outputCheckpoint:
object outputCheckpoint
Output checkpoint position
-
trailTimesAtEof:
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:
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Relative Byte Address -
redoThread:
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Redo Thread Id -
scn:
string
Minimum Length:
1
Maximum Length:32
SCN number -
sequence:
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Sequence Number -
timestamp:
timestamp
Time of last read checkpoint
Nested Schema : outputCheckpoint
Type:
object
Output checkpoint position
Show Source
-
rba:
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Relative Byte Address -
sequence:
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Sequence Number -
timestamp:
timestamp
Time of last write checkpoint
-
trail:
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":[
]
}