Home » Server Options » Replication » Replicate process abended (11g R1 Linux 64bit)
Replicate process abended [message #567665] Thu, 04 October 2012 02:29
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hello Expert,

I have configured additional replicate for some more tables. below is the parameter. It was working fine before but getting abended and prompting error to some new table that is not in the parameter.

Parameter
[ggate@ccldclmdb1 dirprm]$ cat bpm.prm
REPLICAT BPM
ASSUMETARGETDEFS
USERID ggadmin@CCLENBD1, PASSWORD ***** SYSDBA
DISCARDFILE /oraggate/ggate/software/enb/dirrpt/bpm_discard.txt, append, megabytes 20
IGNOREDELETES
--REPERROR 1403, discard
--MAP comappo.TABLE_BPM_PROC_INST,TARGET com1appo.TABLE_BPM_PROC_INST_ARC;
REPERROR (-1, IGNORE);
MAP comappo.TABLE_BPM_STEP_INST, TARGET com1appo.TABLE_BPM_STEP_INST_ARC;
-- REPERROR (-1, IGNORE);
--MAP comappo.TABLE_BPM_CONTEXT, target com1appo.TABLE_BPM_CONTEXT_ARC;
-- REPERROR (-1, IGNORE);
--MAP comappo.TABLE_BPM_FAULT_INFO_HIST, com1appo.TABLE_BPM_FAULT_INFO_HIST_ARC;
-- REPERROR (-1, IGNORE);
--IGNOREDELETES
DDLOPTIONS MAPSESSIONSCHEMA COMAPPO TARGET COM1APPO
DDLOPTIONS MAPSESSIONSCHEMA COMAPPC TARGET COM1APPC
DDLOPTIONS MAPSESSIONSCHEMA COMREFWAIT TARGET COM1REFWAIT
DDLOPTIONS MAPSESSIONSCHEMA COMREFWORK TARGET COM1REFWORK
DDLOPTIONS MAPSESSIONSCHEMA GGTEST TARGET GGTESTR
[ggate@ccldclmdb1 dirprm]$


Error:
2012-10-04 03:17:52  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, bpm.prm:  REPLICAT BPM starting.
2012-10-04 03:17:52  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, bpm.prm:  REPLICAT BPM started.
2012-10-04 03:17:52  INFO    OGG-01562  Oracle GoldenGate Delivery for Oracle, bpm.prm:  Source schema COMREFWAIT is mapped to target schema COM1REFWAIT to set the current schema for DDL execution.
2012-10-04 03:17:52  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, bpm.prm:  Setting current schema for DDL operation to [COM1REFWAIT].
2012-10-04 03:17:52  ERROR   OGG-00519  Oracle GoldenGate Delivery for Oracle, bpm.prm:  Fatal error executing DDL replication: error [Error code [942], ORA-00942: table or view does not exist, SQL ALTER TABLE TRB1_AUDIT_SUB_LOG TRUNCATE PARTITION P2_S3008_A6000_R3 UPDATE INDEXES  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
2012-10-04 03:17:52  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, bpm.prm:  PROCESS ABENDING.
Previous Topic: Creation of Materialized view from oracle 10g - 8i (merged)
Next Topic: Oracle Golden Gate architacture and maping
Goto Forum:
  


Current Time: Fri Aug 29 11:59:55 CDT 2014

Total time taken to generate the page: 0.26006 seconds