DBA_LOGMNR

5.157 DBA_LOGMNR_LOG

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
`LOGMNR_SESSION_ID`	`NUMBER`	`NOT NULL`	Unique identifier of the persistent session
`NAME`	`VARCHAR2(513)`		Name of the archived log
`DBID`	`NUMBER`	`NOT NULL`	Database identifier that produced the archived log
`RESETLOGS_SCN`	`NUMBER`	`NOT NULL`	SCN at which resetlogs operation was performed at the source database generating the archived log
`RESETLOGS_TIME`	`NUMBER`	`NOT NULL`	Timestamp at which resetlogs operation was performed at the source database generating the archived log
`MODIFIED_TIME`	`DATE`		Time at which the archived log was registered with LogMiner
`THREAD#`	`NUMBER`	`NOT NULL`	Redo thread at the source database that generated the archived log
`SEQUENCE#`	`NUMBER`	`NOT NULL`	Logfile sequence number
`FIRST_SCN`	`NUMBER`	`NOT NULL`	Lowest SCN of the redo record contained in the logfile
`NEXT_SCN`	`NUMBER`		Highest possible SCN of the redo record contained in the logfile
`FIRST_TIME`	`DATE`		Time of the first redo record contained in the logfile
`NEXT_TIME`	`DATE`		Time of the last redo record contained in the logfile
`DICTIONARY_BEGIN`	`VARCHAR2(3)`		Indicates whether the archived log contains the beginning of a LogMiner dictionary (`YES`) or not (`NO`)
`DICTIONARY_END`	`VARCHAR2(3)`		Indicates whether the archived log contains the end of a LogMiner dictionary (`YES`) or not (`NO`)
`KEEP`	`VARCHAR2(3)`		Indicates whether the logfile is still required for this LogMiner session (`YES`) or not (`NO`)
`SUSPECT`	`VARCHAR2(3)`		Indicates whether the archived log content was deemed to be corrupt or the archived log is partially filled (`YES`) or not (`NO`)