Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ERROR OGG-01028 . I meet a problem that extract process often encounter OGG-01028

3366346Apr 11 2017 — edited May 30 2017

that error no have any other prompts

that is error

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

                 Oracle GoldenGate Capture for Oracle

Version 12.1.2.1.1 19797716 OGGCORE_12.1.2.1.1_PLATFORMS_141026.2215

  HP/UX, IA64, 64bit (optimized), Oracle 11g on Oct 27 2014 09:21:29

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

                    Starting at 2017-04-10 15:55:17

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

Operating System Version:

HP-UX

Version U, Release B.11.31

Node: ctsprd1

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: 10103

Description:

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

**            Running with the following parameters                  **

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

2017-04-10 15:55:17  INFO    OGG-03059  Operating system character set identified as hp-roman8.

2017-04-10 15:55:17  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.

extract cts1_e

userid sdg, password ********************************, blowfish, encryptkey default

2017-04-10 15:55:18  INFO    OGG-03522  Setting session time zone to source database time zone '+08:00'.

exttrail ./dirdat/jw

userid sdg@ctsdb,password ***

TRANLOGOPTIONS DBLOGREADER

TRANLOGOPTIONS MINEFROMACTIVEDG

eofdelaycsecs 10

getupdatebefores

nocompressdeletes

table KGDB.ORDERS,TOKENS(

sid = @GETENV ('DBENVIRONMENT','DBNAME'),

host = @GETENV('GGENVIRONMENT','HOSTNAME'),

commit_ts = @GETENV('RECORD','TIMESTAMP'),

logpos = @GETENV('GGHEADER','LOGPOSITION'),

logrba = @GETENV('GGHEADER','LOGRBA'));

table KGDB.BJ_CALL_APPOINMENT,TOKENS(

sid = @GETENV ('DBENVIRONMENT','DBNAME'),

host = @GETENV('GGENVIRONMENT','HOSTNAME'),

commit_ts = @GETENV('RECORD','TIMESTAMP'),

logpos = @GETENV('GGHEADER','LOGPOSITION'),

logrba = @GETENV('GGHEADER','LOGRBA'));

table KGDB.BJ_BB_CONTRACTS,TOKENS(

sid = @GETENV ('DBENVIRONMENT','DBNAME'),

host = @GETENV('GGENVIRONMENT','HOSTNAME'),

commit_ts = @GETENV('RECORD','TIMESTAMP'),

logpos = @GETENV('GGHEADER','LOGPOSITION'),

logrba = @GETENV('GGHEADER','LOGRBA'));

table KGDB.GP_SUMBOND,TOKENS(

sid = @GETENV ('DBENVIRONMENT','DBNAME'),

host = @GETENV('GGENVIRONMENT','HOSTNAME'),

commit_ts = @GETENV('RECORD','TIMESTAMP'),

logpos = @GETENV('GGHEADER','LOGPOSITION'),

logrba = @GETENV('GGHEADER','LOGRBA'));

table KGDB.BJ_BOND,TOKENS(

sid = @GETENV ('DBENVIRONMENT','DBNAME'),

host = @GETENV('GGENVIRONMENT','HOSTNAME'),

commit_ts = @GETENV('RECORD','TIMESTAMP'),

logpos = @GETENV('GGHEADER','LOGPOSITION'),

logrba = @GETENV('GGHEADER','LOGRBA'));

table KGDB.BJ_SUMBOND,TOKENS(

sid = @GETENV ('DBENVIRONMENT','DBNAME'),

host = @GETENV('GGENVIRONMENT','HOSTNAME'),

commit_ts = @GETENV('RECORD','TIMESTAMP'),

logpos = @GETENV('GGHEADER','LOGPOSITION'),

logrba = @GETENV('GGHEADER','LOGRBA'));

2017-04-10 15:55:18  INFO    OGG-01635  BOUNDED RECOVERY: reset to initial or altered checkpoint.

2017-04-10 15:55:18  INFO    OGG-01815  Virtual Memory Facilities for: BR

    anon alloc: mmap(MAP_ANON)  anon free: munmap

    file alloc: mmap(MAP_SHARED)  file free: munmap

    target directories:

    /data01/dsg/sdg/sdg/BR/CTS1_E.

Bounded Recovery Parameter:

BRINTERVAL = 4HOURS

BRDIR      = /data01/dsg/sdg/sdg

2017-04-10 15:55:18  INFO    OGG-01851  filecaching started: thread ID: 6.

2017-04-10 15:55:18  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:

    /data01/dsg/sdg/sdg/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)

CACHESIZE:                               64G

CACHEPAGEOUTSIZE (default):               8M

PROCESS VM AVAIL FROM OS (min):      116.07G

CACHESIZEMAX (strict force to disk):     96G

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

NLSRTL Version 11.2.0.4.0 - Production

Database Language and Character Set:

NLS_LANGUAGE     = "AMERICAN"

NLS_TERRITORY    = "AMERICA"

NLS_CHARACTERSET = "ZHS16GBK"

Maximum supported ASM read buffer size is 4096 KB

