- 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