* **List all jobs**
We can list all current jobs using the following syntax
oracle@**** ~]$ /u01/app/oracle/product/12.1.2/ebanking_gg/ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.3.0.1.0 OGGCORE_12.3.0.1.0_PLATFORMS_170721.0154_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Jul 21 2017 23:31:13
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
GGSCI (******.***.local) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING EBKREP1 00:00:00 00:00:05
REPLICAT ABENDED REP2 160:25:49 644:21:17
REPLICAT ABENDED TESTREP 164:36:25 600:08:55
* **View parameters**
GGSCI (Naos.izb.local) 2> view params TESTREP
Replicat testrep
USERID ggate, PASSWORD "password!"
AssumeTargetDefs
OVERRIDEDUPS
--DiscardFile ./dirrpt/rpdw.dsc
showsyntax Noapply
grouptransops 1
maxtransops 1
Map IZOLAPROP.IB_SESSION, target IZOLAPROP.IB_SESSION;
* **View report errors**
GGSCI (Naos.izb.local) 5> view report REP2
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 12.3.0.1.0 OGGCORE_12.3.0.1.0_PLATFORMS_170721.0154_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Jul 21 2017 23:36:12
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
Starting at 2017-11-29 10:27:00
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Thu Oct 29 17:29:29 EDT 2015, Release 3.10.0-327.el7.x86_64
Node: Naos.izb.local
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: 81433
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2017-11-29 10:27:00 INFO OGG-03059 Operating system character set identified as UTF-8.
2017-11-29 10:27:00 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
Replicat Rep2
USERID ggate, PASSWORD ***
Source Context :
SourceModule : [ggdb.ora.sess]
SourceID : [/scratch/aime/adestore/views/aime_adc4150313/oggcore/OpenSys/src/gglib/ggdbora/ocisess
.c]
SourceMethod : [oci_try]
SourceLine : [978]
ThreadBacktrace : [18] elements
: [/u01/app/oracle/product/12.1.2/ebanking_gg/libgglog.so(CMessageContext::AddThreadConte
xt()+0x1e) [0x7f1754d8dd1e]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/libgglog.so(CMessageFactory::CreateMessage(
CSourceContext*, unsigned int, ...)+0x1ae) [0x7f1754d80f5e]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/libgglog.so(_MSG_Int32_String_String(CSourc
eContext*, int, int, char const*, char const*, CMessageFactory::MessageDisposition)+0x99) [0x7f1754d7c359]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat() [0x7a499e]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat() [0x7a46d9]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(ggs::gglib::ggdbora::OraConnUtil::
initConnectionLogon(ggs::gglib::ggdbapi::DBAuthParams const&)+0x1df) [0x7dfd0f]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(ggs::gglib::ggdbora::OraConnUtil::
openDataSource(ggs::gglib::ggdbapi::DBAuthParams const&)+0x28) [0x7dfae8]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(ggs::gglib::ggdbora::OraRepConnUti
l::openDataSource(ggs::gglib::ggdbapi::DBAuthParams const&)+0xb) [0x7e058b]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat() [0x765bb4]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(odbc_param(char*, char*)+0x302) [0
x765a52]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(get_infile_params(ggs::gglib::ggap
p::ReplicationContextParams&, ggs::gglib::ggdatasource::DataSourceParams&, ggs::gglib::ggdatatarget::DataTargetPara
ms&, ggs::gglib::ggmetadata::MetadataContext&)+0x213a) [0x5cc85a]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat() [0x6938c4]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(ggs::gglib::MultiThreading::MainTh
read::ExecMain()+0x71) [0x746341]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(ggs::gglib::MultiThreading::Thread
::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14c) [0x745bfc]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(ggs::gglib::MultiThreading::MainTh
read::Run(int, char**)+0xb5) [0x7462b5]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(main+0x3b) [0x69741b]]
: [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f1749b4fb15]]
: [/u01/app/oracle/product/12.1.2/ebanking_gg/replicat(__gxx_personality_v0+0x3f1) [0x57a
ee9]]
2017-11-29 10:27:00 ERROR OGG-00664 OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3701
Additional information: 404067755).
2017-11-29 10:27:00 ERROR OGG-01668 PROCESS ABENDING.
* **View a log using the logdump**
[oracle@Naos ebanking_gg]$ ./logdump
Oracle GoldenGate Log File Dump Utility for Oracle
Version 12.3.0.1.0 OGGCORE_12.3.0.1.0_PLATFORMS_170721.0154
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
Logdump 1 >open /u01/app/oracle/product/12.1.2/ebanking_gg/dirdat/rt000000001
Current LogTrail is /u01/app/oracle/product/12.1.2/ebanking_gg/dirdat/rt000000001
Logdump 2 >pos 6098562
Reading forward from RBA 6098562
Logdump 3 >n
2017/11/15 02:42:13.201.386 Delete Len 352 RBA 6098562
Name: IZOLAPROP.IB_SESSION (TDR Index: 1)
Before Image: Partition 12 G b
0000 0a00 0000 0000 0000 0000 25a3 0100 0d00 0000 | ............%.......
0900 6e6f 7465 7869 7374 7302 0028 0000 0024 0038 | ..notexists..(...$.8
3735 3363 3262 382d 3132 6166 2d34 6339 322d 6265 | 753c2b8-12af-4c92-be
3361 2d35 3539 3239 6165 3938 3133 3603 000a 00ff | 3a-55929ae98136.....
ff00 0000 0000 0000 0004 000a 00ff ff00 0000 0000 | ....................
0000 0005 000a 0000 0000 0000 0000 0000 0006 0020 | ...................
0000 001c 0033 312e 3337 2e31 3439 2e31 3836 2c20 | .....31.37.149.186,
Logdump 4 >ghdr on
Logdump 5 >detail data on
Logdump 6 >ggstoken detail
Logdump 7 >pos 6098562
Reading forward from RBA 6098562
Logdump 8 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 352 (x0160) IO Time : 2017/11/15 02:42:13.201.386
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 1309 AuditPos : 1433104
Continued : N (x00) RecCount : 1 (x01)
2017/11/15 02:42:13.201.386 Delete Len 352 RBA 6098562
Name: IZOLAPROP.IB_SESSION (TDR Index: 1)
Before Image: Partition 12 G b
0000 0a00 0000 0000 0000 0000 25a3 0100 0d00 0000 | ............%.......
0900 6e6f 7465 7869 7374 7302 0028 0000 0024 0038 | ..notexists..(...$.8
3735 3363 3262 382d 3132 6166 2d34 6339 322d 6265 | 753c2b8-12af-4c92-be
3361 2d35 3539 3239 6165 3938 3133 3603 000a 00ff | 3a-55929ae98136.....
ff00 0000 0000 0000 0004 000a 00ff ff00 0000 0000 | ....................
0000 0005 000a 0000 0000 0000 0000 0000 0006 0020 | ...................
0000 001c 0033 312e 3337 2e31 3439 2e31 3836 2c20 | .....31.37.149.186,
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0000 25a3 | ........%.
Column 1 (x0001), Len 13 (x000d)
0000 0900 6e6f 7465 7869 7374 73 | ....notexists
Column 2 (x0002), Len 40 (x0028)
0000 2400 3837 3533 6332 6238 2d31 3261 662d 3463 | ..$.8753c2b8-12af-4c
3932 2d62 6533 612d 3535 3932 3961 6539 3831 3336 | 92-be3a-55929ae98136
Column 3 (x0003), Len 10 (x000a)
ffff 0000 0000 0000 0000 | ..........
Column 4 (x0004), Len 10 (x000a)
ffff 0000 0000 0000 0000 | ..........
Column 5 (x0005), Len 10 (x000a)
0000 0000 0000 0000 0000 | ..........
Column 6 (x0006), Len 32 (x0020)
0000 1c00 3331 2e33 372e 3134 392e 3138 362c 2031 | ....31.37.149.186, 1
302e 3230 302e 3231 2e31 3133 | 0.200.21.113
Column 7 (x0007), Len 4 (x0004)
ffff 0000 | ....
Column 8 (x0008), Len 79 (x004f)
0000 4b00 4d6f 7a69 6c6c 612f 352e 3020 2857 696e | ..K.Mozilla/5.0 (Win
646f 7773 204e 5420 362e 333b 2057 4f57 3634 3b20 | dows NT 6.3; WOW64;
5472 6964 656e 742f 372e 303b 2054 6f75 6368 3b20 | Trident/7.0; Touch;
7276 3a31 312e 3029 206c 696b 6520 4765 636b 6f | rv:11.0) like Gecko
Column 9 (x0009), Len 31 (x001f)
0000 3230 3137 2d31 312d 3134 3a32 333a 3337 3a35 | ..2017-11-14:23:37:5
302e 3030 3030 3030 3030 30 | 0.000000000
Column 10 (x000a), Len 10 (x000a)
ffff 0000 0000 0000 0000 | ..........
Column 11 (x000b), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 12 (x000c), Len 4 (x0004)
ffff 0000 | ....
Column 14 (x000e), Len 4 (x0004)
ffff 0000 | ....
Column 15 (x000f), Len 4 (x0004)
ffff 0000 | ....
GGS tokens:
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 4157 3661 4141 4841 4141 5850 7941 4145 0001 | AAAW6aAAHAAAXPyAAE..
TokenID x4c 'L' LOGCSN Info x00 Length 9
3435 3434 3536 3735 37 | 454456757
TokenID x36 '6' TRANID Info x00 Length 12
302e 382e 3136 2e31 3238 3934 | 0.8.16.12894
Logdump 9 >exit
[oracle@Naos ebanking_gg]$
We can also the state of the replication in more detailed level as follows:
GGSCI (oraprod.izola.dom) 4> info replicat IBPREP1, detail
REPLICAT IBPREP1 Last Started 2018-08-10 15:22 Status RUNNING
Checkpoint Lag 32:58:57 (updated 00:00:00 ago)
Process ID 6233
Log Read Checkpoint File ./dirdat/rt000098
2018-08-09 08:40:16.000065 RBA 15040862
Current Log BSN value: (requires database login)
Extract Source Begin End
./dirdat/rt000098 2018-08-07 10:29 2018-08-09 08:40
./dirdat/rt000083 2018-08-07 10:29 First Record
./dirdat/rt000083 2018-08-07 10:29 First Record
./dirdat/rt000083 2018-08-07 10:29 First Record
./dirdat/rt000083 2018-08-07 10:21 2018-08-07 10:29
./dirdat/rt000083 * Initialized * 2018-08-07 10:21
./dirdat/rt000000 * Initialized * First Record
./dirdat/rt000000 * Initialized * First Record
Current directory /u01/app/oracle/product/gg
Report file /u01/app/oracle/product/gg/dirrpt/IBPREP1.rpt
Parameter file /u01/app/oracle/product/gg/dirprm/ibprep1.prm
Checkpoint file /u01/app/oracle/product/gg/dirchk/IBPREP1.cpr
Checkpoint table ggate.CKPTAB
Process file /u01/app/oracle/product/gg/dirpcs/IBPREP1.pcr
Error log /u01/app/oracle/product/gg/ggserr.log