Saturday, June 25, 2016

ERROR OGG-01433 table is compressed and extract

Extract Abended with following error # 
2016-06-23 18:42:12  ERROR   OGG-01433  Failed to validate table delta.gg_new
The table is compressed and extract will not be able to extract data from Oracle logs.

work around # 
check table is compressed 

select compression from dba_tables
where owner = 'DELTA' and table_name = 'GG_NEW';

if the table is compressed / enabled. 
refer to follow link 
http://shaharear.blogspot.com/2008/10/table-compression.html

After uncompressing Table, restart the extract with begin now # 
# Goldengate cannot replicate compression Tables # 

Nikhil Tatineni--

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...