- 最后登录
- 2013-11-8
- 在线时间
- 3 小时
- 威望
- 5
- 金钱
- 28
- 注册时间
- 2012-12-27
- 阅读权限
- 10
- 帖子
- 11
- 精华
- 0
- 积分
- 5
- UID
- 841
|
9#
发表于 2013-11-5 23:10:37
Maclean Liu(刘相兵 发表于 2013-11-5 21:59 ![](static/image/common/back.gif)
报这个问题。
==> 报了之后 EXT是否abend?
我strings 一下
9.21.1153Z
SCOTT.TESTGG
3164T
AAAVsrAAEAAAAIeAEU
16119836
2.30.1140Z
SCOTT.TESTGG
3165T
AAAVsrAAEAAAAIeAEV
16119936
10.3.930Z
SCOTT.TESTGG
3166T
AAAVsrAAEAAAAIeAEW
16120026
6.18.1322Z
SCOTT.TESTGG
3167T
AAAVsrAAEAAAAIeAEX
16120126
4.12.952Z
SCOTT.TESTGG
3168T
AAAVsrAAEAAAAIeAEY
16120216
5.3.1141Z
SCOTT.TESTGG
3169T
AAAVsrAAEAAAAIeAEZ
16120306
3.3.1139Z
[oracle@em-ogg-standby tail_ext]$
应该是已经提取过来了,但是pump没有正确的应用
GGSCI (em-ogg-standby) 46> view param fxzrpt1
REPLICAT fxzrpt1
SETENV (ORACLE_SID = testdb)
USERID fxz@testdb,PASSWORD fxz
ASSUMETARGETDEFS
HANDLECOLLISIONS
REPERROR (DEFAULT, DISCARD)
DDLERROR DEFAULT DISCARD
DDLOPTIONS REPORT
DISCARDFILE /ogg/repsz.dsc,append,megabytes 100
MAP scott.*, TARGET scott.*;
GGSCI (em-ogg-standby) 47> view report fxzrept1
ERROR: REPORT file FXZREPT1 does not exist.
GGSCI (em-ogg-standby) 48> view report fxzrpt1
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:48:07
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-11-05 23:06:40
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue Aug 18 15:51:48 EDT 2009, Release 2.6.18-164.el5
Node: em-ogg-standby
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 14595
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2013-11-05 23:06:40 INFO OGG-03035 Operating system character set identified as gb18030. Locale: zh_CN, LC_ALL:.
REPLICAT fxzrpt1
SETENV (ORACLE_SID = testdb)
Set environment variable (ORACLE_SID=testdb)
USERID fxz@testdb,PASSWORD ***
ASSUMETARGETDEFS
HANDLECOLLISIONS
REPERROR (DEFAULT, DISCARD)
DDLERROR DEFAULT DISCARD
DDLOPTIONS REPORT
DISCARDFILE /ogg/repsz.dsc,append,megabytes 100
MAP scott.*, TARGET scott.*;
2013-11-05 23:06:41 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 2G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 4G
CACHESIZEMAX (strict force to disk): 3.41G
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file /ogg/tail_ext/rt000000 at 2013-11-05 23:06:43
2013-11-05 23:06:43 INFO OGG-01373 User requested start after CSN 1609179.
2013-11-05 23:06:43 INFO OGG-01374 Transaction delivery commencing at position Seqno 0, RBA 32741, Transaction ID 7.31.938, CSN 1609184, 251 transaction(s) skipped.
Wildcard MAP resolved (entry scott.*):
MAP "SCOTT"."TESTGG", TARGET scott."TESTGG";
2013-11-05 23:07:01 WARNING OGG-00869 No unique key is defined for table 'TESTGG'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be us
ed to define the key.
Using following columns in default map by name:
ID
Using the following key columns for target table SCOTT.TESTGG: ID. |
|