Maximum supported ASM read buffer size is 4096 KB

2017-04-10 15:55:18  INFO    OGG-00546  Default thread stack size: 4194304.

2017-04-10 15:55:18  INFO    OGG-01515  Positioning to begin time Apr 10, 2017 3:55:09 PM.

2017-04-10 15:55:22  INFO    OGG-01516  Positioned to (Thread 1) Sequence 86123, RBA 275917824, SCN 0.0, Apr 10, 2017 3:55:09 PM.

2017-04-10 15:55:22  INFO    OGG-01515  Positioning to begin time Apr 10, 2017 3:55:09 PM.

2017-04-10 15:55:25  INFO    OGG-01516  Positioned to (Thread 2) Sequence 76337, RBA 82870288, SCN 0.0, Apr 10, 2017 3:55:09 PM.

2017-04-10 15:55:25  INFO    OGG-01517  Position of first record processed for Thread 1, Sequence 86123, RBA 275917840, SCN 2419.787387499, Apr 10, 2017 3:55:09 PM.

2017-04-10 15:55:25  INFO    OGG-01055  Recovery initialization completed for target file ./dirdat/jw000890, at RBA 1403.

2017-04-10 15:55:25  INFO    OGG-01478  Output file ./dirdat/jw is using format RELEASE 12.1.

2017-04-10 15:55:25  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000890.

2017-04-10 15:55:25  INFO    OGG-01053  Recovery completed for target file ./dirdat/jw000891, at RBA 1403.

2017-04-10 15:55:25  INFO    OGG-01057  Recovery completed for all targets.

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

**                     Run Time Messages                             **

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

2017-04-10 15:55:25  INFO    OGG-01517  Position of first record processed for Thread 2, Sequence 76337, RBA 82870288, SCN 2419.787387474, Apr 10, 2017 3:55:09 PM.

2017-04-10 15:55:26  INFO    OGG-06507  MAPTABLE resolved (entry KGDB.ORDERS): table "KGDB"."ORDERS",TOKENS( sid = @GETENV ('DBENVIRONMENT','DBNAME'), host = @GETENV('GGENVIRONMENT','HOSTNAME'), commit_ts = @GETENV('RECORD','TIMESTAMP'), logpos = @GETENV('GGHEADER','LOGPOSITION'), logrba = @GETENV('GGHEADER','LOGRBA')).

2017-04-10 15:55:32  INFO    OGG-06509  Using the following key columns for source table KGDB.ORDERS: TRD_DATE, MARKET, BOARD, ORDER_ID, IS_WITHDRAW.

2017-04-10 15:55:42  INFO    OGG-01021  Command received from GGSCI: STATS.

2017-04-10 15:58:12  INFO    OGG-01971  The previous message, 'INFO OGG-01021', repeated 1 times.

2017-04-10 19:55:24  INFO    OGG-01738  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p10103_Redo_Thread_1: start=SeqNo: 86175, RBA: 338632720, SCN: 2419.796480366 (10390322369390), Timestamp: 2017-04-10 19:51:39.000000, end=SeqNo: 86175, RBA: 338632720, SCN: 2419.796480366 (10390322369390), Timestamp: 2017-04-10 19:51:39.000000, Thread: 1.

2017-04-10 19:55:24  INFO    OGG-01738  BOUNDED RECOVERY: CHECKPOINT: for object pool 2: p10103_Redo_Thread_2: start=SeqNo: 76429, RBA: 83359760, SCN: 2419.796479291 (10390322368315), Timestamp: 2017-04-10 19:51:38.000000, end=SeqNo: 76429, RBA: 99559872, SCN: 2419.796532039 (10390322421063), Timestamp: 2017-04-10 19:55:18.000000, Thread: 2.

2017-04-10 20:00:30  INFO    OGG-06507  MAPTABLE resolved (entry KGDB.BJ_BB_CONTRACTS): table "KGDB"."BJ_BB_CONTRACTS",TOKENS( sid = @GETENV ('DBENVIRONMENT','DBNAME'), host = @GETENV('GGENVIRONMENT','HOSTNAME'), commit_ts = @GETENV('RECORD','TIMESTAMP'), logpos = @GETENV('GGHEADER','LOGPOSITION'), logrba = @GETENV('GGHEADER','LOGRBA')).

2017-04-10 20:00:43  INFO    OGG-06509  Using the following key columns for source table KGDB.BJ_BB_CONTRACTS: TRD_DATE, SECU_ACC, MARKET, BOARD, MATCHED_SN, TRD_ID.

2017-04-10 20:01:52  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000891.

2017-04-10 22:13:13  INFO    OGG-06507  MAPTABLE resolved (entry KGDB.GP_SUMBOND): table "KGDB"."GP_SUMBOND",TOKENS( sid = @GETENV ('DBENVIRONMENT','DBNAME'), host = @GETENV('GGENVIRONMENT','HOSTNAME'), commit_ts = @GETENV('RECORD','TIMESTAMP'), logpos = @GETENV('GGHEADER','LOGPOSITION'), logrba = @GETENV('GGHEADER','LOGRBA')).

