OGG-01052 No recovery is required for target file /ogg/tail_ext/et000000, at...

2^#

发表于 2013-11-5 21:41:50

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

3^#

发表于 2013-11-5 21:47:19

Maclean Liu(刘相兵发表于 2013-11-5 21:41
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
文档我看过了，但是还是报这个问题。

4^#

发表于 2013-11-5 21:59:17

报这个问题。

==>

1、报了之后 EXT是否abend?

2、你确定你map的表有修改了？

5^#

发表于 2013-11-5 21:59:22

报这个问题。

==> 报了之后 EXT是否abend?

6^#

发表于 2013-11-5 21:59:39

Maclean Liu(刘相兵发表于 2013-11-5 21:59
报这个问题。

==> 报了之后 EXT是否abend?

没有 running状态

7^#

发表于 2013-11-5 23:03:29

action plan:

重配extract

参考 http://www.askmaclean.com/archiv ... t-from-maclean.html

8^#

发表于 2013-11-5 23:05:14

Maclean Liu(刘相兵发表于 2013-11-5 21:59
报这个问题。

==>

map表写的循环begin
   for i in 1..100000 loop
      insert into testgg values(i);
      commit;
      dbms_lock.sleep(10);
   end loop;
end;
/
源端 10s 增加一条记录。目标端始终不变

9^#

发表于 2013-11-5 23:10:37

Maclean Liu(刘相兵发表于 2013-11-5 21:59
报这个问题。

==> 报了之后 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.

newway

10^#

发表于 2013-11-5 23:11:26

TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD 111111
改为
TRANLOGOPTIONS dblogreader 试试

newway

11^#

发表于 2013-11-5 23:12:45

哦，我以为你抽取不出来

newway

12^#

发表于 2013-11-5 23:14:25

目标端没有应用，是应该你加了REPERROR (DEFAULT, DISCARD) 复制出错时，直接丢弃了，所以没有报错，没看到错误，实际上复制没有成功，改成REPERROR (DEFAULT,ABEND)

13^#

发表于 2013-11-6 14:34:23

newway 发表于 2013-11-5 23:14
目标端没有应用，是应该你加了REPERROR (DEFAULT, DISCARD) 复制出错时，直接丢弃了，所以没有报错，没看 ...

问题已经解决，由于OGG rep端，权限问题导致无法应用，且参数设置有问题，谢谢您的帮助

已有 1 人评分	威望	理由
Maclean Liu(刘相兵	+ 5	结贴有奖

总评分: 威望 + 5 查看全部评分

80856159

14^#

发表于 2014-11-29 12:17:47

造化弄人：
你好，我也遇到这个问题。。。
由于OGG rep端，权限问题导致无法应用，且参数设置有问题

请问如何解决的？我的rep端是windows，应该说没有权限问题吧，是不是参数设置有问题？？