Hi GG Gurus
Today I have received below alert on goldgen gate. why did we receive the alert and please let me know how to fix it? I have pasted the .prm file.
MANAGER RUNNING
!!!Found error(s) in /GG/product/11.2.1/gghome11/ggserr.log on ***topd01 since last check!!!
< 129:2014-03-24 22:18:44: INFO OGG-01487 Oracle GoldenGate Capture for Oracle, ****.prm: DDL found, operation [ create table "***_E911".DBMS_***_TEMP_UNCMP tablespace "***_E911_DATA" nologging as select /*+ FULL("***_E911"."ALI_ERROR") */ * from "TOSS_E911"."ALI_ERROR" sample block( 5.12) mytab (size 195)], start SCN [11007940193133], commit SCN [11007940193461] instance [***OPS1 (1)], DDL seqno [130721], marker seqno [122221]..
> cat ***psex.prme dba 4096 Oct 30 13:27 ***OPS/
EXTRACT ***OPSEXrmPS1 | /GG/product/11.2.1/gghome11/dirprm
-- Setup Environment Variables --
include /GG/product/11.2.1/gghome11/dirprm/***OPS/Env_variables_setup.prm
-- Setup Global Parameters for Extract ***OPSEX --
TRANLOGOPTIONS LOGRETENTION DISABLED
include /GG/product/11.2.1/gghome11/dirprm/***OPS/TELOPSEX_Extract_Global.prm
-- Mapping file for tables to be Replicated
include /GG/product/11.2.1/gghome11/dirprm/***OPS/TELOPSEX_Extract_Table_Mapping.prm
-- Mapping file for Heart Beat Tables to be Replicated
include /GG/product/11.2.1/gghome11/dirprm/***OPS/TELOPSEX_Heartbeat_Extract_Mapping.prm
Regards
Geeta M