Oracle LOGMNR Tool Analysis Log Script

In Oracle, this is not unfamiliar with the LOGMNR tool analysis log, which is often used for data recovery scenarios, where it is convenient to analyze archived logs;

Of course, there is a LOGMNR interface tool on the Internet; the download requires points; Write a script for that.

##===========================================================# # oracle_log_fetch.sh # Created by Lottu # # ./ ,/ -# # usage:oracle_log_fetch.sh $START _time # #============================================================  #!/bin/Bash Oracle_sid=ora11g; Start_time=$1; Out_file="/tmp/logfilelist"Sqlplus/ asSYSDBA >/dev/NULL 2>&1<<EOFSetecho offSetFeedback offSetheading Offspool ${out_file}Selectname fromv\ $archived _logwhereNext_time > To_date ('${start_time}','YYYY-MM-DD Hh24:mi:ss'); spool Offexiteof#dbms_logmnr.add_logfile (LogFileName="'); awk'begin{print "BEGIN"}nr>10 &&!/sql/{print "Dbms_logmnr.add_logfile (logfilename=>'\' ' " $"'\ '');"}end{print"End \ n \"} '/tmp/logfilelist.lst > Addlogfile.sqlSqlplus/ asSYSDBA >/dev/NULL 2>&1<<eofstart addlogfile.sql;exec DBMS_LOGMNR.START_LOGMNR (Options=dbms_logmnr.dict_from_online_catalog); Truncate table Lottu.lottu01;insert into lottu.lottu01Select* fromv$logmnr_contents;commit;exec dbms_logmnr.end_logmnr;exiteof

Oracle LOGMNR Tool Analysis Log Script