Oracle ogg00446,OGG-00446的一次解决

--发现抽取进程莫名其妙的不好用了

GGSCI (HP-HP) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     ABENDED     EXTL        00:00:00      335:48:27

EXTRACT     ABENDED     EXTL1       00:00:00      335:48:36

--查看一下

GGSCI (HP-HP) 6> view report extl

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

Oracle GoldenGate Capture for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

Windows x64 (optimized), Oracle 11g on Apr 23 2012 06:01:56

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

Starting at 2013-04-22 21:14:19

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

Operating System Version:

Microsoft Windows 7 , on x64

Version 6.1 (Build 7601: Service Pack 1)

Process id: 1056

Description:

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

**            Running with the following parameters                  **

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

2013-04-22 21:14:19  INFO    OGG-03035  Operating system character set identifie

d as GBK. Locale: zh_Hans_CN, LC_ALL:.

extract extl

userid wzz,password ***

2013-04-22 21:14:19  INFO    OGG-03500  WARNING: NLS_LANG environment variable d

oes not match database character set, or not set. Using database character set v

alue of ZHS16GBK.

rmthost 192.168.1.104, mgrport 7801

rmttrail F:\ggs\dirdat\rl

dynamicresolution

gettruncates

table wzz.*;

2013-04-22 21:14:19  INFO    OGG-01815  Virtual Memory Facilities for: BR

anon alloc: MapViewOfFile  anon free: UnmapViewOfFile

file alloc: MapViewOfFile  file free: UnmapViewOfFile

target directories:

F:\ggs\BR\EXTL.

Bounded Recovery Parameter:

BRINTERVAL = 4HOURS

BRDIR      = F:\ggs

2013-04-22 21:14:19  INFO    OGG-01815  Virtual Memory Facilities for: COM

anon alloc: MapViewOfFile  anon free: UnmapViewOfFile

file alloc: MapViewOfFile  file free: UnmapViewOfFile

target directories:

F:\ggs\dirtmp.

CACHEMGR virtual memory values (may have been adjusted)

CACHESIZE:                                8G

CACHEPAGEOUTSIZE (normal):                8M

PROCESS VM AVAIL FROM OS (min):       13.16G

CACHESIZEMAX (strict force to disk):  11.16G

2013-04-22 21:14:21  WARNING OGG-01842  CACHESIZE PER DYNAMIC DETERMINATION (8G)

LESS THAN RECOMMENDED: 64G (64bit system)

vm found: 13.16G

Check swap space. Recommended swap/extract: 128G (64bit system).

2013-04-22 21:14:21  INFO    OGG-01639  BOUNDED RECOVERY:  ACTIVE: for object po

ol 1: p6524_extr.

2013-04-22 21:14:21  INFO    OGG-01640  BOUNDED RECOVERY: recovery start XID: 0.

0.0.

2013-04-22 21:14:21  INFO    OGG-01641  BOUNDED RECOVERY: recovery start positio

n: SeqNo: 18, RBA: 34433040, SCN: 0.347350 (347350), Timestamp: 2013-04-03 03:21

:09.000000, Thread: 1.

2013-04-22 21:14:21  INFO    OGG-01642  BOUNDED RECOVERY: recovery end position:

SeqNo: 18, RBA: 34434048, SCN: 0.347350 (347350), Timestamp: 2013-04-03 03:21:0

9.000000, Thread: 1.

2013-04-22 21:14:21  INFO    OGG-01643  BOUNDED RECOVERY: CANCELED: for object p

ool 1: p6524_extr.

2013-04-22 21:14:21  INFO    OGG-01579  BOUNDED RECOVERY: VALID BCP: CP.EXTL.000

000001.

2013-04-22 21:14:21  INFO    OGG-01629  BOUNDED RECOVERY: PERSISTED OBJECTS RECO

VERED: <>.

Database Version:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE    11.2.0.1.0      Production

TNS for 64-bit Windows: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

Database Language and Character Set:

NLS_LANG         = ".ZHS16GBK"

NLS_LANGUAGE     = "AMERICAN"

NLS_TERRITORY    = "AMERICA"

NLS_CHARACTERSET = "ZHS16GBK"

2013-04-22 21:14:22  WARNING OGG-01423  No valid default archive log destination

directory found for thread 1.

2013-04-22 21:14:22  INFO    OGG-01513  Positioning to Sequence 21, RBA 14577168

, SCN 0.407341.

Source Context :

SourceModule            : [er.common]

SourceID                : [er/common.cpp]

SourceFunction          : [extract_start_point]

SourceLine              : [2090]

ThreadBacktrace         : [7] elements

: [F:\ggs\gglog.dll(??1CContextItem@@UEAA@XZ+0x313f) [

0x00000001801075AF]]

: [F:\ggs\gglog.dll(?_MSG_ERR_CHECKPOINT_GENERIC@@YAPE

AVCMessage@@PEAVCSourceContext@@PEBDW4MessageDisposition@CMessageFactory@@@Z+0xd

3) [0x000000018004F4F3]]

: [F:\ggs\extract.exe(ERCALLBACK+0x6c52) [0x0000000140

09EE02]]

: [F:\ggs\extract.exe(shutdownMonitoring+0x1bc3c) [0x0

0000001400E563C]]

: [F:\ggs\extract.exe(CommonLexerNewSSD+0x1d730) [0x00

0000014040A120]]

: [C:\Windows\system32\kernel32.dll(BaseThreadInitThun

k+0xd) [0x0000000076ED652D]]

: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x

21) [0x000000007736C521]]

2013-04-22 21:15:44 ERROR   OGG-00446  Could not find archived log for sequence

21 thread 1 under default destinations SQL

WHERE sequence# =

ra_seq_no AND         thread# =

ra_thread AND         r

esetlogs_id =

ra_resetlog_id AND         archived = 'YES' AND         deleted

= 'NO' AND         name not like '+%'         AND standby_dest = 'NO' >, error r

etrieving redo file name for sequence 21, archived = 1, use_alternate = 0Not abl

e to establish initial position for sequence 21, rba 14577168.

2013-04-22 21:15:44  ERROR   OGG-01668  PROCESS ABENDING.

--缺少21号归档日子，我的备份也没有这个归档。

--改变抽取进程的时间，时间在归档日志SEQUENCE 21之后就可以

GGSCI (HP-HP) 8> alter extract extl,begin now

EXTRACT altered.

GGSCI (HP-HP) 9> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     STOPPED     EXTL        00:00:00      00:00:03

EXTRACT     ABENDED     EXTL1       00:00:00      336:00:31

GGSCI (HP-HP) 10> start extl

Sending START request to MANAGER ...

EXTRACT EXTL starting

--已经正常启动

GGSCI (HP-HP) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXTL        00:00:00      00:00:13

EXTRACT     ABENDED     EXTL1       00:00:00      336:00:41