You can ignore your error by just passing the error code in replicat Process.
#if status is abending then go through this.
GGSCI (bld-qa-ts24) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP1 00:00:00 00:00:03
########################################
GGSCI > view report rep1
2016-12-14 11:06:18 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [904],
ORA-00904: "NEW_COL": invalid identifier SQL ALTER TABLE testt1."BB" drop column new_col /*
GGSCI > edit params rep1
REPLICAT rep1
ASSUMETARGETDEFS
USERID ggate, PASSWORD ggate
gettruncates
DDL INCLUDE MAPPED
MAP test1.*, TARGET testt1.*;
############add this line ########
ddlerror 904 ignore ( DDLERROR ((Your error code) "ora-00904" in this case) ignore )
or Add
DDLERROR DEFAULT IGNORE RETRYOP
#Now your params should be like
REPLICAT rep1
ASSUMETARGETDEFS
USERID ggate, PASSWORD ggate
gettruncates
ddlerror 904 ignore
DDL INCLUDE MAPPED
MAP test1.*, TARGET testt1.*;
##### now Exit from editor #####
### Restart your replicat process ###
GGSCI > start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI > info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:03
This is all about this post . Please share your comments
Thanks
~Saurabh Tandon
#if status is abending then go through this.
GGSCI (bld-qa-ts24) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP1 00:00:00 00:00:03
########################################
GGSCI > view report rep1
2016-12-14 11:06:18 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [904],
ORA-00904: "NEW_COL": invalid identifier SQL ALTER TABLE testt1."BB" drop column new_col /*
GGSCI > edit params rep1
REPLICAT rep1
ASSUMETARGETDEFS
USERID ggate, PASSWORD ggate
gettruncates
DDL INCLUDE MAPPED
MAP test1.*, TARGET testt1.*;
############add this line ########
ddlerror 904 ignore ( DDLERROR ((Your error code) "ora-00904" in this case) ignore )
or Add
DDLERROR DEFAULT IGNORE RETRYOP
#Now your params should be like
REPLICAT rep1
ASSUMETARGETDEFS
USERID ggate, PASSWORD ggate
gettruncates
ddlerror 904 ignore
DDL INCLUDE MAPPED
MAP test1.*, TARGET testt1.*;
##### now Exit from editor #####
### Restart your replicat process ###
GGSCI > start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI > info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:03
This is all about this post . Please share your comments
Thanks
~Saurabh Tandon
New casino in the city of Borgata is now fully operational
ReplyDeleteThe Borgata 서산 출장안마 Hotel 상주 출장안마 Casino & Spa and 서귀포 출장마사지 Borgata Hotel Casino & Spa is officially 광주 출장마사지 reopening in June, June 25, the company announced on its 구미 출장샵