レポートの取得
get
/services/{version}/extracts/{extract}/info/reports/{report}
必要なロール: ユーザー
Extractプロセスからレポートを取得します。
リクエスト
パス・パラメータ
- extract(必須): string
最小長:
1最大長:8パターン:^[A-Z_$][A-Z0-9_$]*$Extractの名前。Extract名は大文字で、先頭が英字、その後に英数字が最大で7文字続きます。
- report(必須): string
最小長:
5最大長:13パターン:^[A-Z_$][A-Z0-9_$]{0,7}[0-9]?[.](rpt|dsc)$レポートの名前。Extract名の後にオプションのリビジョン番号と.rptが続きます
- version(必須): string
Oracle GoldenGateサービスのAPIバージョン。
指定できる値:[ "v2" ]
レスポンス
サポートされるメディア・タイプ
- application/json
200レスポンス
レポートが正常に取得されました。
ルート・スキーマ: Oracle GoldenGate Process Report
型:
objectタイトル:
Oracle GoldenGate Process Reportプロセス・レポート
ソースの表示
- $schema:
指定できる値:
[ "ogg:report" ] - lines(必須): array lines
最小アイテム数:
0最大アイテム数:2147483647
レスポンスの例(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 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210704.0633",
" Linux, x64, 64bit (optimized), Oracle on Jul 13 2021 09:21:44",
" ",
"Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.",
"",
" Starting at 2021-07-13 16:37:08",
"***********************************************************************",
"",
"Operating System Version:",
"Linux",
"Version #1 SMP PREEMPT Wed, 07 Jul 2021 23:35:29 +0000, Release 5.12.15-arch1-1",
"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: 1837",
"",
"Description: ",
"",
"***********************************************************************",
"** Running with the following parameters **",
"***********************************************************************",
"",
"2021-07-13 16:37:08 INFO OGG-03059 Operating system character set identified as US-ASCII.",
"",
"2021-07-13 16:37:08 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.",
"",
"2021-07-13 16:37:08 INFO OGG-01360 EXTRACT is running in Integrated mode.",
"Extract EXT2",
"ExtTrail X2 Format Release 12.3",
"UseridAlias oggadmin",
"",
"2021-07-13 16:37:08 INFO OGG-03541 Oracle Environment Variables: ",
"TNS_ADMIN = /u02/ogg/Local/etc",
"LD_LIBRARY_PATH = /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64/jre/lib/amd64/server:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64/jre/lib/amd64:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64/jre/../lib/amd64:/usr/lib/jvm/jre/lib/amd64/server:/u01/app/oracle/product/12cR2/dbhome/lib.",
"Table oggadmin.*;",
"",
"2021-07-13 16:37:08 INFO OGG-02733 Heartbeat table found in the connected schema oggadmin, using this heartbeat table.",
"",
"2021-07-13 16:37:08 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/",
"",
"2021-07-13 16:37:08 INFO OGG-01851 filecaching started: thread ID: 140019459147520.",
"",
"2021-07-13 16:37:08 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.",
"",
"2021-07-13 16:37:08 INFO OGG-25340 ",
"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.",
"",
"2021-07-13 16:37:08 INFO OGG-25341 ",
"Database Language and Character Set:",
"NLS_LANGUAGE = \"AMERICAN\" ",
"NLS_TERRITORY = \"AMERICA\" ",
"NLS_CHARACTERSET = \"AL32UTF8\".",
"",
"2021-07-13 16:37:08 INFO OGG-26025 ",
"Database Unique Name: ORCL.",
"",
"2021-07-13 16:37:09 INFO OGG-06604 Connected to database ORCL, CPU info: CPU Count 40, CPU Core Count 20, CPU Socket Count 2.",
"",
"2021-07-13 16:37:09 INFO OGG-06618 Database ORCL Platform: Linux x86 64-bit.",
"",
"2021-07-13 16:37:24 INFO OGG-02248 Logmining server DDL filtering enabled.",
"",
"2021-07-13 16:37:28 INFO OGG-02068 Integrated capture successfully attached to logmining server OGG$CAP_EXT2 using OGGCapture API.",
"",
"2021-07-13 16:37:28 INFO OGG-02089 Source redo compatibility version is: 12.2.0.",
"",
"2021-07-13 16:37:28 INFO OGG-15446 Extract configured as OTHER_GROUPS resource group.",
"",
"2021-07-13 16:37:28 INFO OGG-02086 Integrated Dictionary will be used.",
"",
"2021-07-13 16:37:29 WARNING OGG-02905 Replication of OID column in object tables may diverge.",
"",
"2021-07-13 16:37:29 INFO OGG-01052 No recovery is required for target file X2000000000, at RBA 0 (file not opened).",
"",
"2021-07-13 16:37:29 INFO OGG-01478 Output file X2 is using format RELEASE 12.3/18.1.",
"",
"***********************************************************************",
"** Run Time Messages **",
"***********************************************************************",
"",
"",
"2021-07-13 16:38:01 INFO OGG-02557 Heartbeat table OGGADMIN.GG_HEARTBEAT_SEED metadata is resolved and will write to trail file X2."
]
}
}