- 最后登录
- 2015-3-26
- 在线时间
- 148 小时
- 威望
- 84
- 金钱
- 1061
- 注册时间
- 2011-11-26
- 阅读权限
- 50
- 帖子
- 128
- 精华
- 0
- 积分
- 84
- UID
- 96
|
1#
发表于 2012-1-15 21:20:57
|
查看: 9890 |
回复: 3
imp 在容灾端导入数据后启动进程(start <进程> aftercsn 111),直接abend
ggserr.log 日志 备注:不止这两张表有问题,很多表都是。
2012-01-15 19:49:12 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repea.prm: REPLICAT REPEA started.
2012-01-15 19:49:12 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, repea.prm: Aborted grouped transaction on 'SAPSR3.SWNCMONI', Database error 100 (retrieving bind info for query).
2012-01-15 19:49:12 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repea.prm: Repositioning to rba 893646 in seqno 20.
2012-01-15 19:49:12 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, repea.prm: SQL error 1403 mapping SAPSR3.SWNCMONI to SAPSR3.SWNCMONI.
2012-01-15 19:49:12 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repea.prm: Repositioning to rba 893646 in seqno 20.
2012-01-15 19:49:12 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, repea.prm: Error mapping from SAPSR3.SWNCMONI to SAPSR3.SWNCMONI.
2012-01-15 19:49:12 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repea.prm: PROCESS ABENDING.
2012-01-15 19:58:06 INFO OGG-01670 Oracle GoldenGate Collector: Closing ./dirdat/ea000033.
2012-01-15 19:58:06 INFO OGG-01669 Oracle GoldenGate Collector: Opening ./dirdat/ea000034 (byte -1, current EOF 0).
2012-01-15 20:31:56 WARNING OGG-00947 Oracle GoldenGate Manager for Oracle, mgr.prm: Lag for REPLICAT REPEA is 20:48:45 (checkpoint updated 00:56:47 ago).
2012-01-15 20:31:56 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from GGSUSER.GGS_DDL_HIST older than 2012-01-05 19:31:56.728929: Could not delete rows from GGSUSER.GGS_DDL_HIST, no database specified.
2012-01-15 20:31:56 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from GGSUSER.GGS_DDL_HIST_ALT older than 2012-01-05 19:31:56.729124: Could not delete rows from GGSUSER.GGS_DDL_HIST_ALT, no database specified.
2012-01-15 20:31:56 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from GGSUSER.GGS_MARKER older than 2012-01-05 19:31:56.729742: Could not delete rows from GGSUSER.GGS_MARKER, no database specified.
discarded文件信息
Oracle GoldenGate Delivery for Oracle process stopped, group REPEA : 2012-01-14 11:37:10
Oracle GoldenGate Delivery for Oracle process started, group REPEA discard file opened: 2012-01-15 18:42:22
Current time: 2012-01-15 18:43:10
Discarded record from action ABEND on error 1403
Aborting transaction on ./dirdat/ea beginning at seqno 20 rba 836011
error at seqno 20 rba 836011
Problem replicating SAPSR3.TBTCS to SAPSR3.TBTCS
Record not found
Mapping problem with compressed update record (target format)...
*
JOBNAME = SWWDHEX
JOBCOUNT = 22300900
BTCSYSTEM =
JOBGROUP = %_RETRY_PRE
INTREPORT = %NEWSTEP
SDLSTRTDT = 20120114
SDLSTRTTM = 223258
PRDMINS = 03
PRDHOURS = 00
PRDDAYS = 000
PRDWEEKS = 00
PRDMONTHS = 00
PERIODIC = X
DELANFREP =
EMERGMODE =
SDLUNAME = WF-BATCH
AUTHCKNAM =
AUTHCKMAN = 870
SUCCNUM = 0
EOMCORRECT = 0
JOBCLASS = A
PRIORITY = 0
EXECSERVER =
CALCORRECT = 0
TGTSRVGRP =
*
Process Abending : 2012-01-15 18:43:10
Oracle GoldenGate Delivery for Oracle process started, group REPEA discard file opened: 2012-01-15 18:44:56
Current time: 2012-01-15 18:44:57
Discarded record from action ABEND on error 1403
不知道出错的原因。1、是我们初始化的方法有问题?2、scn号太老?3、trail文件被删除了?
备注:使用SCN号逻辑到出时,生产端抓取进程时开着的。按照整个用户做的导出导入的。 |
|