Hello Experts,
I have configured oracle golden gate in Oracle 11.2.0.4 db. Data pump and replications are running. I have a data pump that I am getting the following on after running a stats on the data pump process.
** Running with the following parameters **
***********************************************************************
2015-05-11 11:17:02 INFO OGG-03059 Operating system character set identified as UTF-8.
2015-05-11 11:17:02 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
Extract esalesaa
ExtTrail ./dirdat/aa
UserID oggadm1, Password ********
2015-05-11 11:17:02 INFO OGG-03522 Setting session time zone to source database time zone '-04:00'.
Table SAPSR3.USR02;
2015-05-11 11:17:02 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:
/OGG_SRC/BR/ESALESAA.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /OGG_SRC
2015-05-11 11:17:02 INFO OGG-01851 filecaching started: thread ID: 140705596237568.
2015-05-11 11:17:02 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:
/OGG_SRC/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "UTF8"
2015-05-11 11:17:02 INFO OGG-01513 Positioning to Sequence 149, RBA 51643408, SCN 0.7645517.
2015-05-11 11:17:02 INFO OGG-01516 Positioned to Sequence 149, RBA 51643408, SCN 0.7645517, May 11, 2015 11:15:11 AM.
2015-05-11 11:17:02 INFO OGG-01055 Recovery initialization completed for target file ./dirdat/aa000004, at RBA 1451.
2015-05-11 11:17:02 INFO OGG-01478 Output file ./dirdat/aa is using format RELEASE 12.1.
2015-05-11 11:17:02 INFO OGG-01026 Rolling over remote file ./dirdat/aa000004.
2015-05-11 11:17:02 INFO OGG-01053 Recovery completed for target file ./dirdat/aa000005, at RBA 1451.
2015-05-11 11:17:02 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
2015-05-11 11:17:02 INFO OGG-01517 Position of first record processed Sequence 149, RBA 51643408, SCN 0.7645516, May 11, 2015 11:15:11 AM.
2015-05-11 11:17:14 INFO OGG-01021 Command received from GGSCI: REPORT.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2015-05-11 11:17:14 (activity since 2015-05-11 11:17:02)
Output to ./dirdat/aa:
No records extracted.
***********************************************************************
** Run Time Warnings **
***********************************************************************
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2015-05-11 11:38:38 (activity since 2015-05-11 11:17:02)
Output to ./dirdat/aa:
No records extracted.
***********************************************************************
** Run Time Warnings **
***********************************************************************
2015-05-11 11:39:44 INFO OGG-01971 The previous message, 'INFO OGG-01021', repeated 1 times.
2015-05-11 11:40:34 INFO OGG-01021 Command received from GGSCI: STATS.
2015-05-11 11:48:58 INFO OGG-01021 Command received from GGSCI: REPORT.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2015-05-11 11:48:58 (activity since 2015-05-11 11:17:02)
Output to ./dirdat/aa:
No records extracted.
***********************************************************************
** Run Time Warnings **
***********************************************************************
EXTRACT esalesaa
------------------------------------
Extract esalesaa
ExtTrail ./dirdat/aa
UserID oggadm1, Password oggadm1
-- TranLogOptions ExcludeUser oggadm1
Table SAPSR3.*;
DATAPUMP psalesab
---------------------------------------------
-- Created by Joe Admin on 10/11/2012
Extract psalesab
RmtHost 10.0.1.180, MgrPort 7811, Compress
RmtTrail ./dirdat/ab
Passthru
Table SAPSR3.*;
GGSCI (v31t6) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING ESALESAA 00:00:00 00:00:02
EXTRACT RUNNING PSALESAB 00:00:00 00:00:08
Please any one help
~