godengate 同步错误
两面都是solaris平台SunOS 5.10源端：
GGSCI (jildmcedm02) 7> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING JLEXT02 00:00:00 00:00:07
EXTRACT RUNNING JLPUMP02 00:00:00 00:00:00
目标端：
GSCI (JLA2V245) 20> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING JLREP01 00:00:00 00:00:00
REPLICAT ABENDED JLREP02 338:28:27 00:19:56
REPLICAT RUNNING JLREP03 00:00:00 00:00:00
REPLICAT ABENDED JLREP04 00:00:04 128:15:32
REPLICAT RUNNING JLREP05 00:00:00 00:00:00
REPLICAT RUNNING JLREP06 00:00:00 00:00:06
问题进程
GGSCI (JLA2V245) 25> info REPLICAT JLREP02,showch
REPLICAT JLREP02 Last Started 2014-07-23 16:29 Status ABENDED
Checkpoint Lag 338:28:27 (updated 00:37:04 ago)
Log Read Checkpoint File ./dirdat/jl000342
2014-07-09 14:01:03.268320 RBA 86710539
Current Checkpoint Detail:
Read Checkpoint #1
GGS Log Trail
Startup Checkpoint (starting position in the data source):
Sequence #: 342
RBA: 86710539
Timestamp: 2014-07-09 14:01:03.268320
Extract Trail: ./dirdat/jl
Current Checkpoint (position of last record read in the data source):
Sequence #: 342
RBA: 86710539
Timestamp: 2014-07-09 14:01:03.268320
Extract Trail: ./dirdat/jl
CSN state information:
CRC: DA-46-E4-11
Latest CSN: 13164786317351
Latest TXN: 97.5.27069
Latest CSN of finished TXNs: 13164786317351
Completed TXNs: 97.5.27069 152.30.23125 233.4.22722... (1187 in total)
Header:
Version = 2
Record Source = A
Type = 1
# Input Checkpoints = 1
# Output Checkpoints = 0
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 0
Transaction Integrity = -1
Task Type = 0
Status:
Start Time = 2014-07-23 16:29:30
Last Update Time = 2014-07-23 16:29:30
Stop Status = A
Last Result = 0
GGSCI (JLA2V245) 26>
正常进程
GGSCI (JLA2V245) 26> info REPLICAT JLREP01,showch
REPLICAT JLREP01 Last Started 2014-07-09 14:02 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint File ./dirdat/jl000375
2014-07-23 15:25:49.500449 RBA 56086904
Current Checkpoint Detail:
Read Checkpoint #1
GGS Log Trail
Startup Checkpoint (starting position in the data source):
Sequence #: 342
RBA: 86459236
Timestamp: 2014-07-09 13:59:02.186831
Extract Trail: ./dirdat/jl
Current Checkpoint (position of last record read in the data source):
Sequence #: 375
RBA: 56086904
Timestamp: 2014-07-23 15:25:49.500449
Extract Trail: ./dirdat/jl
CSN state information:
CRC: 61-1-8C-7B
Latest CSN: 13169484560212
Latest TXN: 167.21.24378
Latest CSN of finished TXNs: 13169484560212
Completed TXNs: 167.21.24378
Header:
Version = 2
Record Source = A
Type = 1
# Input Checkpoints = 1
# Output Checkpoints = 0
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 0
Transaction Integrity = -1
Task Type = 0
Status:
Start Time = 2014-07-09 14:02:04
Last Update Time = 2014-07-23 17:07:32
Stop Status = A
Last Result = 400
GGSCI (JLA2V245) 28> view report JLREP02
2014-07-23 16:29:28 WARNING OGG-01834 Failed setting IPv6 socket to dual stack mode (error: 99, Option not supported by protocol).
2014-07-23 16:29:28 WARNING OGG-01834 Failed setting IPv6 socket to dual stack mode (error: 99, Option not supported by protocol).
2014-07-23 16:29:28 WARNING OGG-01834 Failed setting IPv6 socket to dual stack mode (error: 99, Option not supported by protocol).
2014-07-23 16:29:28 WARNING OGG-01834 Failed setting IPv6 socket to dual stack mode (error: 99, Option not supported by protocol).
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Solaris, sparc, 64bit (optimized), Oracle 11g on Apr 24 2012 09:42:58
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2014-07-23 16:29:28
***********************************************************************
Operating System Version:
SunOS
Version Generic_148888-05, Release 5.10
Node: JLA2V245
Machine: sun4v
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 22699
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2014-07-23 16:29:28 INFO OGG-03035 Operating system character set identified as US-ASCII. Locale: en_US_POSIX, LC_ALL:.
REPLICAT jlrep02
SETENV (ORACLE_HOME="/apps/oracle/product/11.2.0/db_1")
Set environment variable (ORACLE_HOME=/apps/oracle/product/11.2.0/db_1)
SETENV (ORACLE_SID="JLEDM01")
Set environment variable (ORACLE_SID=JLEDM01)
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
Set environment variable (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID GOLDENGATE, PASSWORD *********
SOURCEDEFS ./dirdef/edmadmin.def
2014-07-23 16:29:29 WARNING OGG-01187 Duplicate entry encountered for EDMADMIN.PC_DATA_AUDIT_LOG, Reloading definition.
--ASSUMETARGETDEFS
GETTRUNCATES
--DBOPTIONS DEFERREFCONST
--HANDLECOLLISIONS
report at 1:59
reportrollover at 2:00
reperror default,abend
ALLOWNOOPUPDATES
DISCARDFILE ./dirrpt/discard_jl02.dsc, PURGE
map edmadmin.PC_PRO_WELL_METER_DAILY , target edmadmin.PC_PRO_WELL_METER_DAILY ;
map edmadmin.PC_PRO_WELL_METER_META , target edmadmin.PC_PRO_WELL_METER_META ;
map edmadmin.PC_INJ_WELL_ALLOC_ZONE_PLAN , target edmadmin.PC_INJ_WELL_ALLOC_ZONE_PLAN ;
map edmadmin.PC_INJ_WELL_CHEM_ZONE_PLAN , target edmadmin.PC_INJ_WELL_CHEM_ZONE_PLAN ;
map edmadmin.PC_WELL_DOWNTIME , target edmadmin.PC_WELL_DOWNTIME ;
map edmadmin.TEMP_WELL_MECH_ALL , target edmadmin.TEMP_WELL_MECH_ALL ;
map edmadmin.PC_WELL_DATA_AUDIT , target edmadmin.PC_WELL_DATA_AUDIT ;
map edmadmin.PC_OIL_PROD_DAILY , target edmadmin.PC_OIL_PROD_DAILY ;
map edmadmin.PC_INJ_PRO_DAILY , target edmadmin.PC_INJ_PRO_DAILY ;
map edmadmin.PC_PRO_WELL_VOL_DAILY , target edmadmin.PC_PRO_WELL_VOL_DAILY ;
map edmadmin.PC_PRO_WELL_STATUS_DAILY , target edmadmin.PC_PRO_WELL_STATUS_DAILY ;
map edmadmin.PC_PRO_WELL_VOLFACTOR_DAILY , target edmadmin.PC_PRO_WELL_VOLFACTOR_DAILY ;
map edmadmin.PC_INJ_WELL_VOL_DAILY , target edmadmin.PC_INJ_WELL_VOL_DAILY ;
map edmadmin.PC_INJ_WELL_STATUS_DAILY , target edmadmin.PC_INJ_WELL_STATUS_DAILY ;
map edmadmin.PC_INJ_WELL_VOLFACTOR_DAILY , target edmadmin.PC_INJ_WELL_VOLFACTOR_DAILY ;
map edmadmin.PC_INJ_COMPLETION_DAILY , target edmadmin.PC_INJ_COMPLETION_DAILY ;
map edmadmin.PC_INJ_COMP_STATUS_DAILY , target edmadmin.PC_INJ_COMP_STATUS_DAILY ;
map edmadmin.PC_INJ_VOL_CHAN_FACTOR_DAILY , target edmadmin.PC_INJ_VOL_CHAN_FACTOR_DAILY ;
map edmadmin.PC_INJ_WELL_DOWN_CLASS_DAILY , target edmadmin.PC_INJ_WELL_DOWN_CLASS_DAILY ;
map edmadmin.PC_COMPLETION_INJ_DAILY , target edmadmin.PC_COMPLETION_INJ_DAILY ;
map edmadmin.PC_PROD_CHANGE_FACTOR_DAILY , target edmadmin.PC_PROD_CHANGE_FACTOR_DAILY ;
map edmadmin.PC_PRO_WELL_ALLOC_DAILY , target edmadmin.PC_PRO_WELL_ALLOC_DAILY ;
map edmadmin.PC_PRO_WELL_ASSAY_DAILY , target edmadmin.PC_PRO_WELL_ASSAY_DAILY ;
map edmadmin.PC_TRAN_PRO_DAILY , target edmadmin.PC_TRAN_PRO_DAILY ;
map edmadmin.PC_SEPA_INJ_WELL_DAILY , target edmadmin.PC_SEPA_INJ_WELL_DAILY ;
map edmadmin.PC_PRO_WELL_SHUT_CLASS_DAILY , target edmadmin.PC_PRO_WELL_SHUT_CLASS_DAILY ;
map edmadmin.PC_PRO_LAB_SAMPLE , target edmadmin.PC_PRO_LAB_SAMPLE ;
map edmadmin.PC_PRO_LAB_ANALYSIS , target edmadmin.PC_PRO_LAB_ANALYSIS ;
map edmadmin.PC_PRO_LAB_ITEM , target edmadmin.PC_PRO_LAB_ITEM ;
map edmadmin.CD_PRESSURE_SURVEY , target edmadmin.CD_PRESSURE_SURVEY ;
map edmadmin.PC_PRESSURE_INJ_WATER , target edmadmin.PC_PRESSURE_INJ_WATER ;
map edmadmin.PC_PRESSURE_INJ_FLOW_WATER , target edmadmin.PC_PRESSURE_INJ_FLOW_WATER ;
map edmadmin.PC_UPLOADING_DATA_LOGGING , target edmadmin.PC_UPLOADING_DATA_LOGGING ;
map edmadmin.PC_VERIFY_PROD_TEN_DAYS , target edmadmin.PC_VERIFY_PROD_TEN_DAYS ;
map edmadmin.PC_WELL_ASSIGNATION_EXT , target edmadmin.PC_WELL_ASSIGNATION_EXT ;
map edmadmin.PC_PRO_WELL_STIM_MON , target edmadmin.PC_PRO_WELL_STIM_MON ;
map edmadmin.PC_INJ_WELL_STIM_MON , target edmadmin.PC_INJ_WELL_STIM_MON ;
map edmadmin.PC_HORI_WELL_OIL_PROD_DAILY , target edmadmin.PC_HORI_WELL_OIL_PROD_DAILY ;
map edmadmin.PC_H_WELL_PRO_SHUT_CLASS_DAILY , target edmadmin.PC_H_WELL_PRO_SHUT_CLASS_DAILY ;
map edmadmin.pc_data_monitor_log , target edmadmin.pc_data_monitor_log ;
map edmadmin.pc_data_audit_log , target edmadmin.pc_data_audit_log;
2014-07-23 16:29:30 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:
/apps/oracle/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.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Solaris: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.AL32UTF8"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file ./dirdat/jl000342 at 2014-07-23 16:29:30
MAP resolved (entry edmadmin.pc_data_audit_log):
map "EDMADMIN"."PC_DATA_AUDIT_LOG" , target edmadmin.pc_data_audit_log;
Using following columns in default map by name:
LOG_DATE, USERNAME, MODULE_NAME, MESSAGE, EXCEPTION, LOCATION,
USERNAME_CN
Using the following key columns for target table EDMADMIN.PC_DATA_AUDIT_LOG: LOG_DATE, USERNAME, MESSAGE.
2014-07-23 16:29:30 WARNING OGG-00869 OCI Error ORA-00001: unique constraint (EDMADMIN.PK_DATA_AUDIT_LOG) violated (status = 1). I
NSERT INTO "EDMADMIN"."PC_DATA_AUDIT_LOG" ("LOG_DATE","USERNAME","MODULE_NAME","MESSAGE","EXCEPTION","LOCATION","USERNAME_CN") VALUE
S (:a0,:a1,:a2,:a3,:a4,:a5,:a6).
2014-07-23 16:29:30 WARNING OGG-01004 Aborted grouped transaction on 'EDMADMIN.PC_DATA_AUDIT_LOG', Database error 1 (OCI Error ORA
-00001: unique constraint (EDMADMIN.PK_DATA_AUDIT_LOG) violated (status = 1). INSERT INTO "EDMADMIN"."PC_DATA_AUDIT_LOG" ("LOG_DATE"
,"USERNAME","MODULE_NAME","MESSAGE","EXCEPTION","LOCATION","USERNAME_CN") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6)).
2014-07-23 16:29:30 WARNING OGG-01003 Repositioning to rba 86710539 in seqno 342.
2014-07-23 16:29:30 WARNING OGG-01154 SQL error 1 mapping EDMADMIN.PC_DATA_AUDIT_LOG to EDMADMIN.PC_DATA_AUDIT_LOG OCI Error ORA-0
0001: unique constraint (EDMADMIN.PK_DATA_AUDIT_LOG) violated (status = 1). INSERT INTO "EDMADMIN"."PC_DATA_AUDIT_LOG" ("LOG_DATE","
USERNAME","MODULE_NAME","MESSAGE","EXCEPTION","LOCATION","USERNAME_CN") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6).
2014-07-23 16:29:30 WARNING OGG-01003 Repositioning to rba 86710539 in seqno 342.
Source Context :
SourceModule :
SourceID :
SourceFunction :
SourceLine :
2014-07-23 16:29:30 ERROR OGG-01296 Error mapping from EDMADMIN.PC_DATA_AUDIT_LOG to EDMADMIN.PC_DATA_AUDIT_LOG.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Last record for the last committed transaction is the following:
___________________________________________________________________
Trail name : ./dirdat/jl000342
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 141 (x008d) IO Time : 2014-07-09 14:01:03.268320
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 7688 AuditPos : 168771088
Continued : N (x00) RecCount : 1 (x01)
2014-07-09 14:01:03.268320 Insert Len 141 RBA 86710539
Name: EDMADMIN.PC_DATA_AUDIT_LOG
___________________________________________________________________
Reading ./dirdat/jl000342, current RBA 86710539, 0 records
Report at 2014-07-23 16:29:30 (activity since 2014-07-23 16:29:30)
From Table EDMADMIN.PC_DATA_AUDIT_LOG to EDMADMIN.PC_DATA_AUDIT_LOG:
# inserts: 0
# updates: 0
# deletes: 0
# discards: 1
Last log location read:
FILE: ./dirdat/jl000342
SEQNO: 342
RBA: 86710539
TIMESTAMP: 2014-07-09 14:01:03.268320
EOF: NO
READERR: 0
2014-07-23 16:29:30 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 = 1M 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 = 11 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 1M 0 0 0 0
1 2M 0 0 0 0
2 4M 0 0 0 0
3 8M 0 0 0 0
4 16M 0 0 0 0
5 32M 0 0 0 0
6 64M 0 0 0 0
7 128M 0 0 0 0
8 256M 0 0 0 0
9 512M 0 0 0 0
10 1G 0 0 0 0
================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: jlrep02 id: p22699_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: jlrep02 id: p22699_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 = 11 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 1M 0 0 0 0
1 2M 0 0 0 0
2 4M 0 0 0 0
3 8M 0 0 0 0
4 16M 0 0 0 0
5 32M 0 0 0 0
6 64M 0 0 0 0
7 128M 0 0 0 0
8 256M 0 0 0 0
9 512M 0 0 0 0
10 1G 0 0 0 0
================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: jlrep02 id: p22699_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: jlrep02 id: p22699_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
页:
[1]