由于两端数据不一直导致的问题
解决办法
源端：
GGSCI (BJZX-SR2) 42> edit params defgen
-------
defsfile /u01/app/oracle/ogg11/test_pri.p
Userid ogguser, password ogguser
table pioneer.P_DAYEND;
-------
[
oracle@BJZX-SR2 /u01/app/oracle/ogg11]$defgen paramfile ./dirprm/defgen.prm
***********************************************************************
Oracle GoldenGate Table Definition Generator for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
AIX 5L, ppc, 64bit (optimized), Oracle 11g on Apr 23 2012 06:01:35
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2015-08-04 10:35:13
***********************************************************************
Operating System Version:
AIX
Version 6, Release 1
Node: BJZX-SR2
Machine: 00F7B7B74C00
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 34079250
***********************************************************************
** Running with the following parameters **
***********************************************************************
defsfile /u01/app/oracle/ogg11/test_pri.p
Userid ogguser, password *******
table pioneer.P_DAYEND;
Retrieving definition for PIONEER.P_DAYEND
把文件传输到目标端
scp test_pri.p oracle@192.168.11.61:/u01/app/oracle/ogg11
目标端
GGSCI (dbpay) 11> edit params R_PIONER
--------
REPLICAT r_pioner
--DBOPTIONS ALLOWUNUSEDCOLUMN
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID system, password SV8_ppsystem2014
HANDLECOLLISIONS
--ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/R_PIONER.DSC, append, megabytes 10
sourcedefs /u01/app/oracle/ogg11/test_pri.p
APPLYNOOPUPDATES
GETTRUNCATES
GETUPDATES
Dynamicresolution
DDL INCLUDE ALL
DBOPTIONS DEFERREFCONST
DBOPTIONS SUPPRESSTRIGGERS
DDLERROR DEFAULT IGNORE RETRYOP
Tableexclude pioneer.SYS_EXPORT_SCHEMA_*
Tableexclude pioneer.SYS_EXPORT_TABLE_*
Tableexclude pioneer.SYS_IMPORT*
MAP pioneer.* , TARGET pioneer.*;
---------
阅读(6372) | 评论(0) | 转发(0) |
