Cannot find metadata property DDL_MD_COL_LOB_ENCRYPT

NOTE : we just upgraded our GG from 10.4 to 11.1.1.1.

just another day at work and got a call the our reporting database is lagging.
i checked the GG on the target and its working fine.

but when i check the source i see and error on gg log.

 
EXTRACT EARADMNE started.
Socket buffer size set to 27985 (flush size 27985).
Recovery initialization completed for target file /home/oracle/ggs11/dirdat/ed001500, at RBA 1346, CSN 845972482261.
Output file /home/oracle/ggs11/dirdat/ed is using format RELEASE 10.4/11.1.
Rolling over remote file /home/oracle/ggs11/dirdat/ed001501.
Position of first record processed Sequence 215348, RBA 185149968, SCN 196.4158866571, 2012-04-04 12:05:59 AM.

Object ARADMIN.T2625 has NOLOGGING option specified either at the table level or at the level of one of its (sub)partitions.
Cannot find metadata property DDL_MD_COL_LOB_ENCRYPT.  DDL metadata [,G1='ALTER TABLE T946 MODIFY \(C1000000927 varchar\(255\) \) ',,C6='GGS_DDL.GGS_MARKER',,C5='2207741',,C2='845972490753',,S='276796',,W='ARADMIN',,X='T946',,Y='TABLE',,Z='ALTER',,A1='103',,A1='103',,C3='',,C4='',,C15='NO',,R='8192',,I='276796',,J='',,K='55',,L='1',,M('1')='C1',,N='VALID',,G11='FALSE',,G7='NO',,G8='NO',,O='NO',,P='NO',,G2='NO',,C('1'),C('C1')='C1',,D('1'),D('C1')='VARCHAR2',,G13('1'),G13('C1')='',,E('1'),E('C1')='',,F('1'),F('C1')='B',,G10('1'),G10('C1')='15',,G('1'),G('C1')='0',,G9('1'),G9('C1')='0',,A2('1'),A2('C1')='C1',,A3('1'),A3('C1')='1',,A4('1'),A4('C1')='1',,A5('1'),A5('C1')='1',,A6('1'),A6('C1')='15',,A7('1'),A7('C1')='0',,A8('1'),A8('C1')='',,A9('1'),A9('C1')='',,B1('1'),B1('C1')='873',,A('1'),A('C1')='1',,C('2'),C('C2')='C2',,D('2'),D('C2')='VARCHAR2',,G13('2'),G13('C2')='',,E('2'),E('C2')='',,F('2'),F('C2')='B',,G10('2'),G10('C2')='254',,G('2'),G('C2')='0',,G9('2'),G9('C2')='0',,A2('2'),A2('C2')='C2',,A3('2'),A3('C2')='2',,A4('2'),A4('C2')='2',,A5('2'),A5('C2')='1',,A6('2'),A6('C2')='254',,A7('2'),A7('C2')='1',,A8('2'),A8('C2')='',,A9('2'),A9('C2')='',,B1('2'),B1('C2')='873',,A('2'),A('C2')='1',,C('3'),C('C3')='C3',,D('3'),D('C3')='NUMBER',,G13('3'),G13('C3')='',,E('3'),E('C3')='15',,F('3'),F('C3')='',,G10('3'),G10('C3')='22',,G('3'),G('C3')='0',,G9('3'),G9('C3')='0',,A2('3'),A2('C3')='C3',,A3('3'),A3('C3')='3',,A4('3'),A4('C3')='3',,A5('3'),A5('C3')='2',,A6('3'),A6('C3')='22',,A7('3'),A7('C3')='0',,A8('3'),A8('C3')='15',,A9('3'),A9('C3')='0',,B1('3'),B1('C3')='0',,A('3'),A('C3')='0',,C('4'),C('C4')='C4',,D('4'),D('C4')='VARCHAR2',,G13('4'),G13('C4')='',,E('4'),E('C4')='',,F('4'),F('C4')='B',,G10('4'),G10('C4')='254',,G('4'),G('C4')='0',,G9('4'),G9('C4')='0',,A2('4'),A2('C4')='C4',,A3('4'),A3('C4')='4',,A4('4'),A4('C4')='4',,A5('4'),A5('C4')='1',,A6('4'),A6('C4')='254',,A7('4'),A7('C4')='1',,A8('4'),A8('C4')='',,A9('4'),A9('C4')='',,B1('4'),B1('C4')='873',,A('4'),A('C4')='1',,C('5'),C('C5')='C5',,D('5'),D('C5')='VARC.
PROCESS ABENDING.

not really sure what to do and my colleague suggested to raise a SEV 1 SR.

we just upgraded our GG from 10.4 to 11.1.1.1.

oracle support suggested to do the following.

 

Login as sysdba to the database

Step 1) Run the ddl_disable script to disable the DDL trigger.
Step 2) Run the ddl_setup script. You will be prompted for:
-- The name of the GoldenGate schema.
-- The installation mode: Select the INITIALSETUP mode.
Depending on the GGS version you may also be prompted for
-- Purge RECYCLEBIN for all users: say YES.
Step 3) Run the ddl_enable.sql script to enable the DDL trigger.
Step 4). In GGSCI, restart the manager and then start Extract to resume DDL capture.
Step 5) Verify if the errors are still reported. 
 

after executing the above it fix our problem.
i’m not really sure if the above step was executed during the upgrade.

bai

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s