Oracle Database Discussions

Hello,

I am trying to use LogMiner to analyze redo logs (SCN approach), saw a prolbem...

like,


1. extract the data dictionary to the redo logs

begin
sys.dbms_logmnr_d.build( OPTIONS => sys.DBMS_LOGMNR_D.store_in_redo_logs);
end;
/


2. Display all today's archived redo log files that have been generated so far.

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY HH24:MI';

SQL> select name from v$archived_log where COMPLETION_TIME > '01_20_2010 23:00';

/usr/tmp/arch/1_4237_573231463.dbf
/usr/tmp/arch/1_4238_573231463.dbf
/usr/tmp/arch/1_4239_573231463.dbf
/usr/tmp/arch/1_4240_573231463.dbf
/usr/tmp/arch/1_4241_573231463.dbf
/usr/tmp/arch/1_4242_573231463.dbf



--

3. Specify the list of redo log files to be analyzed

begin
sys.dbms_logmnr.add_logfile( logfilename=> '/usr/tmp/arch/1_4237_573231463.dbf',
options=> sys.dbms_logmnr.new);
end;
/



--add all rest log files


EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'/usr/tmp/arch/1_4238_573231463.dbf');
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'/usr/tmp/arch/1_4239_573231463.dbf');
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'/usr/tmp/arch/1_4240_573231463.dbf');
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'/usr/tmp/arch/1_4241_573231463.dbf');
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'/usr/tmp/arch/1_4242_573231463.dbf');




5. start logminer, analyze by using SCN

BEGIN
DBMS_LOGMNR.START_LOGMNR(
STARTSCN => 4237
,ENDSCN => 4242
,OPTIONS => dbms_logmnr.dict_from_redo_logs + DBMS_LOGMNR.CONTINUOUS_MINE
);
END;
/

ERROR at line 1:
ORA-01291: missing logfile
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 2


I think I already added all archived redo logs files to logminer for analyzing? what is wrong....?


Thanks in advance

Jerry