SQL> ed c:\temp\logmsetup.sql

SQL> @c:\temp\logmsetup.sql
ENTER LOG DIR (Defined as UTL_FILE_DIR ) >  c:\temp\logs
ENTER LOG FILE NAME                     >  ana1.log
old   2: Sys.dbms_logmnr_d.build('&logfile','&logdir');
new   2: Sys.dbms_logmnr_d.build('ana1.log','c:\temp\logs');
LogMnr Dictionary Procedure started
LogMnr Dictionary File Opened
TABLE: OBJ$ recorded in LogMnr Dictionary File
TABLE: TAB$ recorded in LogMnr Dictionary File
TABLE: COL$ recorded in LogMnr Dictionary File
TABLE: SEG$ recorded in LogMnr Dictionary File
TABLE: UNDO$ recorded in LogMnr Dictionary File
TABLE: UGROUP$ recorded in LogMnr Dictionary File
TABLE: TS$ recorded in LogMnr Dictionary File
TABLE: CLU$ recorded in LogMnr Dictionary File
TABLE: IND$ recorded in LogMnr Dictionary File
TABLE: ICOL$ recorded in LogMnr Dictionary File
TABLE: LOB$ recorded in LogMnr Dictionary File
TABLE: USER$ recorded in LogMnr Dictionary File
TABLE: FILE$ recorded in LogMnr Dictionary File
TABLE: PARTOBJ$ recorded in LogMnr Dictionary File
TABLE: PARTCOL$ recorded in LogMnr Dictionary File
TABLE: TABPART$ recorded in LogMnr Dictionary File
TABLE: INDPART$ recorded in LogMnr Dictionary File
TABLE: SUBPARTCOL$ recorded in LogMnr Dictionary File
TABLE: TABSUBPART$ recorded in LogMnr Dictionary File
TABLE: INDSUBPART$ recorded in LogMnr Dictionary File
TABLE: TABCOMPART$ recorded in LogMnr Dictionary File
TABLE: INDCOMPART$ recorded in LogMnr Dictionary File
Procedure executed successfully - LogMnr Dictionary Created

PL/SQL procedure successfully completed.

'Press Enter to Proceed or Ctrl C to Exit'

SQL> declare
  2  cursor c1 is
  3  select member from v$logfile;
  4  loopctr number := 0;
  5  vfilename varchar2(255);
  6  begin
  7  for c1rec in c1 loop
  8     if loopctr = 0 then
  9
 10        dbms_logmnr.add_logfile (LogFileName =>c1rec.member,options => dbms_logmnr.new);
 11
 12         dbms_output.put_line(c1rec.member||' is added to logmnr');
 13     else
 14         Begin
 15         select CHr(39)||c1rec.member||chr(39) into vfilename from dual;
 16         dbms_logmnr.add_logfile (LogFileName =>vfilename,Options => dbms_logmnr.addfile
 17           dbms_output.put_line(c1rec.member||' is added to logmnr');
 18          Exception
 19            When others then
 20                NULL;
 21          End;
 22          loopctr := loopctr + 1;
 23        end if;
 24        end loop;
 25        end;
 26  /
G:\ORANT\ORADATA\LOG1SDMS606.ORA is added to logmnr
G:\ORANT\ORADATA\LOG2SDMS606.ORA is added to logmnr
G:\ORANT\ORADATA\LOG3SDMS606.ORA is added to logmnr
G:\ORANT\ORADATA\LOG4SDMS606.ORA is added to logmnr

PL/SQL procedure successfully completed.

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

SQL>
SQL>
SQL> Begin
  2      dbms_logmnr.start_logmnr ( dictfilename=> '&logdir\&logfile');
  3  end;
  4  /
old   2:     dbms_logmnr.start_logmnr ( dictfilename=> '&logdir\&logfile');
new   2:     dbms_logmnr.start_logmnr ( dictfilename=> 'c:\temp\logs\ana1.log');

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>