maxbytes oracle,OGG-01172 exceeded max bytes (-1294967296)

本帖最后由 gangade 于 2017-3-6 22:53 编辑

下面是repl.dsc内容：

OCI Error ORA-00001: unique constraint (US_MBADMIN_XCBP.PK_T_WH_CZRZ) violated

ORA-06512: at "US_MBADMIN_XCBP.Q_SVR_DETONATOR", line 12

ORA-04088: error during execution of trigger 'US_MBADMIN_XCBP.Q_SVR_DETONATOR' (status = 1). INSERT INTO "US_MBADMIN_XCBP"."T_SVR_DETONATOR" ("WORKID","DETONATORNAME","DETONATORSTAGE","DETONATORPLAN","DETONATORFACT","DETONATORDESTROY","DETONATORCLEAN","STATUS","DESIGNID","ID","DETONATORGGXH","DETONATORTYPE") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11)

Operation failed at seqno 83 rba 11960754

Discarding record on action DISCARD on error 1

Problem replicating US_MBADMIN_XCBP.T_SVR_DETONATOR to US_MBADMIN_XCBP.T_SVR_DETONATOR

Mapping problem with insert record (target format)...

*

WORKID = NULL

DETONATORNAME =

000000: c3 ba bf f3 d0 ed d3 c3 cb b2 b7 a2 b5 e7 c0 d7 |................|

000010: b9 dc                                           |..              |

DETONATORSTAGE = NULL

DETONATORPLAN = 6

DETONATORFACT = NULL

DETONATORDESTROY = NULL

DETONATORCLEAN = NULL

STATUS = 0

DESIGNID = 1488754763306531486

ID = 1488754763306359511

DETONATORGGXH =

000000: 38 ba c5 b7 a2 c0 b6 bf c7                      |8........       |

DETONATORTYPE = X00

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-00001: unique constraint (US_MBADMIN_XCBP.PK_T_WH_CZRZ) violated

ORA-06512: at "US_MBADMIN_XCBP.Q_SVR_DETONATOR", line 12

ORA-04088: error during execution of trigger 'US_MBADMIN_XCBP.Q_SVR_DETONATOR' (status = 1). INSERT INTO "US_MBADMIN_XCBP"."T_SVR_DETONATOR" ("WORKID","DETONATORNAME","DETONATORSTAGE","DETONATORPLAN","DETONATORFACT","DETONATORDESTROY","DETONATORCLEAN","STATUS","DESIGNID","ID","DETONATORGGXH","DETONATORTYPE") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11)

Operation failed at seqno 83 rba 11961259

Discarding record on action DISCARD on error 1

Problem replicating US_MBADMIN_XCBP.T_SVR_DETONATOR to US_MBADMIN_XCBP.T_SVR_DETONATOR

Mapping problem with insert record (target format)...

*

WORKID = NULL

DETONATORNAME =

000000: c6 d5 cd a8 ba c1 c3 eb b5 bc b1 ac b9 dc c0 d7 |................|

000010: b9 dc                                           |..              |

DETONATORSTAGE = NULL

DETONATORPLAN = 48

DETONATORFACT = NULL

DETONATORDESTROY = NULL

DETONATORCLEAN = NULL

STATUS = 0

DESIGNID = 1488754763306531486

ID = 1488754763308620893

DETONATORGGXH = 5M

DETONATORTYPE = r00

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-00001: unique constraint (US_MBADMIN_XCBP.PK_T_WH_CZRZ) violated

ORA-06512: at "US_MBADMIN_XCBP.Q_SVR_EXPLOSIVE", line 12

ORA-04088: error during execution of trigger 'US_MBADMIN_XCBP.Q_SVR_EXPLOSIVE' (status = 1). INSERT INTO "US_MBADMIN_XCBP"."T_SVR_EXPLOSIVE" ("WORKID","EXPLOSIVENAME","EXPLOSIVEPLAN","EXPLOSIVEFACT","EXPLOSIVEDESTROY","EXPLOSIVECLEAN","STATUS","DESIGNID","ID","EXPLOSIVETYPE","EXPLOSIVEGGXH","EXPLOSIVEGGXHTYPE") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11)

