oracle的ogg与tdt,OGG逻辑导入导出(exp、imp)初始化失败

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号逻辑到出时,生产端抓取进程时开着的。按照整个用户做的导出导入的。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值