Am using 2 extracts,data pump & replicat processes it was working all along but just an hour back onwards it wasn't replicating..
I could see the status for extracts , data pumps and replicats as RUNNING. In machine 1 , I have 2 extracts & 2 data datapumps running , in machine 2, I've 2 replicats are running.
When I do stats ext lhrdev1 it was showing the no. of records inserted, updated, deleted whereas for the same lhrdev1 extract nothing was displaying when I do stats rhrdev1 (replicat) in the target machine.
Can someone help me in fixing this up.
================================================================================
Source System
================================================================================
EXTRACT LHRDEV1
USERID GGS, PASSWORD GGS
EXTTRAIL E:\Oracle_GoldenGate\V22232-01\dirdat\L1
DDL INCLUDE MAPPED
--DDLOPTIONS REPORT
DDLOPTIONS ADDTRANDATA
-- this to get the report
--REPORT AT 8:00
--REPORTCOUNT EVERY 60 MINUTES, RATE
--REPORTROLLOVER AT 08:00 ON MONDAY
--discard file is to track the error
DISCARDFILE E:\Oracle_Goldengate\V22232-01\dirchk\OGGdiscard1.dsc, APPEND, MEGABYTES 50
TABLE HR.REGIONS;
TABLE HR.COUNTRIES;
TABLE HR.LOCATIONS;
TABLE HR.DEPARTMENTS;
EXTRACT LHRDEV2
USERID GGS, PASSWORD GGS
EXTTRAIL E:\Oracle_GoldenGate\V22232-01\dirdat\E2
DDL INCLUDE MAPPED
--DDLOPTIONS REPORT
DDLOPTIONS ADDTRANDATA
DISCARDFILE E:\Oracle_Goldengate\V22232-01\dirchk\OGGdiscardE2.dsc, APPEND, MEGABYTES 50
TABLE HR.JOBS;
TABLE HR.JOB_HISTORY;
TABLE HR.EMPLOYEES;
Data Pump - Two data pumps configured
===========================================
-- Data pump
EXTRACT PHRDEV1
-- below passthru parameter instructs GG that it would just pass the data there
-- are no transformations required
EXTRACT PHRDEV1
PASSTHRU
RMTHOST Sathiya-PC, MGRPORT 7809
-- RMTHOST 192.168.1.2, MGRPORT 7809
RMTTRAIL E:\GoldenGate\V22232-01\dirdat\P1,MEGABYTES 100
TABLE HR.REGIONS;
TABLE HR.COUNTRIES;
TABLE HR.LOCATIONS;
TABLE HR.DEPARTMENTS;
-- Data pump 2
EXTRACT PHRDEV2
USERID ggs, PASSWORD ggs
-- below passthru parameter instructs GG that it would just pass the data there
-- are no transformations required
RMTHOST Sathiya-PC, MGRPORT 7809
-- RMTHOST 192.168.1.2, MGRPORT 7809
RMTTRAIL E:\GoldenGate\V22232-01\dirdat\P2, megabytes 100
TABLE HR.JOBS;
TABLE HR.JOB_HISTORY;
TABLE HR.EMPLOYEES;
GGSCI (SathiyaKumar-PC) 18> stats ext lhrdev1
Sending STATS request to EXTRACT LHRDEV1 ...
Start of Statistics at 2013-07-02 21:14:41.
DDL replication statistics (for all trails):
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING LHRDEV1 00:00:00 00:00:00
EXTRACT RUNNING LHRDEV2 00:00:00 00:00:00
EXTRACT RUNNING PHRDEV1 00:00:00 00:00:00
EXTRACT RUNNING PHRDEV2 00:00:00 00:00:02
*** Total statistics since extract started ***
Operations 0.00
Mapped operations 0.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
Output to E:\Oracle_GoldenGate\V22232-01\dirdat\L1:
Extracting from HR.REGIONS to HR.REGIONS:
*** Total statistics since 2013-07-02 21:02:05 ***
Total inserts 1.00
Total updates 0.00
Total deletes 1.00
Total discards 0.00
Total operations 2.00
*** Daily statistics since 2013-07-02 21:02:05 ***
Total inserts 1.00
Total updates 0.00
Total deletes 1.00
Total discards 0.00
Total operations 2.00
*** Hourly statistics since 2013-07-02 21:02:05 ***
Total inserts 1.00
Total updates 0.00
Total deletes 1.00
Total discards 0.00
Total operations 2.00
*** Latest statistics since 2013-07-02 21:02:05 ***
Total inserts 1.00
Total updates 0.00
Total deletes 1.00
Total discards 0.00
Total operations 2.00
End of Statistics.
================================================================================
TARGET SYSTEM
================================================================================
REPLICAT RHRDEV1
USERID GGS, PASSWORD GGS
--NOHANDLECOLLISIONS
AssumeTargetDefs
DDL INCLUDE ALL
DISCARDFILE E:\Goldengate\V22232-01\dirchk\OGGdiscardR1.dsc, APPEND, MEGABYTES 50
Map HR.REGIONS, Target HR.REGIONS;
Map HR.COUNTRIES, Target HR.COUNTRIES;
Map HR.LOCATIONS, Target HR.LOCATIONS;
Map HR.DEPARTMENTS, Target HR.DEPARTMENTS;
REPLICAT RHRDEV2
USERID GGS, PASSWORD GGS
AssumeTargetDefs
NOHANDLECOLLISIONS
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE RETRYOP
DISCARDFILE E:\Goldengate\V22232-01\dirchk\OGGdiscardR2.dsc, APPEND, MEGABYTES 50
Map HR.JOBS, Target HR.JOBS;
Map HR.JOB_HISTORY, Target HR.JOB_HISTORY;
Map HR.EMPLOYEES, Target HR.EMPLOYEES;
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RHRDEV1 00:00:00 00:00:01
REPLICAT RUNNING RHRDEV2 00:00:00 00:00:06
GGSCI (Sathiya-PC) 16> stats rhrdev1
Sending STATS request to REPLICAT RHRDEV1 ...
No active replication maps
DDL replication statistics:
GGSCI (SathiyaKumar-PC) 19> info all
*** Total statistics since replicat started ***
Operations 0.00
Mapped operations 0.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
Errors 0.00
Retried errors 0.00
Discarded errors 0.00
Ignored errors 0.00
GGSCI (Sathiya-PC) 17>