Operation failed at seqno 83 rba 11961758

Discarding record on action DISCARD on error 1

Problem replicating US_MBADMIN_XCBP.T_SVR_EXPLOSIVE to US_MBADMIN_XCBP.T_SVR_EXPLOSIVE

Mapping problem with insert record (target format)...

*

WORKID = NULL

EXPLOSIVENAME =

000000: b6 fe ba c5 d1 d2 ca af c8 e9 bb af d5 a8 d2 a9 |................|

EXPLOSIVEPLAN = 72

EXPLOSIVEFACT = NULL

EXPLOSIVEDESTROY = NULL

EXPLOSIVECLEAN = NULL

STATUS = 0

DESIGNID = 1488754763306531486

ID = 1488754763308180698

EXPLOSIVETYPE = 02W

EXPLOSIVEGGXH =

000000: a6 b5 33 32                                     |..32            |

EXPLOSIVEGGXHTYPE = 0

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-00001: unique constraint (US_MBADMIN_XCBP.PK_T_WH_CZRZ) violated

ORA-06512: at "US_MBADMIN_XCBP.Q_SVR_DESIGN_DKXX", line 12

ORA-04088: error during execution of trigger 'US_MBADMIN_XCBP.Q_SVR_DESIGN_DKXX' (status = 1). INSERT INTO "US_MBADMIN_XCBP"."T_SVR_DESIGN_DKXX" ("DESIGNID","XH","KBH","KJ","DKYL","KS","CHAOSHEN","DSCD","ZYCD","PDJ","BPJ","ZKJD","STATUS") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12)

Operation failed at seqno 83 rba 11962279

Discarding record on action DISCARD on error 1

Problem replicating US_MBADMIN_XCBP.T_SVR_DESIGN_DKXX to US_MBADMIN_XCBP.T_SVR_DESIGN_DKXX

Mapping problem with insert record (target format)...

*

DESIGNID = 1488754763306531486

XH = 1

KBH = 1-1

KJ = 40.0

DKYL = 1.5

KS = 2.5

CHAOSHEN = .2

DSCD = .5

ZYCD = 1.5

PDJ = 5.0

BPJ = 85.0

ZKJD = 5.0

STATUS = 0

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-00001: unique constraint (US_MBADMIN_XCBP.PK_T_WH_CZRZ) violated

ORA-06512: at "US_MBADMIN_XCBP.Q_SVR_DESIGN", line 12

ORA-04088: error during execution of trigger 'US_MBADMIN_XCBP.Q_SVR_DESIGN' (status = 1). INSERT INTO "US_MBADMIN_XCBP"."T_SVR_DESIGN" ("DESIGNID","HOLETYPE","HOLEDISTANCE","ROWDISTANCE","ROWNUMBER","TOTALHOLENUMBER","AVERAGEHOLEDEPTH","MAXEXPNUMOFHOLE","MAXEXPNUMOFBANG","EXPNUMOFBANG","STUFF","FILLTYPE","CONNECTTYPE","CONNECTSUFF","CONNECTSUFFNUM","DETONATINGCORD","DESIGNFLYDISTANCE","VIBRATIONVELOCITY","VVFACTORK","VVFACTORA","NETWORKCHART","DESIGNER","OPERATOR","OPERATETIME","QYDM","XZQH","AUDITORID","AUDITORTIME","APPROVERID","APPROVERTIME","STATUS","DISPATCHSTATUS","DWDM","PLATFORMHEIGHT","NAME","DPDKX","SBDKX","BYZMDISTANCE","BYCMDISTANCE","BYHMDISTANCE","QBFS","USERID","PGFZR","PGFZRXM","PGFZRLXDH") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13,:a14,:a15,:a16,:a17,:a18,:a19,:a20,:a21,:a22,:a23,:a24,:a25,:a26,:a27,:a28,:a29,:a30,:a31,:a32,:a33,:a34,

Operation failed at seqno 83 rba 11962802

Discarding record on action DISCARD on error 1

Problem replicating US_MBADMIN_XCBP.T_SVR_DESIGN to US_MBADMIN_XCBP.T_SVR_DESIGN

