oracle11g ora-00001 violated,OGG-00869 OCI Error ORA-00001: unique constraint violated (status = 1)

GGSCI (yzgjjhp2) 1> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING

EXTRACT     ABENDED     EORA_001    51:12:27      262:44:55

EXTRACT     RUNNING     PORA_001    00:00:00      00:00:09

GGSCI (yzgjjhp2) 2> view report eora_001

***********************************************************************

Oracle GoldenGate Capture for Oracle

Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040

HP/UX, IA64, 64bit (optimized), Oracle 10g on Apr 22 2011 01:27:04

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

Starting at 2012-05-08 09:37:24

***********************************************************************

Operating System Version:

HP-UX

Version U, Release B.11.31

Node: yzgjjhp2

Machine: ia64

soft limit   hard limit

Address Space Size   :    unlimited    unlimited

Heap Size            :   4294967296   4294967296

File Size            :    unlimited    unlimited

CPU Time             :    unlimited    unlimited

Process id: 13417

Description:

***********************************************************************

**            Running with the following parameters                  **

***********************************************************************

extract eora_001

setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

userid ggs,password ******************************************* DEFAULT

--TRANLOGOPTIONS ARCHIVEDLOGONLY

--TRANLOGOPTIONS ALTARCHIVELOGDEST /oradata03/archive

TRANLOGOPTIONS ARCHIVEDLOGONLY

TRANLOGOPTIONS altarchivelogdest primary instance hfmis1 /home/ogg/archlog1, altarchivelogdest instance hfmis2 /ogg/archlog2

WARNLONGTRANS 2h,CHECKINTERVAL 3m

DYNAMICRESOLUTION

GETTRUNCATES

REPORTCOUNT EVERY 1 MINUTES, RATE

DISCARDFILE ./dirrpt/extya.dsc,APPEND,MEGABYTES 1024

exttrail ./dirdat/t1

table HFMIS.CHKERROR;

..............................................

Bounded Recovery Parameter:

BRINTERVAL = 4HOURS

BRDIR      = /ogg

CACHEMGR virtual memory values (may have been adjusted)

CACHEBUFFERSIZE:                         64K

CACHESIZE:                                8G

CACHEBUFFERSIZE (soft max):               4M

CACHEPAGEOUTSIZE (normal):                4M

PROCESS VM AVAIL FROM OS (min):          16G

CACHESIZEMAX (strict force to disk):  13.99G

2012-05-08 09:37:24  INFO    OGG-01639  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p20903_Redo Thread 1.

2012-05-08 09:37:24  INFO    OGG-01640  BOUNDED RECOVERY: recovery start XID: 7.28.24351.

2012-05-08 09:37:24  INFO    OGG-01641  BOUNDED RECOVERY: recovery start position: SeqNo: 3966, RBA: 54761488, SCN: 0.1379135368 (1379135368), Timestamp: 2012-04-24 18:01:20.000000.

2012-05-08 09:37:24  INFO    OGG-01642  BOUNDED RECOVERY: recovery end position: SeqNo: 3966, RBA: 123728896, SCN: 0.1379331976 (1379331976), Timestamp: 2012-04-25 09:58:25.000000.

2012-05-08 09:37:24  INFO    OGG-01639  BOUNDED RECOVERY:  ACTIVE: for object pool 2: p20903_Redo Thread 2.

2012-05-08 09:37:24  INFO    OGG-01640  BOUNDED RECOVERY: recovery start XID: 0.0.0.

2012-05-08 09:37:24  INFO    OGG-01641  BOUNDED RECOVERY: recovery start position: SeqNo: 5517, RBA: 123323408, SCN: 0.1379131645 (1379131645), Timestamp: 2012-04-24 17:56:08.000000.

2012-05-08 09:37:24  INFO    OGG-01642  BOUNDED RECOVERY: recovery end position: SeqNo: 5517, RBA: 123728896, SCN: 0.1379131645 (1379131645), Timestamp: 2012-04-24 17:56:08.000000.

2012-05-08 09:37:24  INFO    OGG-01579  BOUNDED RECOVERY: VALID BCP: CP.EORA_001.000000066.

2012-05-08 09:37:24  INFO    OGG-01629  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: 18.

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 HPUX: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

Database Language and Character Set:

NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"

NLS_LANGUAGE     = "AMERICAN"

NLS_TERRITORY    = "AMERICA"

NLS_CHARACTERSET = "ZHS16GBK"

2012-05-08 09:37:24  INFO    OGG-00546  Default thread stack size: 262144.

2012-05-08 09:37:24  INFO    OGG-00547  Increasing thread stack size from 262144 to 1048576.

2012-05-08 09:37:24  INFO    OGG-01513  Positioning to (Thread 1) Sequence 3966, RBA 54761488, SCN 0.1379135368.

2012-05-08 09:37:24  INFO    OGG-01516  Positioned to (Thread 1) Sequence 3966, RBA 54761488, SCN 0.1379135368, Apr 24, 2012 6:01:20 PM.

