ORA-01333: failed to establish Logminer Dictionary

ORA-01333: failed to establish Logminer Dictionary
Cause: No previously established Logminer Dictionary is available and a complete gather of a source system data dictionary was not found in the logstream. build() may not have been run to force the gathering of a source system data dictiony. Or add_log_file() may not have been called to add all log files which contain the complete gathered system data dictionary.
Action: If build() was not employed prior to this mining session the Logminer Ad Hoc user may elect to employ an alternate dictionary such as the current system catalog or a previously built flat file dictionary. Other Logminer clients must run build() prior to mining. If build() has been run, ensure that all logfiles which comprise the gathered system dictionary have beed added. The following query, run on the system which build() was run, can be helpful in identifying the requried files. select DICTIONARY_BEGIN, DICTIONARY_END, name from v$archived_log; Minimally a set of files beginning with one which has DICTIONARY_BEGIN = 'YES' and all following log files through one marked DICTIONARY_END = 'YES' must be added.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01333：未能建立Logminer字典,
.原因：没有先前建立的Logminer字典可用，并且在日志流中找不到源系统数据字典的完整集合。build（）可能没有运行以强制收集源系统数据字典。或者可能没有调用add_log_file（）来添加包含完整收集的系统数据字典的所有日志文件。,
.操作：如果在此挖掘会话之前未使用build（），则Logminer Ad Hoc用户可以选择使用替代字典，例如当前系统目录或先前构建的平面文件字典。其他Logminer客户端必须在挖掘之前运行build（）。如果已运行build（），请确保添加了构成收集的系统字典的所有日志文件。以下查询在运行build（）的系统上运行，可有助于识别所需文件。选择DICTIONARY_BEGIN，DICTIONARY_END，来自v $ archived_log的名称; 最少必须添加一个以DICTIONARY_BEGIN =“YES”开头的文件集，以及通过一个标记为DICTIONARY_END =“YES”的所有以下日志文??件。,
.

aiaiDBA

13718043309

010-86462881

ORA-01333: failed to establish Logminer Dictionary

1 个回答

相似问题