OGG-01052 No recovery is required for target file /ogg/tail_ext/et000000, at...
环境source
oracle 11204 rac redhat linux x64
target
oracle 11204 单机 redhat linux x64
使用exp做初始化的时候
extract进程无错误，但是没有提取日志
GGSCI (rac1) 1> view param fxzext01
EXTRACT fxzext01
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0.4.0")
USERID fxz@fxzdb, PASSWORD fxz
TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD 111111
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000
EXTTRAIL /ogg/tail_ext/et
DYNAMICRESOLUTION
DDL INCLUDE ALL
table scott.*;
GGSCI (rac1) 2> view report fxzext01
***********************************************************************
Oracle GoldenGate Capture 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:42:16
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-11-05 21:11:29
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue Jan 18 20:11:49 EST 2011, Release 2.6.32-100.26.2.el5
Node: rac1
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: 5140
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2013-11-05 21:11:30 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
EXTRACT fxzext01
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0.4.0")
Set environment variable (ORACLE_HOME=/u01/app/oracle/product/11.2.0.4.0)
USERID fxz@fxzdb, PASSWORD ***
TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD ******
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000
EXTTRAIL /ogg/tail_ext/et
DYNAMICRESOLUTION
DDL INCLUDE ALL
table scott.*;
2013-11-05 21:11:32 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: 64G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
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"
2013-11-05 21:11:32 INFO OGG-01052 No recovery is required for target file /ogg/tail_ext/et000000, at RBA 0 (file not opened).
2013-11-05 21:11:32 INFO OGG-01478 Output file /ogg/tail_ext/et is using format RELEASE 11.2.
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file /ogg/tail_ext/et000000 at 2013-11-05 21:11:32
ODM FINDING:
Data pump process stops after startup. The report file contains only info messages:
2011-05-25 10:27:51 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).
2011-05-25 10:27:51 INFO OGG-01052 No recovery is required for target file /dirdat/r1000000, at RBA 0 (file not opened).
2011-05-25 10:27:51 INFO OGG-01478 Output file /dirdat/r1 is using format RELEASE 10.4/11.1.
No additional error message is reported.
Data pump and Extract are configured with THREADS parameter
CAUSE
This is a newly created data pump in a RAC environment.
When an extract is used with more than one RAC instances, the THREADS parameter must be specified.
However if the THREADS parameter is specified for the data pump extract, but extract reads only one trail source, extract abends without error and with the above info messages.
SOLUTION
The data pump has to be recreated without THREADS parameter:
delete the data pump
GGSCI> DELETE pump
edit the parameter file and remove the THREADS parameter
GGSCI> EDIT PARAMS pump
add and start the data pump
GGSCI> ADD EXTRACT pump, EXTTRAILSOURCE ./dirdat/g1
GGSCI> ADD RMTTRAIL /dirdat/r1, EXTRACT pump
GGSCI> START pump Maclean Liu(刘相兵 发表于 2013-11-5 21:41 static/image/common/back.gif
ODM FINDING:
Data pump process stops after startup. The report file contains only info messages:
201 ...
GoldenGate Pump Process Abends Without Error in RAC Environment [文章 ID 1325019.1
文档我看过了，但是还是报这个问题。 报这个问题。
==>
1、报了之后 EXT是否abend?
2、 你确定你map的表有修改了？ 报这个问题。
==> 报了之后 EXT是否abend? Maclean Liu(刘相兵 发表于 2013-11-5 21:59 static/image/common/back.gif
报这个问题。
==> 报了之后 EXT是否abend?
没有 running状态 action plan:
重配extract
参考 http://www.askmaclean.com/archives/goldengate-best-parameters-test-from-maclean.html Maclean Liu(刘相兵 发表于 2013-11-5 21:59 static/image/common/back.gif
报这个问题。
==>
map表 写的循环begin
for i in 1..100000 loop
insert into testgg values(i);
commit;
dbms_lock.sleep(10);
end loop;
end;
/
源端 10s 增加一条记录。目标端始终不变 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
$
应该是已经提取过来了，但是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. TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD 111111
改为
TRANLOGOPTIONS dblogreader 试试 哦，我以为你抽取不出来 目标端没有应用，是应该你加了REPERROR (DEFAULT, DISCARD) 复制出错时，直接丢弃了，所以没有报错，没看到错误，实际上复制没有成功，改成REPERROR (DEFAULT,ABEND) newway 发表于 2013-11-5 23:14 static/image/common/back.gif
目标端没有应用，是应该你加了REPERROR (DEFAULT, DISCARD) 复制出错时，直接丢弃了，所以没有报错，没看 ...
问题已经解决，由于OGG rep端，权限问题导致无法应用，且参数设置有问题，谢谢您的帮助 造化弄人：
你好，我也遇到这个问题。。。
由于OGG rep端，权限问题导致无法应用，且参数设置有问题
请问如何解决的？ 我的rep端是windows，应该说没有权限问题吧，是不是参数设置有问题？？
页:
[1]