Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

84

积分

1

好友

27

主题
1#
发表于 2012-1-15 21:20:57 | 查看: 9889| 回复: 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号逻辑到出时,生产端抓取进程时开着的。按照整个用户做的导出导入的。
2#
发表于 2012-1-15 21:27:16
Discarded record from action ABEND on error 1403


ORA-1403 can be caused by several reason:


Action Plan:

1.    INFO TRANDATA schema.table_name   -- check source table trandata
2.    try disable target table trigger or foreign key
3.    try add handlecollisions to rep

回复 只看该作者 道具 举报

3#
发表于 2012-1-15 21:40:05

回复 只看该作者 道具 举报

4#
发表于 2012-1-15 21:53:46
info trandata
GGSCI (eisdb01) 10> info trandata SAPSR3.MONI

Logging of supplemental redo log data is enabled for table SAPSR3.MONI

GGSCI (eisdb01) 11> info trandata SAPSR3.TBTCP

Logging of supplemental redo log data is enabled for table SAPSR3.TBTCP

GGSCI (eisdb01) 12> info trandata SAPSR3.SWNCMONI

Logging of supplemental redo log data is enabled for table SAPSR3.SWNCMONI

add handlecollisions   (ggserr.log)
2012-01-15 21:50:25  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (orap01): start repea.
2012-01-15 21:50:25  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 10.100.195.7 (START REPLICAT REPEA ).
2012-01-15 21:50:25  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REPEA starting.
2012-01-15 21:50:25  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, repea.prm:  REPLICAT REPEA starting.
2012-01-15 21:50:26  INFO    OGG-00893  Oracle GoldenGate Delivery for Oracle, repea.prm:  SQL statement executed successfully.
2012-01-15 21:50:26  ERROR   OGG-01744  Oracle GoldenGate Delivery for Oracle, repea.prm:  Must be IGNORE, DISCARD, ABEND, EXCEPTION, TRANSABORT, TRANSDISCARD or RETRYOP.
2012-01-15 21:50:26  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repea.prm:  PROCESS ABENDING.

check triggers&foreign key
SQL> conn sap/sap
Connected.
SQL> select * from all_triggers;

no rows selected

SQL> select * from user_triggers;

no rows selected

SQL>


SQL> select a.constraint_name,a.table_name,b.constraint_name from user_constraints a,user_constraints b where a.constraint_type='R' and b.constraint_type='P' and a.r_constraint_name=b.constraint_name;

no rows selected

SQL>

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-23 19:57 , Processed in 0.049562 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569