Retrieve Report
get
/services/{version}/extracts/{extract}/info/reports/{report}
Retrieve a report from the extract process.
Request
Path Parameters
-
extract: string
Minimum Length:
1
Maximum Length:8
Pattern:^[A-Z_$][A-Z0-9_$]*$
The name of the extract. Extract names are upper case, begin with an alphabetic character followed by up to seven alpha-numeric characters.
-
report: string
Minimum Length:
5
Maximum Length:13
Pattern:^[A-Z_$][A-Z0-9_$]{0,7}[0-9]?[.]rpt$
The name of the report, which is the extract name, followed by an optional revision number and '.rpt'
-
version: string
Oracle GoldenGate Service API version.
Allowed Values:[ "v2" ]
Response
Supported Media Types
- application/json
200 Response
Report retrieved successfully.
Root Schema : Oracle GoldenGate Process Report
Type:
object
Title:
Oracle GoldenGate Process Report
Process Report
Show Source
-
$schema:
Allowed Values:
[ "ogg:report" ]
-
lines:
array lines
Minimum Number of Items:
0
Maximum Number of Items:2147483647
Nested Schema : lines
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
Show Source
2147483647
-
[0]:
string
Minimum Length:
0
Maximum Length:4095
Example Response (application/json)
{
"$schema":"api:standardResponse",
"links":[
{
"href":"http://localhost:11001/services/v2/extracts/EXT2/info/reports/EXT2.rpt",
"mediaType":"application/json",
"rel":"canonical"
},
{
"href":"http://localhost:11001/services/v2/extracts/EXT2/info/reports/EXT2.rpt",
"mediaType":"application/json",
"rel":"self"
},
{
"href":"http://localhost:11001/services/v2/metadata-catalog/extractReport",
"mediaType":"application/schema+json",
"rel":"describedby"
}
],
"messages":[
],
"response":{
"$schema":"ogg:report",
"lines":[
"",
"***********************************************************************",
" Oracle GoldenGate Capture for Oracle",
" Version 12.3.0.1.2 BuildAndTest",
" Linux, Oracle 12c on Dec 13 2017 14:30:19",
" ",
"Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.",
"",
"",
" Starting at 2017-12-14 12:42:16",
"***********************************************************************",
"",
"Operating System Version:",
"Linux",
"Version #1 SMP PREEMPT Tue Dec 5 19:10:06 UTC 2017, Release 4.14.4-1-ARCH",
"Node: ogg",
"Machine: x86_64",
" soft limit hard limit",
"Address Space Size : unlimited unlimited",
"Heap Size : unlimited unlimited",
"File Size : unlimited unlimited",
"CPU Time : unlimited unlimited",
"",
"Process id: 1642",
"",
"Description: ",
"",
"***********************************************************************",
"** Running with the following parameters **",
"***********************************************************************",
"",
"2017-12-14 12:42:16 INFO OGG-03059 Operating system character set identified as US-ASCII.",
"",
"2017-12-14 12:42:16 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.",
"",
"2017-12-14 12:42:16 INFO OGG-01360 EXTRACT is running in Integrated mode.",
"Extract EXT2",
"ExtTrail X2 Format Release 12.3",
"UseridAlias oggadmin",
"",
"2017-12-14 12:42:16 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.",
"Table oggadmin.*;",
"",
"2017-12-14 12:42:16 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint.",
"",
"2017-12-14 12:42:16 INFO OGG-01815 Virtual Memory Facilities for: BR",
" anon alloc: mmap(MAP_ANON) anon free: munmap",
" file alloc: mmap(MAP_SHARED) file free: munmap",
" target directories:",
" /u02/ogg/Local/var/run/BR/EXT2.",
"",
"Bounded Recovery Parameter:",
"BRINTERVAL = 4HOURS",
"BRDIR = /u02/ogg/Local/var/run/",
"",
"2017-12-14 12:42:16 INFO OGG-01851 filecaching started: thread ID: 139990793692928.",
"",
"2017-12-14 12:42:16 INFO OGG-01815 Virtual Memory Facilities for: COM",
" anon alloc: mmap(MAP_ANON) anon free: munmap",
" file alloc: mmap(MAP_SHARED) file free: munmap",
" target directories:",
" /u02/ogg/Local/var/temp.",
"",
"Database Version:",
"Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production",
"PL/SQL Release 12.2.0.1.0 - Production",
"CORE\t12.2.0.1.0\tProduction",
"TNS for Linux: Version 12.2.0.1.0 - Production",
"NLSRTL Version 12.2.0.1.0 - Production",
"",
"Database Language and Character Set:",
"NLS_LANGUAGE = \"AMERICAN\" ",
"NLS_TERRITORY = \"AMERICA\" ",
"NLS_CHARACTERSET = \"AL32UTF8\" ",
"",
"2017-12-14 12:42:16 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.",
"",
"2017-12-14 12:42:17 INFO OGG-06604 Database ORCL CPU info: CPU Count 40, CPU Core Count 20, CPU Socket Count 2.",
"",
"2017-12-14 12:42:31 INFO OGG-02248 Logmining server DDL filtering enabled.",
"",
"2017-12-14 12:42:36 INFO OGG-02068 Integrated capture successfully attached to logmining server OGG$CAP_EXT2 using OGGCapture API.",
"",
"2017-12-14 12:42:36 INFO OGG-02089 Source redo compatibility version is: 12.2.0.",
"",
"2017-12-14 12:42:36 INFO OGG-02086 Integrated Dictionary will be used.",
"",
"2017-12-14 12:42:36 WARNING OGG-02905 Replication of OID column in object tables may diverge.",
"",
"2017-12-14 12:42:36 INFO OGG-01052 No recovery is required for target file X2000000000, at RBA 0 (file not opened).",
"",
"2017-12-14 12:42:36 INFO OGG-01478 Output file X2 is using format RELEASE 12.3.",
"",
"***********************************************************************",
"** Run Time Messages **",
"***********************************************************************",
"",
"",
"2017-12-14 12:42:36 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.",
"",
"2017-12-14 12:43:10 INFO OGG-02557 Heartbeat table OGGADMIN.GG_HEARTBEAT_SEED metadata is resolved and will write to trail file X2.",
"",
"2017-12-14 12:43:40 INFO OGG-01971 The previous message, 'INFO OGG-02557', repeated 1 times.",
"",
"2017-12-14 12:43:48 INFO OGG-01021 Command received from REST API: STATS HOURLY."
]
}
}