Mapping problem with insert record (target format)...

*

DESIGNID = 1488754763306531486

HOLETYPE = 1

HOLEDISTANCE = .2

ROWDISTANCE = 3

ROWNUMBER = 3

TOTALHOLENUMBER = 48

AVERAGEHOLEDEPTH = 2.5

MAXEXPNUMOFHOLE = 1.5

MAXEXPNUMOFBANG = 1.5

EXPNUMOFBANG = NULL

STUFF =

000000: c4 e0 cd c1                                     |....            |

FILLTYPE = 0

CONNECTTYPE = 0

CONNECTSUFF =

000000: b5 bc b5 e7 cf df                               |......          |

CONNECTSUFFNUM = 54

DETONATINGCORD = NULL

DESIGNFLYDISTANCE = NULL

VIBRATIONVELOCITY = NULL

VVFACTORK = NULL

VVFACTORA = NULL

NETWORKCHART = NULL

DESIGNER =

000000: d5 d4 c3 f7                                     |....            |

OPERATOR = MB010430300000000002

OPERATETIME = 2017-03-06 00:00:00

QYDM = MB010430300000000

XZQH = 500236

AUDITORID =

000000: b7 d1 cf c8 c3 f7                               |......          |

AUDITORTIME = 2017-03-06 00:00:00

APPROVERID =

000000: b7 d1 cf c8 c3 f7                               |......          |

APPROVERTIME = 2017-03-06 00:00:00

STATUS = 0

DISPATCHSTATUS = 0

DWDM = 5002363300002

PLATFORMHEIGHT = 5

NAME =

000000: 33 30 36 b4 f3 ba e9 c9 bd                      |306......       |

DPDKX = NULL

SBDKX = NULL

BYZMDISTANCE = 200.0

BYCMDISTANCE = 200.0

BYHMDISTANCE = 200.0

QBFS = 0

USERID = MB010430300000000002

PGFZR = NULL

PGFZRXM =

000000: d5 d4 c3 f7                                     |....            |

PGFZRLXDH = 15870425789

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-01403: no data found, SQL

Operation failed at seqno 83 rba 11964124

Discarding record on action DISCARD on error 1403

Problem replicating US_MBADMIN_XCBP.T_SVR_PLAN_GQ to US_MBADMIN_XCBP.T_SVR_PLAN_GQ

Record not found

Mapping problem with compressed update record (target format)...

*

PLANID =

XH =

SFSZSGFA = 1

DESIGNID = 1488754763306531486

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-00001: unique constraint (US_MBADMIN_XCBP.PK_T_WH_CZRZ) violated

ORA-06512: at "US_MBADMIN_XCBP.Q_SVR_PLAN", line 12

ORA-04088: error during execution of trigger 'US_MBADMIN_XCBP.Q_SVR_PLAN' (status = 1). INSERT INTO "US_MBADMIN_XCBP"."T_SVR_PLAN" ("PLANID","PROJECTID","PROJECTNAME","PROJECTLEVEL","WORKADDRESS","WORKAREA","CONTRACTID","CONTRACTNAME","PLANTIME","WORKSTARTTIME","PLANNERID","PLANNERNAME","FIRSTPARTY","DEPARTMENTID","DEPARTMENT","XZQH","STATUS","PLANSTATUS","QYDM","DWDM","WORKADDRESSID","WORKENDTIME","NAME","OPERATOR","OPERATEDTIME","USERID","FASJR","FASJRXM","FASJRLXDH","YZLXDH","JLDWMC","JLDWDM","JLDWXMLXR","JLDWXMLXRLXDH") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13,:a14,:a15,:a16,:a17,:a18,:a19,:a20,:a21,:a22,:a23,:a24,:a25,:a26,:a27,:a28,:a29,:a30,:a31,:a32,:a33)

Operation failed at seqno 83 rba 11964881

Discarding record on action DISCARD on error 1

Problem replicating US_MBADMIN_XCBP.T_SVR_PLAN to US_MBADMIN_XCBP.T_SVR_PLAN

Mapping problem with insert record (target format)...

*

PLANID = 1488754793491704442

PROJECTID = NULL

