Shulou(Shulou.com)06/01 Report--

*

Oracle GoldenGate Capture 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:42:16

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

Extract process configuration

-- basic parameter area

EXTRACT extdr

SETENV (NLS_LANG= "AMERICAN_AMERICA.AL32UTF8")

Set environment variable (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

USERID dkogg,PASSWORD * *, ENCRYPTKEY default

REPORTCOUNT EVERY 30 MINUTES,RATE

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

DISCARDROLLOVER AT 3:00

WARNLONGTRANS 2h, CHECKINTERVAL 3m

EXTTRAIL. / dirdat/sa

DYNAMICRESOLUTION

DBOPTIONS ALLOWUNUSEDCOLUMN

FETCHOPTIONS NOUSESNAPSHOT

TRANLOGOPTIONS CONVERTUCS2CLOBS

2015-05-25 13:44:35 WARNING OGG-00254 CONVERTUCS2CLOBS is a deprecated parameter.

TRANLOGOPTIONS EXCLUDEUSER dkogg

THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000 IOLATENCY 60000

-- TRANLOGOPTIONS _ INFINITYTOZER

TRANLOGOPTIONS _ INFINITYTOZERO

-- NODDLCHANGEWARNING

-- DDL parameter area, all copied objects and shielded objects are reflected on the source side.

DDL INCLUDE MAPPED OBJTYPE 'TABLE' INCLUDE MAPPED OBJTYPE' INDEX' INCLUDE MAPPED OBJTYPE 'SEQUENCE' INCLUDE MAPPED OBJTYPE' VIEW' INCLUDE MAPPED OBJTYPE 'PROCEDURE' INC

LUDE MAPPED OBJTYPE 'FUNCTION' INCLUDE MAPPED OBJTYPE' PACKAGE' EXCLUDE OPTYPE COMMENT

DDLOPTIONS addtrandata REPORT

-- add object

TABLE DUSER.*

SEQUENCE DUSER.*

Process ABENDED was found today.

View:

*

* * Run Time Messages * *

*

2015-05-25 13:44:42 INFO OGG-01517 Position of first record processed Sequence 336592, RBA 157712, SCN 16.1806035766, 2015-5-25 11:27:56

TABLE resolved (entry DKADVUSER.DK_B_ORGANIZATION):

TABLE "DKADVUSER". "DK_B_ORGANIZATION"

Using the following key columns for source table DKADVUSER.DK_B_ORGANIZATION: ORGANIZATION_ID.

Source Context:

SourceModule: [er.processloop]

SourceID: [/ scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/processloop.cpp]

SourceFunction: [process_extract_loop]

SourceLine: [873]

ThreadBacktrace: [7] elements

: [/ opt/ogg/libgglog.so (CMessageContext::AddThreadContext () + 0x1e) [0x7fde5399d06e]]

: [/ opt/ogg/libgglog.so (CMessageFactory::CreateMessage (CSourceContext*, unsigned int,...) + 0x2cc) [0x7fde5399944c]]

: [/ opt/ogg/libgglog.so (_ MSG_ERR_ER_GENERIC_FAILURE (CSourceContext*, char const*, CMessageFactory::MessageDisposition) + 0x31) [0x7fde539812a9]]

: [/ opt/ogg/extract (process_extract_loop () + 0x3884) [0x55d9b4]]

: [/ opt/ogg/extract (main+0x5d9) [0x56cb99]]

: [/ lib64/libc.so.6 (_ _ libc_start_main+0xfd) [0x3e3ee1ed5d]]

: [/ opt/ogg/extract (_ _ gxx_personality_v0+0x38a) [0x4e8b7a]]

2015-05-25 13:44:43 ERROR OGG-01028 Record on table DUSER.B_ORGANIZATION with rowid AAAX05AAOAAGfocAAH from transaction 13.33.4286930 (0x000d.021.004169d2) I

S compressed. Compression is not supported.

So the B_ORGANIZATION table is compression and DISABLED.

Look carefully and find out why.

1 、 alter table... Modify partition... Compress..., this method applies only to newly inserted data.

2 、 alter table... Move partition... Compress., this method is suitable for newly inserted data and existing data.

At that time, the compressed table was decompressed, and the first modify method I used was decompressed. That is to say, the current program has re-edited the row of data AAAX05AAOAAGfocAAH in the table B_ORGANIZATION, so that there will be OOG-01028 errors. Here is the solution to oracle:

However, due to bug 10063108, sometimes the error message on compressed tables are not entirely correct. This problem has been fixed in 11.1.1.0.3 and above

A table created as compressed will cause all of the DMLas to go into compressed blocks on disk. If the user does an "alter table nocompress", every DML that goes into the table AFTER that point in time will be uncompressed. The query for compression will return "nocompress" now, but that simple "alter" does not change the already existing compressed blocks on disk that were created before the "alter". So to capture the records from a table which was compressed we need to do the following

SQL > alter table move nocompress

This will touch every single block on disk and will uncompress everything and so OGG should be all good.

If it is a partition table, please use

SQL > ALTER TABLE MOVE PARTITION NOCOMPRESS TABLESPACE

If the segment of the table is large, make sure there is enough space first.

Resynchronize the table when it is finished.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.