关于#oracle#OGG的问题：ggserr.log报错信息OGG-00446
关于#oracle#OGG的问题：ggserr.log报错信息OGG-00446 CSN not found in supplemental file
源端和目标端均为11.2.1版本
OGG复制进程报错出OGG-00446错误后，无法启动
复制进程report报告
***********************************************************************
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 2021-07-12 16:27:45
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Wed Apr 13 00:51:26 EDT 2016, Release 2.6.32-642.el6.x86_64
Node: jbbf01
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: 127380
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2021-07-12 16:27:45 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
replicat REPBF93
SETENV (NLS_LANG="AMERICAN_AMERICA.UTF8")
Set environment variable (NLS_LANG=AMERICAN_AMERICA.UTF8)
USERID ogg, PASSWORD ***********
DISCARDFILE ./dirrpt/REPBF93.dsc, APPEND, MEGABYTES 1024
reperror default,abend
assumetargetdefs
numfiles 3000
APPLYNOOPUPDATES
MAP SEA.A_I , target SEA.A_I ;
MAP SEA.E_M , target SEA.E_M ;
MAP SEA.A_S , target SEA.A_S ;
MAP SEA.A_R , target SEA.A_R ;
MAP SEA.A_S , target SEA.A_S ;
MAP SEA.E_M , target SEA.E_M ;
MAP SEA.A_G , target SEA.A_G ;
2021-07-12 16:27:46 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.UTF8"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file ./dirdat/bf601982 at 2021-07-12 16:27:46
MAP resolved (entry SEA.E_METER_EVENT):
MAP "SEA"."E_METER_EVENT" , target SEA.E_METER_EVENT;
Using following columns in default map by name:
ID, AREA_CODE, EVENT_NO, REC_TIME, TMNL_ASSET_NO, DATA_ITEM
Using the following key columns for target table SEA.E_METER_EVENT: ID, AREA_CODE, EVENT_NO, REC_TIME.
Switching to next trail file ./dirdat/bf601983 at 2021-07-12 16:27:47 due to EOF, with current RBA 499999314
Opened trail file ./dirdat/bf601983 at 2021-07-12 16:27:47
Switching to next trail file ./dirdat/bf601984 at 2021-07-12 16:27:47 due to EOF, with current RBA 499999265
Opened trail file ./dirdat/bf601984 at 2021-07-12 16:27:47
Switching to next trail file ./dirdat/bf601985 at 2021-07-12 16:27:48 due to EOF, with current RBA 499998735
Opened trail file ./dirdat/bf601985 at 2021-07-12 16:27:48
2021-07-12 16:27:48 WARNING OGG-01003 Repositioning to rba 378911947 in seqno 601982.
Opened trail file ./dirdat/bf601982 at 2021-07-12 16:27:48
Switching to next trail file ./dirdat/bf601983 at 2021-07-12 16:27:53 due to EOF, with current RBA 499999314
Opened trail file ./dirdat/bf601983 at 2021-07-12 16:27:53
Source Context :
SourceModule : [er.utiity]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/utility.cpp]
SourceFunction : [checkpoint_status]
SourceLine : [1435]
ThreadBacktrace : [9] elements
: [/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7ffff7e7a06e]]
: [/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7ffff7e7644c]]
: [/ogg/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x7ffff7e64869]]
: [/ogg/replicat(checkpoint_status(short, short)+0x1d9) [0x53def9]]
: [/ogg/replicat(REP_end_transaction(short)+0x256) [0x547bc6]]
: [/ogg/replicat(process_extract_loop()+0x1a0c) [0x53627c]]
: [/ogg/replicat(main+0x732) [0x548752]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3d22e1ed1d]]
: [/ogg/replicat(__gxx_personality_v0+0x322) [0x4be48a]]
2021-07-12 16:27:54 ERROR OGG-00446 .
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Last record for the last committed transaction is the following:
___________________________________________________________________
Trail name : ./dirdat/bf601983
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 486 (x01e6) IO Time : 2021-07-12 14:17:30.065570
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 837003 AuditPos : 4020924996
Continued : N (x00) RecCount : 1 (x01)
2021-07-12 14:17:30.065570 FieldComp Len 486 RBA 67141468
Name: SEA.C_MP
___________________________________________________________________
Reading ./dirdat/bf601983, current RBA 67141468, 78 records
Report at 2021-07-12 16:27:54 (activity since 2021-07-12 16:27:46)
From Table SEA.E_M to SEA.E_M:
# inserts: 78
# updates: 0
# deletes: 0
# discards: 0
Last log location read:
FILE: ./dirdat/bf601983
SEQNO: 601983
RBA: 67141468
TIMESTAMP: 2021-07-12 14:17:30.065570
EOF: NO
READERR: 0
2021-07-12 16:27:54 ERROR OGG-01668 PROCESS ABENDING.
CACHE OBJECT MANAGER statistics
CACHE MANAGER VM USAGE
vm current = 0 vm anon queues = 0
vm anon in use = 0 vm file = 0
vm used max = 0 ==> CACHE BALANCED
CACHE CONFIGURATION
cache size = 2G cache force paging = 3.41G
buffer min = 64K buffer highwater = 8M
pageout eligible size = 8M
================================================================================
RUNTIME STATS FOR SUPERPOOL
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
disk current = 0 disk total = 0
disk caching = 0 file cached = 0
file retrieves = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0 force out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
================================================================================
CUMULATIVE STATS FOR SUPERPOOL
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
disk current = 0 disk total = 0
disk caching = 0 file cached = 0
file retrieves = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0 force out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
QUEUE Statistics:
num queues = 15 default index = 0
cur len = 0 max len = 0
q vm current = 0 vm max = 0
q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
3 512K 0 0 0 0
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
11 128M 0 0 0 0
12 256M 0 0 0 0
13 512M 0 0 0 0
14 1G 0 0 0 0
================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: repbf93 id: p127380_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
================================================================================
CUMULATIVE STATS FOR CACHE POOL #0
POOL INFO group: repbf93 id: p127380_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
QUEUE Statistics:
num queues = 15 default index = 0
cur len = 0 max len = 0
q vm current = 0 vm max = 0
q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
3 512K 0 0 0 0
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
11 128M 0 0 0 0
12 256M 0 0 0 0
13 512M 0 0 0 0
14 1G 0 0 0 0
================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: repbf93 id: p127380_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
================================================================================
CUMULATIVE STATS FOR CACHE POOL #0
POOL INFO group: repbf93 id: p127380_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
ggserr.log报错信息
求指导
你好，我是有问必答小助手，非常抱歉，本次您提出的有问必答问题，技术专家团超时未为您做出解答
本次提问扣除的有问必答次数，将会以问答VIP体验卡（1次有问必答机会、商城购买实体图书享受95折优惠）的形式为您补发到账户。
因为有问必答VIP体验卡有效期仅有1天，您在需要使用的时候【私信】联系我，我会为您补发。