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

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

0

积分

1

好友

10

主题
1#
发表于 2014-7-16 10:26:51 | 查看: 4308| 回复: 1
DB Version :10.20.0.4
OGG Version: 11.2.1.0.1

描述:同步为RAC-单机。
之前一切运行正常,在15号凌晨4点过,rep进程突然absent。源端extract,pump正常。未对链路配置做任何修改。


REPORT:

GGSCI (p770a) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    RUNNING     R_CDLD21    00:00:00      00:00:05   
REPLICAT    ABENDED     R_CDLD22    62:39:40      03:51:06   
REPLICAT    RUNNING     R_CDLD23    08:19:10      00:00:14   


GGSCI (p770a) 2> view report r_cdld22


***********************************************************************
                 Oracle GoldenGate Delivery for Oracle
      Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
  AIX 5L, ppc, 64bit (optimized), Oracle 10.2 on Apr 23 2012 08:13:30

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.


                    Starting at 2014-07-15 15:57:19
***********************************************************************

Operating System Version:
AIX
Version 6, Release 1
Node: p770a
Machine: 00F671634C00
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 9962432

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2014-07-15 15:57:19  INFO    OGG-03035  Operating system character set identified as ISO-8859-1. Locale: en_US, LC_ALL:.
REPLICAT r_cdld22
SETENV (NLS_LANG=AMERICAN_CHINA.ZHS16GBK)
Set environment variable (NLS_LANG=AMERICAN_CHINA.ZHS16GBK)
userid ggmgr, password ******
obey ./direnv/db.oby
SETENV (ORACLE_SID = "ylogg")
Set environment variable (ORACLE_SID=ylogg)
SOURCEDEFS ./dirdef/cdld2.def

2014-07-15 15:57:20  WARNING OGG-01187  Duplicate entry encountered for CDSI2.KB12K3, Reloading definition.

2014-07-15 15:57:20  WARNING OGG-01187  Duplicate entry encountered for CDSI2.KB30K3, Reloading definition.

2014-07-15 15:57:20  WARNING OGG-01187  Duplicate entry encountered for CDSI2.KB40K4, Reloading definition.
HANDLECOLLISIONS
CHECKPOINTSECS 30
GROUPTRANSOPS 20000
MAXTRANSOPS 30000
REPERROR DEFAULT, ABEND
DISCARDROLLOVER AT 05:30 ON friday
REPORTCOUNT EVERY 10000 RECORDS, RATE
WILDCARDRESOLVE DYNAMIC
ALLOWDUPTARGETMAP
ASSUMETARGETDEFS
--list the tables
MAP CDSI2.AC01, TARGET CDYLJK.AC01, COLMAP (USEDEFAULTS);
MAP CDSI2.AC01A2, TARGET CDYLJK.AC01A2;
MAP CDSI2.AC02, TARGET CDYLJK.AC02, COLMAP (USEDEFAULTS);
MAP CDSI2.AC02K2, TARGET CDYLJK.AC02K2, COLMAP (USEDEFAULTS);
MAP CDSI2.AC05, TARGET CDYLJK.AC05;
MAP CDSI2.KC03, TARGET CDYLJK.KC03;
MAP CDSI2.KC03K1, TARGET CDYLJK.KC03K1;
MAP CDSI2.KC03K3, TARGET CDYLJK.KC03K3;
MAP CDSI2.KC04, TARGET CDYLJK.KC04;
MAP CDSI2.KC05, TARGET CDYLJK.KC05;
MAP CDSI2.KC08, TARGET CDYLJK.KC08;
MAP CDSI2.KC82, TARGET CDYLJK.KC82;
MAP CDSI2.KC82K1, TARGET CDYLJK.KC82K1;
MAP CDSI2.KC82K3, TARGET CDYLJK.KC82K3;
MAP CDSI2.LC01, TARGET CDYLJK.LC01;
MAP CDSI2.LC03L1, TARGET CDYLJK.LC03L1;
MAP CDSI2.LC05, TARGET CDYLJK.LC05;
MAP CDSI2.LC07, TARGET CDYLJK.LC07;
MAP CDSI2.LC20, TARGET CDYLJK.LC20;
MAP CDSI2.LC24K1, TARGET CDYLJK.LC24K1;
MAP CDSI2.LC28, TARGET CDYLJK.LC28;
MAP CDSI2.LC32K1, TARGET CDYLJK.LC32K1;
MAP CDSI2.LC50K1, TARGET CDYLJK.LC50K1;
MAP CDSI2.MC01, TARGET CDYLJK.MC01;
MAP CDSI2.MC02, TARGET CDYLJK.MC02;
MAP CDSI2.MC05, TARGET CDYLJK.MC05;
MAP CDSI2.MC07, TARGET CDYLJK.MC07;
MAP CDSI2.MC08, TARGET CDYLJK.MC08;
MAP CDSI2.KC42, TARGET CDYLJK.KC42;
MAP CDSI2.KC43, TARGET CDYLJK.KC43;
MAP CDSI2.KC45, TARGET CDYLJK.KC45;
MAP CDSI2.KC60, TARGET CDYLJK.KC60;
MAP CDSI2.KC61, TARGET CDYLJK.KC61;
MAP CDSI2.KC62K1, TARGET CDYLJK.KC62K1;

2014-07-15 15:57:20  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 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production

Database Language and Character Set:
NLS_LANG         = "AMERICAN_CHINA.ZHS16GBK"
NLS_LANGUAGE     = "AMERICAN"
NLS_TERRITORY    = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"



GGSERR(一次start 进程时,ggserr.log里的记录)

2014-07-15 10:38:42  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start R_CDLD22.
2014-07-15 10:38:42  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host p770a (START REPLICAT R_CDLD22 ).
2014-07-15 10:38:42  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT R_CDLD22 starting.
2014-07-15 10:38:42  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, r_cdld22.prm:  REPLICAT R_CDLD22 starting.
2014-07-15 10:38:42  INFO    OGG-03035  Oracle GoldenGate Delivery for Oracle, r_cdld22.prm:  Operating system character set identified as ISO-8859-1. Locale: en_US, LC_ALL:.
2014-07-15 10:38:43  WARNING OGG-01187  Oracle GoldenGate Delivery for Oracle, r_cdld22.prm:  Duplicate entry encountered for CDSI2.KB12K3, Reloading definition.
2014-07-15 10:38:43  WARNING OGG-01187  Oracle GoldenGate Delivery for Oracle, r_cdld22.prm:  Duplicate entry encountered for CDSI2.KB30K3, Reloading definition.
2014-07-15 10:38:43  WARNING OGG-01187  Oracle GoldenGate Delivery for Oracle, r_cdld22.prm:  Duplicate entry encountered for CDSI2.KB40K4, Reloading definition.
2014-07-15 10:38:43  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, r_cdld22.prm:  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.

接着看进程r_cdld22状态,依然absent。启动过程中,ogg未记录为什从start命令后——>absent的原因。
2#
发表于 2014-7-16 10:29:20
请提供该进程所有的rpt文件,及ggserr.log文件。请上传

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-11-18 18:26 , Processed in 0.050824 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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