2012-05-08 09:37:24  INFO    OGG-01513  Positioning to (Thread 2) Sequence 5517, RBA 123323408, SCN 0.1379131645.

2012-05-08 09:37:24  INFO    OGG-01516  Positioned to (Thread 2) Sequence 5517, RBA 123323408, SCN 0.1379131645, Apr 24, 2012 5:56:08 PM.

2012-05-08 09:37:24  INFO    OGG-01517  Position of first record processed for Thread 1, Sequence 3966, RBA 54761488, SCN 0.1379135368, Apr 24, 2012 6:01:20 PM.

2012-05-08 09:37:24  INFO    OGG-01517  Position of first record processed for Thread 2, Sequence 5517, RBA 123323408, SCN 0.1379131611, Apr 24, 2012 5:56:08 PM.

2012-05-08 09:37:24  INFO    OGG-01644  BOUNDED RECOVERY: COMPLETE: for object pool 2: p20903_Redo Thread 2 at SeqNo: 5518, RBA: 2064, SCN: 0.1379131647 (1379131647).

2012-05-08 09:37:24  INFO    OGG-01056  Recovery initialization completed for target file ./dirdat/t1000003, at RBA 4965566, CSN 1379246523.

Source Context :

SourceModule            : [er.main]

SourceID                : [/scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/app/er/rep.c]

SourceFunction          : [main]

SourceLine              : [26195]

2012-05-08 09:37:24  ERROR   OGG-01476  The previous run abended due to an out of order transaction. Issue ALTER ETROLLOVER to advance the output trail sequence past the current trail sequence number, then re

start. Then, use ALTER EXTSEQNO on the subsequent pump EXTRACT, or REPLICAT, process group to start reading from the new trail file created by ALTER ETROLLOVER; the downstream process will not automatically s

witch to the new trail file.

2012-05-08 09:37:25  ERROR   OGG-01668  PROCESS ABENDING.

发现生产端这个故障时做了如下外理：

1、alter extract EORA_001, etrollover

2、start eora_001

3、info all

当时看到抓取进程正常启动了，而且抓到了数据，但是发现pump PORA_001，没有active map,于是

5、stop PORA_001

6、start PORA_001

但还是没有数据变化，于是

7、view report pora_001

以下是输出：

2012-05-09 10:13:54  INFO    OGG-01226  Socket buffer size set to 27985 (flush size 27985).

2012-05-09 10:13:54  INFO    OGG-01055  Recovery initialization completed for target file ./dirdat/t1000038, at RBA 1044.

2012-05-09 10:13:54  INFO    OGG-01478  Output file ./dirdat/t1 is using format RELEASE 10.4/11.1.

2012-05-09 10:13:54  INFO    OGG-01026  Rolling over remote file ./dirdat/t1000039.

2012-05-09 10:13:54  INFO    OGG-01053  Recovery completed for target file ./dirdat/t1000039, at RBA 1004.

2012-05-09 10:13:54  INFO    OGG-01057  Recovery completed for all targets.

***********************************************************************

**                     Run Time Messages                             **

***********************************************************************

Opened trail file ./dirdat/t1000003 at 2012-05-09 10:13:54

2012-05-09 10:13:58  WARNING OGG-01519  Waiting at EOF on input trail file ./dirdat/t1000003, which is not marked as complete; but succeeding trail file ./dirdat/t1000004 exists. If ALTER ETROLLOVER has been

performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downstream reader.

2012-05-09 10:14:04  INFO    OGG-01021  Command received from GGSCI: STATS.

2012-05-09 10:14:08  WARNING OGG-01519  Waiting at EOF on input trail file ./dirdat/t1000003, which is not marked as complete; but succeeding trail file ./dirdat/t1000004 exists. If ALTER ETROLLOVER has been

performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downstream reader.

2012-05-09 10:14:29  WARNING OGG-01519  Waiting at EOF on input trail file ./dirdat/t1000003, which is not marked as complete; but succeeding trail file ./dirdat/t1000004 exists. If ALTER ETROLLOVER has been

performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downstream reader.

2012-05-09 10:15:09  WARNING OGG-01519  Waiting at EOF on input trail file ./dirdat/t1000003, which is not marked as complete; but succeeding trail file ./dirdat/t1000004 exists. If ALTER ETROLLOVER has been

performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downstream reader.

看到 OGG-01519执行了如下操作：

8.1 stop PORA_001

8.2 alter PORA_001, etrollover

8.3 start PORA_001

之后stats pora_001还是没有active map

9、view report  pora_001

还是发现报：WARNING OGG-01519  Waiting at EOF on input trail file ./dirdat/t1000003

10.1  stop pora_001

10.2  alter extract pora_001， extseqno 3,extrba 0

10.3 start pora_001

再stats pora_001发现有数据更新