Need another set of eyes

From: Ed Stevens <nospam_at_noway.nohow>
Date: Tue, 05 Aug 2003 14:38:11 -0500
Message-ID: <se10jv0q8hb4mlq5mmu6sd339o8veh86m2@4ax.com>

Platform: Oracle 8.1.7.4 on Win2k.

Playing around with LogMiner and taking a page from Tom Kyte's book. First, I try Tom's procedure to add the latest archive log to Logminer:

SQL> declare
  2 l_name v$archived_log.name%type;
  3 begin
  4 select name into l_name
  5 from v$archived_log
  6 where completion_time = ( select max(completion_time)

  7                    from v$archived_log);

  8 sys.dbms_logmnr.add_logfile(l_name, sys.dbms_logmnr.NEW);   9 end;
 10 /
declare
*
ERROR at line 1:

ORA-01284: file F:\ORAARCH\EDST\ARCH_1691.ARC cannot be opened
ORA-00308: cannot open archived log 'F:\ORAARCH\EDST\ARCH_1691.ARCsql'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Notice on the ORA-00308 line, the 'sql' that was appended to the end of the file name.

So I try it manually:

SQL> begin
  2 sys.dbms_logmnr.add_logfile('F:\ORAARCH\EDST\ARCH_1691.ARC', sys.dbms_logmnr.NEW);
  3 end;
  4 /

PL/SQL procedure successfully completed.

So, a pair of sharp eyes is needed to see what I'm missing in the prodedure. Anyone? Received on Tue Aug 05 2003 - 14:38:11 CDT