Oracle 视图 DBA_LOGMNR_LOG 官方解释，作用，如何使用详细说明
本站中文解释
S
Oracle视图 DBA_LOGMNR_LOGS 用于跟踪在数据库中使用LogMiner运行的日志记录，以及模型日志文件的详细信息。
作为DBA或开发人员，可以使用DBA_LOGMNR_LOGS视图来访问LogMiner运行的历史记录。 您可以通过查询该视图从而获取当前和以前运行的LogMiner会话的历史记录，以及记录文件的详细信息（如文件大小、插入日期、状态等）。
您还可以使用该视图来检查模型日志文件的状态，以确保它们仍处于可用状态。例如，您可以使用如下查询语句检查模型日志文件的状态：
SELECT *
FROM DBA_LOGMNR_LOGS
WHERE STATUS != ‘AVAILABLE’;
官方英文解释
DBA_LOGMNR_LOG displays all archived logs registered with active LogMiner persistent sessions in the database.
A persistent LogMiner session is created either by starting Data Guard SQL Apply on a logical standby database for the first time or by creating Replication capture.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique identifier of the persistent session |
|
|
|
Name of the archived log |
|
|
|
|
|
Database identifier that produced the archived log |
|
|
|
|
SCN at which resetlogs operation was performed at the source database generating the archived log |
|
|
|
|
Timestamp at which resetlogs operation was performed at the source database generating the archived log |
|
|
|
Time at which the archived log was registered with LogMiner |
|
|
|
|
|
Redo thread at the source database that generated the archived log |
|
|
|
|
Logfile sequence number |
|
|
|
|
Lowest SCN of the redo record contained in the logfile |
|
|
|
Highest possible SCN of the redo record contained in the logfile |
|
|
|
|
Time of the first redo record contained in the logfile |
|
|
|
|
Time of the last redo record contained in the logfile |
|
|
|
|
Indicates whether the archived log contains the beginning of a LogMiner dictionary ( |
|
|
|
|
Indicates whether the archived log contains the end of a LogMiner dictionary ( |
|
|
|
|
Indicates whether the logfile is still required for this LogMiner session ( |
|
|
|
|
Indicates whether the archived log content was deemed to be corrupt or the archived log is partially filled ( |
