Set serveroutput on size 100000;

accept logdir char prompt 'ENTER LOG DIR (Defined as UTL_FILE_DIR ) >  '
accept logfile char prompt 'ENTER LOG FILE NAME                     >  '

Begin
Sys.dbms_logmnr_d.build('&logfile','&logdir');
End;
/



Pause  'Press Enter to Proceed or Ctrl C to Exit'

set echo on
declare
cursor c1 is
select member from v$logfile;
loopctr number := 0;
vfilename varchar2(255);
begin
for c1rec in c1 loop
   if loopctr = 0 then
       
      dbms_logmnr.add_logfile (LogFileName =>c1rec.member,options => dbms_logmnr.new);
            
       dbms_output.put_line(c1rec.member||' is added to logmnr');
   else
       Begin
       select CHr(39)||c1rec.member||chr(39) into vfilename from dual;
       dbms_logmnr.add_logfile (LogFileName =>vfilename,Options => dbms_logmnr.addfile);
         dbms_output.put_line(c1rec.member||' is added to logmnr');
        Exception
          When others then
              NULL;
        End;
        loopctr := loopctr + 1;
      end if;
      end loop;
      end;
/



Pause  'Press Enter to Proceed or Ctrl C to Exit...'


Begin
    dbms_logmnr.start_logmnr ( dictfilename=> '&logdir\&logfile');
end;
/