ORA-31475: redo log catalog contains no metadata for the source table

ORA-31475: redo log catalog contains no metadata for the source table
Cause: While advancing a change set, an CDC attempted to query the LogMiner dictionary system tables to obtain the columns from the source table. The query returned no rows. This may be because none of the redo logs contains a catalog, or it may be an internal error.
Action: First, verify that the source system contains the source table. execute dbms_logmnr_d.build procedure to populate the redos log with logminer dictionary information. If this has been done and the problem persists, then contact Oracle Corporation

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-31475：重做日志目录不包含源表的元数据,
.原因：在推进变更集时，CDC尝试查询LogMiner字典系统表以从源表获取列。查询未返回任何行。这可能是因为重做日志都不包含目录，否则可能是内部错误。,
.操作：首先，验证源系统是否包含源表。执行dbms_logmnr_d.build过程以使用logminer字典信息填充重做日志。如果这已经完成，并且问题仍然存在，请联系Oracle公司,
.

aiaiDBA

13718043309

010-86462881

ORA-31475: redo log catalog contains no metadata for the source table

1 个回答

相似问题