2017-04-10 22:14:08  INFO    OGG-06509  Using the following key columns for source table KGDB.GP_SUMBOND: MARKET, SECU_ACC, NODE_ID.

2017-04-10 22:14:08  INFO    OGG-06507  MAPTABLE resolved (entry KGDB.BJ_BOND): table "KGDB"."BJ_BOND",TOKENS( sid = @GETENV ('DBENVIRONMENT','DBNAME'), host = @GETENV('GGENVIRONMENT','HOSTNAME'), commit_ts = @GETENV('RECORD','TIMESTAMP'), logpos = @GETENV('GGHEADER','LOGPOSITION'), logrba = @GETENV('GGHEADER','LOGRBA')).

2017-04-10 22:14:26  INFO    OGG-06509  Using the following key columns for source table KGDB.BJ_BOND: SECU_INTL, NODE_ID.

2017-04-10 22:14:26  INFO    OGG-06507  MAPTABLE resolved (entry KGDB.BJ_SUMBOND): table "KGDB"."BJ_SUMBOND",TOKENS( sid = @GETENV ('DBENVIRONMENT','DBNAME'), host = @GETENV('GGENVIRONMENT','HOSTNAME'), commit_ts = @GETENV('RECORD','TIMESTAMP'), logpos = @GETENV('GGHEADER','LOGPOSITION'), logrba = @GETENV('GGHEADER','LOGRBA')).

2017-04-10 22:14:43  INFO    OGG-06509  Using the following key columns for source table KGDB.BJ_SUMBOND: MARKET, SECU_ACC, NODE_ID.

2017-04-10 23:50:13  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000892.

2017-04-10 23:50:18  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000893.

2017-04-10 23:51:03  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000894.

2017-04-10 23:51:32  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000895.

2017-04-10 23:51:36  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000896.

2017-04-10 23:52:35  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000897.

2017-04-10 23:52:40  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000898.

2017-04-10 23:52:45  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000899.

2017-04-10 23:53:52  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000900.

2017-04-10 23:53:57  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000901.

2017-04-10 23:54:08  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000902.

2017-04-10 23:54:56  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000903.

2017-04-10 23:55:01  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000904.

2017-04-10 23:55:23  INFO    OGG-01026  Rolling over remote file ./dirdat/jw000905.

Source Context :

  SourceModule            : [er.redo.ora.rtc]

  SourceID                : [/scratch/aime1/adestore/views/aime1_staok02/oggcore/OpenSys/src/app/er/redo/oracle/rtc.c]

  SourceFunction          : [RTC_producer]

  SourceLine              : [2185]

2017-04-10 23:55:28  ERROR   OGG-01028  .

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

*                   ** Run Time Statistics **                         *

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

Report at 2017-04-10 23:55:29 (activity since 2017-04-10 15:55:32)

Output to ./dirdat/jw:

From Table KGDB.ORDERS:

       #                   inserts:      4593

       #                   updates:     60575

       #                   befores:     60575

       #                   deletes:   1390812

       #                  discards:         0

From Table KGDB.BJ_BB_CONTRACTS:

       #                   inserts:      1914

       #                   updates:      4438

       #                   befores:      4438

       #                   deletes:      1621

       #                  discards:         0

From Table KGDB.GP_SUMBOND:

       #                   inserts:         0

       #                   updates:       113

       #                   befores:       113

       #                   deletes:         0

       #                  discards:         0

From Table KGDB.BJ_BOND:

       #                   inserts:         0

       #                   updates:        77

       #                   befores:        77

       #                   deletes:         0

       #                  discards:         0

From Table KGDB.BJ_SUMBOND:

       #                   inserts:         0

       #                   updates:         4

       #                   befores:         4

       #                   deletes:         0

       #                  discards:         0

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

*                   ** Run Time Statistics **                         *

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

Report at 2017-04-10 23:55:29 (activity since 2017-04-10 15:55:32)

Output to ./dirdat/jw:

From Table KGDB.ORDERS:

       #                   inserts:      4593

       #                   updates:     60575

       #                   befores:     60575

       #                   deletes:   1390812

       #                  discards:         0

From Table KGDB.BJ_BB_CONTRACTS:

       #                   inserts:      1914

       #                   updates:      4438

       #                   befores:      4438

       #                   deletes:      1621

       #                  discards:         0

From Table KGDB.GP_SUMBOND:

       #                   inserts:         0

       #                   updates:       113

       #                   befores:       113

       #                   deletes:         0

       #                  discards:         0

From Table KGDB.BJ_BOND:

       #                   inserts:         0

       #                   updates:        77

       #                   befores:        77

       #                   deletes:         0

       #                  discards:         0

From Table KGDB.BJ_SUMBOND:

       #                   inserts:         0

       #                   updates:         4

       #                   befores:         4

       #                   deletes:         0

       #                  discards:         0

This post has been answered by K.Gan on Apr 11 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2017
Added on Apr 11 2017
35 comments
3,794 views