Logminer - user interface

Working with a window

Logminer is an Oracle DBMS archived log mining engine.

Main window -> DB -> Logminer UI

Sequencing:

Enter the path to the folder with the archived logs in the "Archivelog directory" field.

Expanding the list selects information from v$parameter , non-empty parameter values log_archive_dest_%

Press the "Get list file" button to get a list of files in the directory
In the list "The list of files in the directory" select the necessary logs to view the data
"View data" button is pressed to load log data

Button "Stop logmnr" - close the dataset

Button "Reopen query" - reopen the dataset

Tab "Query" - query to view log data

Tab "Script" - the full text of the script for viewing logs

Getting a list of files in a directory

DECLARE
pattern VARCHAR2(1024) := $$FOLDER_PATH;
ns VARCHAR2(1024);
BEGIN
DBMS_OUTPUT.ENABLE(1000000);
SYS.DBMS_BACKUP_RESTORE.searchFiles(pattern, ns);
FOR each_file IN (SELECT FNAME_KRBMSFT AS name FROM X$KRBMSFT) LOOP
DBMS_OUTPUT.PUT_LINE(each_file.name);
END LOOP;
END;

Extracting data from logs

begin DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '$$FILE_PATH',OPTIONS => DBMS_LOGMNR.ADDFILE); end;

begin DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); end;

select * FROM v$logmnr_contents l;