Hi Team,
I have scenario like: my both the databases are in two different VMs (source db version: 12.1.0 , non-cdb & target db version: 12.2.x, CDM(pointing to pdb1- its already replicated pluggable earlier).
due to some GUI related issues, i have setup the both the extract and replicat param files in the target machine only. ( earlier they use to be at their respective VM ).
the changes were not capturing in extract process.
this is how the files content were inside.
-----------------
On Target Machine:
------------------------
GGSCI (denac473.us.oracle.com) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DML_ES01 217:50:48 00:00:02
EXTRACT RUNNING DML_PS01 00:00:00 00:00:05
REPLICAT RUNNING DML_RS01 00:00:00 125:11:51
REPLICAT STOPPED INITLRS1 26:52:27 4966:14:27
REPLICAT ABENDED UNIDMLRS 00:00:00 2279:51:10
GGSCI (denac473.us.oracle.com) 4> view param DML_ES01
extract dml_es01
userid ogguser@sourcedb.com:1521/db1,password xxxx
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
TABLEEXCLUDE admuser.TMP*
--exttrail /scratch/ggtrails/lt
exttrail ./dirdat/ex
DDL INCLUDE MAPPED
ddloptions report
table admuser.*;
GGSCI (denac473.us.oracle.com) 5> view param DML_PS01
extract dml_ps01
userid ogguser@sourcedb.com:1521/db1,password xxxx
RMTHOST denac473.us.oracle.com,mgrport 7809
rmttrail ./dirdat/px
PASSTHRU
table admuser.*;
GGSCI (denac473.us.oracle.com) 6> view param DML_RS01
replicat dml_rs01
USERID c##ogguser@target_pdb1,password oracle
ASSUMETARGETDEFS
REPERROR (DEFAULT,DISCARD)
GETINSERTS
GETUPDATES
GETDELETES
--DISCARDFILE /scratch/ggtrails/initload01.dsc, purge
ddloptions report
--passthru
map admuser.*,target admuser.*;
-----Now I have created one table in source db and verified the logs, but no changes were capturing.
GGSCI (denac473.us.oracle.com) 7> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DML_ES01 217:51:48 00:00:00
EXTRACT RUNNING DML_PS01 00:00:00 00:00:03
REPLICAT RUNNING DML_RS01 00:00:00 00:00:02
REPLICAT STOPPED INITLRS1 26:52:27 4966:15:25
REPLICAT ABENDED UNIDMLRS 00:00:00 2279:52:08
GGSCI (denac473.us.oracle.com) 8> info DML_ES01 detail
EXTRACT DML_ES01 Last Started 2019-03-31 12:31 Status RUNNING
Checkpoint Lag 217:51:48 (updated 00:00:08 ago)
Process ID 42191
Log Read Checkpoint Oracle Integrated Redo Logs
2019-03-22 10:40:29
SCN 0.0 (0)
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/ex 2 1519 20 EXTTRAIL
Integrated Extract outbound server first scn: Unavailable.Need DBLOGIN.
Integrated Extract outbound server filtering start scn: Unavailable.Need DBLOGIN.
Extract Source Begin End
Not Available 2019-03-22 10:40 2019-03-22 10:40
Not Available 2019-03-22 10:40 2019-03-22 10:40
Not Available 2019-03-22 10:40 2019-03-22 10:40
Not Available 2019-03-22 10:40 2019-03-22 10:40
Not Available 2019-03-22 10:40 2019-03-22 10:40
Not Available * Initialized * 2019-03-22 10:40
Not Available * Initialized * 2019-03-22 10:40
Current directory /scratch/u01/app/product/12.2.0/oggtgt
Report file /scratch/u01/app/product/12.2.0/oggtgt/dirrpt/DML_ES01.rpt
Parameter file /scratch/u01/app/product/12.2.0/oggtgt/dirprm/dml_es01.prm
Checkpoint file /scratch/u01/app/product/12.2.0/oggtgt/dirchk/DML_ES01.cpe
Process file /scratch/u01/app/product/12.2.0/oggtgt/dirpcs/DML_ES01.pce
Error log /scratch/u01/app/product/12.2.0/oggtgt/ggserr.log
GGSCI (denac473.us.oracle.com) 9> sh cat /scratch/u01/app/product/12.2.0/oggtgt/dirrpt/DML_ES01.rpt
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Jun 30 2017 16:24:34
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
Starting at 2019-03-31 12:31:05
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Wed Sep 12 16:52:07 PDT 2018, Release 3.8.13-118.24.2.el7uek.x86_64
Node: denacxxx.us.oracle.com
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: 42191
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2019-03-31 12:31:05 INFO OGG-03059 Operating system character set identified as UTF-8.
2019-03-31 12:31:05 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
extract dml_es01
userid ogguser@sourcedb.com:1521/db1,password xxxx
2019-03-31 12:31:08 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.
LOGALLSUPCOLS
2019-03-31 12:31:08 WARNING OGG-04033 LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
UPDATERECORDFORMAT COMPACT
TABLEEXCLUDE admuser.TMP*
exttrail ./dirdat/ex
DDL INCLUDE MAPPED
ddloptions report
table admuser.*;
2019-03-31 12:31: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:
/scratch/u01/app/product/12.2.0/oggtgt/BR/DML_ES01.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /scratch/u01/app/product/12.2.0/oggtgt
2019-03-31 12:31:08 INFO OGG-01851 filecaching started: thread ID: 139888072562432.
2019-03-31 12:31: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:
/scratch/u01/app/product/12.2.0/oggtgt/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "US"
NLS_CHARACTERSET = "WE8MSWIN1252"
2019-03-31 12:31:13 WARNING OGG-02045 Database does not have streams_pool_size initialization parameter configured.
2019-03-31 12:31:14 INFO OGG-02248 Logmining server DDL filtering enabled.
2019-03-31 12:31:15 INFO OGG-02068 Integrated capture successfully attached to logmining server OGG$CAP_DML_ES01 using OGGCapture API.
2019-03-31 12:31:15 INFO OGG-02089 Source redo compatibility version is: 12.1.0.2.0.
2019-03-31 12:31:15 INFO OGG-02086 Integrated Dictionary will be used.
2019-03-31 12:31:17 WARNING OGG-02905 Replication of OID column in object tables may diverge.
2019-03-31 12:31:17 INFO OGG-01055 Recovery initialization completed for target file ./dirdat/ex000000001, at RBA 1519.
2019-03-31 12:31:17 INFO OGG-01478 Output file ./dirdat/ex is using format RELEASE 12.2.
2019-03-31 12:31:17 INFO OGG-01026 Rolling over remote file ./dirdat/ex000000001.
2019-03-31 12:31:17 INFO OGG-01053 Recovery completed for target file ./dirdat/ex000000002, at RBA 1519.
2019-03-31 12:31:17 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
**********************************************************************
GGSCI (denac473.us.oracle.com) 10> stats DML_ES01 total
Sending STATS request to EXTRACT DML_ES01 ...
No active extraction maps
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 0.00
Mapped operations 0.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00