PROJECTNAME = NULL

PROJECTLEVEL = NULL

WORKADDRESS = NULL

WORKAREA = NULL

CONTRACTID = NULL

CONTRACTNAME = NULL

PLANTIME = NULL

WORKSTARTTIME = 2017-03-06 00:00:00

PLANNERID = MB010720100000000006

PLANNERNAME = dds

FIRSTPARTY = NULL

DEPARTMENTID = NULL

DEPARTMENT = NULL

XZQH = 500382

STATUS = 0

PLANSTATUS = 0

QYDM = MB010720100000000

DWDM = 5003824300061

WORKADDRESSID = NULL

WORKENDTIME = 2017-03-06 00:00:00

NAME =

000000: 32 30 31 37 30 33 30 36 d4 e7 2d 33 31 30 bb fe |20170306..-310..|

000010: b6 b7 be ae d0 b1 be ae                         |........        |

OPERATOR = dds

OPERATEDTIME = 2017-03-06 06:59:53

USERID = MB010720100000000006

FASJR = 113728

FASJRXM =

000000: d6 ec c0 b4 bd f0                               |......          |

FASJRLXDH = 15823050566

YZLXDH = 42702660

JLDWMC = NULL

JLDWDM = NULL

JLDWXMLXR = NULL

JLDWXMLXRLXDH = NULL

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-00001: unique constraint (US_MBADMIN_XCBP.PK_T_WH_CZRZ) violated

ORA-06512: at "US_MBADMIN_XCBP.Q_SVR_PLAN_GQ", line 12

ORA-04088: error during execution of trigger 'US_MBADMIN_XCBP.Q_SVR_PLAN_GQ' (status = 1). INSERT INTO "US_MBADMIN_XCBP"."T_SVR_PLAN_GQ" ("PLANID","XH","GQBH","GQMC","ZYSM","STATUS","SFSZSGFA","DESIGNID","ZYDXZQH") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8)

Operation failed at seqno 83 rba 11965732

Discarding record on action DISCARD on error 1

Problem replicating US_MBADMIN_XCBP.T_SVR_PLAN_GQ to US_MBADMIN_XCBP.T_SVR_PLAN_GQ

Mapping problem with insert record (target format)...

*

PLANID = 1488754793491704442

XH = 14849

GQBH = NULL

GQMC =

000000: d1 ce be ae d2 bb bf f3                         |........        |

ZYSM =

STATUS = 0

SFSZSGFA = NULL

DESIGNID = NULL

ZYDXZQH = 500382

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-00001: unique constraint (US_MBADMIN_XCBP.PK_T_WH_CZRZ) violated

ORA-06512: at "US_MBADMIN_XCBP.Q_SVR_PLAN", line 12

ORA-04088: error during execution of trigger 'US_MBADMIN_XCBP.Q_SVR_PLAN' (status = 1). INSERT INTO "US_MBADMIN_XCBP"."T_SVR_PLAN" ("PLANID","PROJECTID","PROJECTNAME","PROJECTLEVEL","WORKADDRESS","WORKAREA","CONTRACTID","CONTRACTNAME","PLANTIME","WORKSTARTTIME","PLANNERID","PLANNERNAME","FIRSTPARTY","DEPARTMENTID","DEPARTMENT","XZQH","STATUS","PLANSTATUS","QYDM","DWDM","WORKADDRESSID","WORKENDTIME","NAME","OPERATOR","OPERATEDTIME","USERID","FASJR","FASJRXM","FASJRLXDH","YZLXDH","JLDWMC","JLDWDM","JLDWXMLXR","JLDWXMLXRLXDH") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13,:a14,:a15,:a16,:a17,:a18,:a19,:a20,:a21,:a22,:a23,:a24,:a25,:a26,:a27,:a28,:a29,:a30,:a31,:a32,:a33)

Operation failed at seqno 83 rba 11967649

Discarding record on action DISCARD on error 1

Problem replicating US_MBADMIN_XCBP.T_SVR_PLAN to US_MBADMIN_XCBP.T_SVR_PLAN

Mapping problem with insert record (target format)...

*

PLANID = 1488754824892302338

PROJECTID = NULL

