合 OGG不抽取或不应用数据No active extraction maps 或 No active replication maps
Tags： OGGNo active extraction mapsNo active replication maps
No active extraction maps.
现象
感觉extract进程不工作，所有进程也不报错，使用stats统计时返回No active extraction maps.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | GGSCI (SFCTEST2) 3> stats extract ext Sending STATS request to EXTRACT EXT ... No active extraction maps. GGSCI (ogg) 34> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING JAGENT STOPPED PMSRVR STOPPED EXTRACT RUNNING EXT1 02:00:49 00:00:05 EXTRACT RUNNING EXTA 02:10:00 00:00:01 GGSCI (ogg) 35> stats ext1 Sending STATS request to Extract group EXT1 ... No active extraction maps. GGSCI (ogg) 36> |
解决
1、若是SQL Server数据库，则所有进程的参数文件配置中，表名前不能加数据库名。
例如：
错误写法：TABLE testing.dbo.*;
正确写法：TABLE dbo.*;
2、尝试做UPDATE和DELETE等DML操作。
3、尝试添加DYNAMICRESOLUTION 参数。
4、尝试查询select count(*) from DBA_GOLDENGATE_SUPPORT_MODE;视图。如果查询很久都不能出结果，那么，可能碰到数据库的bug了，需要修改该视图的定义。
我的情况是，Oracle 11.2.0.4的环境，业务表大约有2万个表，但是查询该视图很久不能出结果。解决办法，使用sys执行如下代码：
1 2 3 4 5 6 7 | create or replace view dba_xstream_out_support_mode (owner, object_name, support_mode) as select owner, table_name, 'FULL' from "_DBA_XSTREAM_OUT_ALL_TABLES" where owner not in ('SYS', 'SYSTEM', 'CTXSYS', 'DBSNMP', 'LBACSYS', 'MDDATA', 'MDSYS', 'DMSYS', 'OLAPSYS', 'ORDPLUGINS', 'ORDSYS', 'SI_INFORMTN_SCHEMA', 'SYSMAN', 'OUTLN', 'EXFSYS', 'WMSYS', 'XDB', 'DVSYS', 'ORDDATA'); |
然后查询select count(*) from DBA_GOLDENGATE_SUPPORT_MODE;视图可以秒出。
该问题耗费了我3天时间，具体可以参考：https://www.dbaup.com/shitudba_goldengate_support_modeyinqidejichengmoshioggbutongbuwentipaichaguocheng.html
No active replication maps
解决
1、源端是cdb，而目标端是非cdb，那么修改如下修改：
1 | MAP <PDB_name>.<owner>.*, TARGET <owner>.*; |
2、检查dump或extract的trail文件是否有内容生成
3、尝试重启replicate进程
Replicat Is Not Applying Changes To Database (文档 ID 2648750.1)
APPLIES TO:
Oracle GoldenGate - Version 12.3.0.1.4 and later
Information in this document applies to any platform.
SYMPTOMS
Configured a new GG setup. The extract/pump are up and running at the source and the replicat is up and running at the target. The extract is picking transactions from the source Database and the pump is sending it to the target server as appropriate. However, Replicat is reading the trail file sent by the Pump but not applying the changes to the target database.
1 2 3 4 5 6 7 8 9 10 11 12 13 | GGSCI > stats <replicat_name> Sending STATS request to REPLICAT <replicat_name> ... No active replication maps. Integrated Replicat Statistics: Total transactions 0.00 Redirected 0.00 Replicated procedures 0.00 DDL operations 0.00 Stored procedures 0.00 Datatype functionality 0.00 Event actions 0.00 Direct transactions ratio 0.00% |
CAUSE
Source database is multitenant but target is not multitenant. Below has been mentioned in replicat parameter file
