Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

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

5

积分

1

好友

2

主题
发表于 2013-11-5 21:39:08 | 查看: 12025| 回复: 13
环境
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













发表于 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

回复 显示全部楼层 道具 举报

发表于 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
文档我看过了,但是还是报这个问题。

回复 显示全部楼层 道具 举报

发表于 2013-11-5 21:59:17
报这个问题。

==>

1、报了之后  EXT是否abend?

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

回复 显示全部楼层 道具 举报

发表于 2013-11-5 21:59:22
报这个问题。

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

回复 显示全部楼层 道具 举报

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

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

没有 running状态

回复 显示全部楼层 道具 举报

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

回复 显示全部楼层 道具 举报

发表于 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 增加一条记录。目标端始终不变

回复 显示全部楼层 道具 举报

发表于 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.

回复 显示全部楼层 道具 举报

发表于 2013-11-5 23:11:26
TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD 111111
改为
TRANLOGOPTIONS dblogreader 试试

回复 显示全部楼层 道具 举报

发表于 2013-11-5 23:12:45
哦,我以为你抽取不出来

回复 显示全部楼层 道具 举报

发表于 2013-11-5 23:14:25
目标端没有应用,是应该你加了REPERROR (DEFAULT, DISCARD)   复制出错时,直接丢弃了,所以没有报错,没看到错误,实际上复制没有成功,改成REPERROR (DEFAULT,ABEND)  

回复 显示全部楼层 道具 举报

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

问题已经解决,由于OGG rep端,权限问题导致无法应用,且参数设置有问题,谢谢您的帮助
已有 1 人评分威望 理由
Maclean Liu(刘相兵 + 5 结贴有奖

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

回复 显示全部楼层 道具 举报

发表于 2014-11-29 12:17:47
造化弄人:
    你好,我也遇到这个问题。。。
由于OGG rep端,权限问题导致无法应用,且参数设置有问题

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


回复 显示全部楼层 道具 举报

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

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

GMT+8, 2018-12-16 01:54 , Processed in 0.074532 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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