ITPub博客

首页 > 数据库 > Oracle > STATS COMMAND Displays "No Active Replication Maps" (文档 ID 967319.1)

STATS COMMAND Displays "No Active Replication Maps" (文档 ID 967319.1)

原创 Oracle 作者:lhrbest 时间:2020-11-20 14:18:07 0 删除 编辑

STATS COMMAND Displays "No Active Replication/Extraction Maps" (文档 ID 967319.1)


In this Document

Goal
Solution

APPLIES TO:

Oracle GoldenGate - Version 4.0.0 and later
Information in this document applies to any platform.

GOAL

Provide additional information to the user on why the STATS COMMAND Displays "no Active Replication/extraction Maps".

SOLUTION

Issue: 

STATS COMMAND displays "no active replication/extraction maps" 


Solution Summary: 

This internal mapping table used by the extract and/or replicat process to build statistics must be created. 


Solution Description: 
GGSCI> STATS <replicat group> 
"no active replication maps" 



GGSCI> STATS <extract group> 
"no active extraction maps" 

Directly related to the usage of the DYNAMICRESOLUTION parameter 


During normal (without DYNAMICRESOLUTION parameter) start-up for extract and replicat the processes query the database for the attributes of the tables that are being processed. i.e.the list of tables in the include files that you have in your parameter files and builds an internal mapping table. The DYNAMICRESOLUTION parameter prevents this from happening at start-up. 

The mapping table is not built in extract until the object ID of a table in the parameter file is read from the transaction log. If no transaction log records have been read and processed by the extract process, the internal mapping table has not been built. 

In the replicat process, the internal mapping table is built when a record is read from the input trail that matches one of the tables in the parameter file. If there are no records on the replicat input trail or there are records but they do not match the tables in the map/target parameter statements the internal mapping table has not been built. 

This internal mapping table is used by the extract and/or replicat process to build statistics. If this table is not built, there is nothing for the STATS command to use to create the statistics report. 

The message that is displayed indicates that nothing has been processed in the extract or replicat that contains a DYNAMICRESOLUTION parameter. Once data for the tables in the extract and replicat are processed (captured from or applied to DB) the STATS command produces processing statistics. 



References: 


Keywords: 

STATS, DYNAMICRESOLUTION, Extract, GGSCI 

***Checked for relevance on 20-May-2011*** 

Replicat Is Not Applying Changes To Database (文档 ID 2648750.1)


In this Document

Symptoms
Changes
Cause
Solution


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.

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%

CHANGES

 

CAUSE

Source database is multitenant but target is not multitenant. Below has been mentioned in replicat parameter file

SOURCECATALOG <PDB_name>

MAP <owner>.*, TARGET <owner>.*;

SOLUTION

Please remove below parameter

--> SOURCECATALOG <PDB_name>

and mention like below in replicat

--> MAP <PDB_name>.<owner>.*, TARGET <owner>.*;




DYNAMICRESOLUTION

Sometimes the OGG process is slower. It may be because there are too many tables to be synchronized. OGG will create a record and save it to disk before the process is started. This takes a lot of time. Use this parameter to resolve this issue.



有时候开启OGG进程的时候较慢,可能是因为需要同步的表太多,OGG在开启进程之前会将需要同步的表建立一个记录并且存入到磁盘中,这样就需要耗费大量的时间。OGG同时也提供了DYNAMICRESOLUTION | NODYNAMICRESOLUTION参数来解决这个问题,看官方如何描述的:


DYNAMICRESOLUTION | NODYNAMICRESOLUTION 


Valid for Extract and Replicat 
Use the DYNAMICRESOLUTION and NODYNAMICRESOLUTION parameters to control how table 
names are resolved. 


Use DYNAMICRESOLUTION to make processing start sooner when there is a large number of 
tables specified in TABLE or MAP statements. By default, whenever a process starts, 
GoldenGate queries the database for the attributes of the tables and then builds an object 
record for them. The record is maintained in memory and on disk, and the process of 
building it can be time-consuming if the database is large. 


DYNAMICRESOLUTION causes the object record to be built one table at a time, instead of all at 
once. A table’s attributes are added to the record the first time its object ID enters the 
transaction log, which occurs with the first extracted transaction on that table. Recordbuilding 
for other tables is deferred until activity occurs. DYNAMICRESOLUTION is the same as 
WILDCARDRESOLVE DYNAMIC. 


NODYNAMICRESOLUTION causes the object record to be built at startup. This option is not 
supported for Teradata. NODYNAMICRESOLUTION is the same as WILDCARDRESOLVE IMMEDIATE. 
For more information about WILDCARDRESOLVE, see page 368. 






About Me

........................................................................................................................

● 本文作者:小麦苗,部分内容整理自网络,若有侵权请联系小麦苗删除

● 本文在个人微 信公众号( DB宝)上有同步更新

● QQ群号: 230161599 、618766405,微信群私聊

● 个人QQ号(646634621),微 信号(db_bao),注明添加缘由

● 于 2020年11月完成

● 最新修改时间:2020年11月

● 版权所有,欢迎分享本文,转载请保留出处

........................................................................................................................

小麦苗的微店https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

● 小麦苗出版的数据库类丛书: http://blog.itpub.net/26736162/viewspace-2142121/

小麦苗OCP、OCM、高可用、MySQL、DBA学习班http://blog.itpub.net/26736162/viewspace-2148098/

● 数据库笔试面试题库及解答: http://blog.itpub.net/26736162/viewspace-2134706/

........................................................................................................................

请扫描下面的二维码来关注小麦苗的微 信公众号( DB宝)及QQ群(230161599、618766405)、添加小麦苗微 信(db_bao), 学习最实用的数据库技术。

........................................................................................................................

 

 



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26736162/viewspace-2735551/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
【QQ:646634621】【微信:db_bao】【微信公众号:DB宝】【11g、12c OCM】【QQ群:230161599、618766405】【《数据库笔试面试宝典》作者】【OCP、OCM、高可用(RAC+DG+OGG)、MySQL培训班已开讲,只讲实用内容】

注册时间:2012-09-23

  • 博文量
    1586
  • 访问量
    9180600