Oracle PL/SQL Tutorial/System Packages/dbms logmnr

dbms_logmnr.add_logfile

SQL>
SQL> declare
  2      l_name v$archived_log.name%type;
  3  begin
  4      select name into l_name from v$archived_log
  5       where completion_time = ( select max(completion_time) from v$archived_log );
  6
  7      sys.dbms_logmnr.add_logfile( l_name, sys.dbms_logmnr.NEW );
  8  end;
  9  /
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 4

sys.dbms_logmnr.add_logfile

SQL>
SQL> begin
  2     sys.dbms_logmnr.add_logfile( "C:\ARC00028.001",sys.dbms_logmnr.NEW );
  3  end;
  4  /
begin
*
ERROR at line 1:
ORA-01284: file C:\ARC00028.001 cannot be opened
ORA-00308: cannot open archived log "C:\ARC00028.001"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 2

SQL>

sys.dbms_logmnr_d.build

SQL>
SQL> begin
  2     sys.dbms_logmnr_d.build( "miner_dictionary.dat","c:\temp" );
  3  end;
  4  /
LogMnr Dictionary Procedure started
ERROR -1308  ORA-01308: initialization parameter utl_file_dir is not set
begin
*
ERROR at line 1:
ORA-01308: initialization parameter utl_file_dir is not set
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3474
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3552
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 12
ORA-06512: at line 2

SQL>

sys.dbms_logmnr.start_logmnr

SQL>
SQL>
SQL> begin
  2     sys.dbms_logmnr.start_logmnr( dictFileName => "c:\miner_dictionary.dat" );
  3  end;
  4  /
begin
*
ERROR at line 1:
ORA-01292: no log file has been specified for the current LogMiner session
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 2

SQL>