1. 问题

golden gate目标端检查发现错误 ogg-01296

1. 2.view report RORA_001找到错误ogg-01296对应的map表名

   可以使用如下方式快速检查

   
   

   Tail -3000 RORA_001.rpt >> /tmp/ RORA_001.rpt

   Cat  /tmp/ RORA_001.rpt |grep -i OGG-  会出现ogg-01296错误

2. edit report RORA_001在对应的map语句加--注释掉，启动复制进程，一般没有问题

3. 如果修改的表比较多，可以使用脚本检查

    itpub_ogg_表结构修改巡检脚本.txt

     检查源端数据库中修改了表结构的表，(LAST_DDL_TIME-CREATED)*24*60代表分钟数

----------

cat  /home/ogg/dirprm/eora_001.prm |grep -i table |awk '{print $2}'|cut -d ";" -f1 > /home/ogg/table_name.0517.txt

cat /dev/null > table_ddl_check.sql

cat  >> table_ddl_check.sql <<EOF

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

col object_name for a20

set line 220

EOF

tabname=`cat table_name.0517.txt`

for tab in $tabname

do

echo "select owner,OBJECT_NAME,CREATED,LAST_DDL_TIME,(LAST_DDL_TIME-CREATED)*24*60 time_sicne_ddl  from dba_objects where owner='`echo $tab|cut -d "." -f1`' and OBJECT_NAME='`echo $tab|cut -d "." -f2`' and (LAST_DDL_TIME-CREATED)*24*60>0;" >> table_ddl_check.sql

done

检查结果

以上是修改了表结构的表，如果是重新建的表就没法查了，目标端和源端表结构不一样，同样报0gg-01296错误

以下是查看当天新建的表

查看所有ogg源端配置中的用户当日新建的表

建立测试表create table ggs.t0517(id number);

cat  /home/ogg/dirprm/eora_001.prm |grep table |awk '{print $2}'|cut -d "," -f1 |cut -d "." -f1 >> /tmp/schema.txt    --得到抽取进程表的所有schema

rm -f  /tmp/1.sql 

cat >>/tmp/1.sql  <<EOF

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

set line 220

col object_name for a20

EOF

schema=`cat /tmp/schema.txt|sort |uniq` 

for user in $schema 

do 

echo "select owner,OBJECT_NAME,CREATED,LAST_DDL_TIME, (LAST_DDL_TIME-CREATED)*24*60 time_sicne_ddl from dba_objects where owner='$user'  and trunc(CREATED)=trunc(sysdate);">> /tmp/1.sql

done

运行结果

---查看scott用户15天之前建立的表

select owner,OBJECT_NAME,CREATED,LAST_DDL_TIME, (LAST_DDL_TIME-CREATED)*24*60 time_sicne_ddl,trunc(sysdate-CREATED)  from dba_objects where owner='SCOTT'  and trunc(sysdate-CREATED)>=15;