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 Streams 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 ( |