Shareware software
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;