PROJECTNAME = NULL

PROJECTLEVEL = NULL

WORKADDRESS = NULL

WORKAREA = NULL

CONTRACTID = NULL

CONTRACTNAME = NULL

PLANTIME = NULL

WORKSTARTTIME = 2017-03-06 00:00:00

PLANNERID = MB010720100000000006

PLANNERNAME = dds

FIRSTPARTY = NULL

DEPARTMENTID = NULL

DEPARTMENT = NULL

XZQH = 500382

STATUS = 0

PLANSTATUS = 0

QYDM = MB010720100000000

DWDM = 5003824300061

WORKADDRESSID = NULL

WORKENDTIME = 2017-03-06 00:00:00

NAME =

000000: 32 30 31 37 30 33 30 36 d4 e7 32 31 34 30 31 bf |20170306..21401.|

000010: aa c7 d0 d1 db                                  |.....           |

OPERATOR = dds

OPERATEDTIME = 2017-03-06 07:00:24

USERID = MB010720100000000006

FASJR = 113728

FASJRXM =

000000: d6 ec c0 b4 bd f0                               |......          |

FASJRLXDH = 15823050566

YZLXDH = 42702660

JLDWMC = NULL

JLDWDM = NULL

JLDWXMLXR = NULL

JLDWXMLXRLXDH = NULL

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-00001: unique constraint (US_MBADMIN_XCBP.PK_T_WH_CZRZ) violated

ORA-06512: at "US_MBADMIN_XCBP.Q_SVR_PLAN_GQ", line 12

ORA-04088: error during execution of trigger 'US_MBADMIN_XCBP.Q_SVR_PLAN_GQ' (status = 1). INSERT INTO "US_MBADMIN_XCBP"."T_SVR_PLAN_GQ" ("PLANID","XH","GQBH","GQMC","ZYSM","STATUS","SFSZSGFA","DESIGNID","ZYDXZQH") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8)

Operation failed at seqno 83 rba 11968497

Discarding record on action DISCARD on error 1

Problem replicating US_MBADMIN_XCBP.T_SVR_PLAN_GQ to US_MBADMIN_XCBP.T_SVR_PLAN_GQ

Mapping problem with insert record (target format)...

*

PLANID = 1488754824892302338

XH = 14849

GQBH = NULL

GQMC =

000000: d1 ce be ae d2 bb bf f3                         |........        |

ZYSM =

STATUS = 0

SFSZSGFA = NULL

DESIGNID = NULL

ZYDXZQH = 500382

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-01403: no data found, SQL

Operation failed at seqno 83 rba 11969890

Discarding record on action DISCARD on error 1403

Problem replicating US_MBADMIN_YUN.T_SVR_SERVICE to US_MBADMIN_YUN.T_SVR_SERVICE

Record not found

Mapping problem with compressed update record (target format)...

*

SERVICEID =

SERVICENAME =

000000: b1 ac c6 c6 d7 f7 d2 b5 bc c6 bb ae             |............    |

STATUS = 1

PRICE = 1000

SERVICETYPE = 01

SERVICEDESC =

000000: b1 ac c6 c6 d7 f7 d2 b5 bc c6 bb ae             |............    |

URL = http://[ip]:8090/mbxcbp/plan/planlist.action

PRICEUNIT = 01

SERVICETYPENAME =

000000: b1 ac c6 c6 d7 f7 d2 b5 b9 dc c0 ed b7 fe ce f1 |................|

SERVICESOURCE = 01

INPUT =

000000: b7 fe ce f1 ca e4 c8 eb                         |........        |

OUTPUT =

000000: b7 fe ce f1 ca e4 c8 eb                         |........        |

SERVICESUPPLIER = 1

SORT = 2

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-01403: no data found, SQL

Operation failed at seqno 83 rba 11970248

Discarding record on action DISCARD on error 1403

Problem replicating US_MBADMIN_YUN.T_SVR_SERVICE to US_MBADMIN_YUN.T_SVR_SERVICE

Record not found

Mapping problem with compressed update record (target format)...

*

SERVICEID =

SERVICENAME =

000000: b1 ac c6 c6 d7 f7 d2 b5 ca b5 ca a9 28 b5 a5 b1 |............(...|

000010: f8 c9 e8 b1 b8 29                               |.....)          |

STATUS = 1

PRICE = 1000

SERVICETYPE = 01

SERVICEDESC = 111

URL = http://[ip]:8090/mbxcbp/dispatch/planGqDbsblist.action

PRICEUNIT = 01

SERVICETYPENAME =

000000: b1 ac c6 c6 d7 f7 d2 b5 b9 dc c0 ed b7 fe ce f1 |................|

SERVICESOURCE = 01

INPUT =

000000: b7 fe ce f1 ca e4 c8 eb                         |........        |

OUTPUT =

000000: b7 fe ce f1 ca e4 b3 f6                         |........        |

SERVICESUPPLIER = 1

SORT = 5

*

Current time: 2017-03-06 09:47:31

OCI Error ORA-01403: no data found, SQL

Operation failed at seqno 83 rba 11970591

Discarding record on action DISCARD on error 1403

Problem replicating US_MBADMIN_YUN.T_SVR_SERVICE to US_MBADMIN_YUN.T_SVR_SERVICE

Record not found

Mapping problem with compressed update record (target format)...

*

SERVICEID =

SERVICENAME =

000000: b1 ac c6 c6 d7 f7 d2 b5 cf d6 b3 a1 d7 f7 d2 b5 |................|

000010: 28 b5 a5 b1 f8 c9 e8 b1 b8 29                   |(........)      |

STATUS = 1

PRICE = 1000

SERVICETYPE = 01

SERVICEDESC = 111

URL = http://[ip]:8090/mbxcbp/work/workdbsblist.action

PRICEUNIT = 01

SERVICETYPENAME =

000000: b1 ac c6 c6 d7 f7 d2 b5 b9 dc c0 ed b7 fe ce f1 |................|

SERVICESOURCE = 01

INPUT =

000000: b7 fe ce f1 ca e4 c8 eb                         |........        |

OUTPUT =

000000: b7 fe ce f1 ca e4 b3 f6                         |........        |

SERVICESUPPLIER = 1

SORT = 8

*

Current time: 2017-03-06 09:47:31

其中，报唯一约束错误(ORA-00001: unique constraint)274处；

报没有数据错误(OCI Error ORA-01403: no data found)2136833处，其中，Error ORA-01403: no data found, SQL

我的配置文件为：

GGSCI (iZ28rxqbnr3Z) 2> edit params  repl

replicat repl

userid ogg,password ogg

assumetargetdefs

reperror default,discard

discardfile /u01/app/oracle/ogg/dirrpt/repl.dsc,append,megabytes 8000

dynamicresolution

APPLYNOOPUPDATES

ddloptions report

ddlerror default ignore retryop maxretries 3 retrydelay 5

ddlerror default discard

ddlerror default ignore retryop

map US_MBADMIN_XCBP.*, target US_MBADMIN_XCBP.*;

map US_MBADMIN_SSO.*, target US_MBADMIN_SSO.*;

map US_MBDZLG.*, target US_MBDZLG.*;

map US_MBADMIN_XSH.*, target US_MBADMIN_XSH.*;

map US_MBADMIN_FWZX.*, target US_MBADMIN_FWZX.*;

map US_MBADMIN_CRK.*, target US_MBADMIN_CRK.*;

map US_MBDZLGTXZX.*, target US_MBDZLGTXZX.*;

map US_MBADMIN_DXPT.*, target US_MBADMIN_DXPT.*;

map US_MBADMIN_YSCL.*, target US_MBADMIN_YSCL.*;

map US_MBADMIN_YUN.*, target US_MBADMIN_YUN.*;

那我只能使用笨的方法，在repl.dsc日志里面找到所有违反唯一和无数据的表，然后在目标端drop掉，然后ogg就能自动同步过来吧，这样问题就能解决了吗？PS：下午5点目标端repl进程又一次挂起，提醒：2017-03-06 17:20:42  ERROR   OGG-01172  Discard file (/u01/app/oracle/ogg/dirrpt/repl.dsc) exceeded max bytes (-589934592).