Hi all,
OS - win 2000 SP4
Database - Oracle 10.2.0.1

I am trying to run the logminer utility in Oracle 10g,but dbms_logmnr.start_logmnr stops with error ORA-01291: missing logfile if STARTIME is used. I used the same steps in 9i, which executed without error. Below is the code which are executed in order.

SQL> SELECT VL.MEMBER FROM V$LOGFILE VL,V$LOG L WHERE L.GROUP#=VL.GROUP# AND L.STATUS='CURRENT';

MEMBER
--------------------------------------------------------------------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAC30DB\REDO03.LOG
-----
SQL> exec dbms_logmnr.add_logfile('D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAC30DB\REDO03.LOG',dbms_logmnr.
new);

PL/SQL procedure successfully completed.

+SQL> exec dbms_logmnr.start_logmnr(OPTIONS =>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.COMM+
ITTED_DATA_ONLY);

PL/SQL procedure successfully completed.
This runs with out any error. But I dont want to mine the whole log and so i specified STARTTIME.

SQL> select LOG_ID,FILENAME,TO_CHAR(LOW_TIME,'DD-MON-YYYY HH24:MI:SS'),TO_CHAR(HIGH_TIME,'DD-MON-YYY
Y HH24:MI:SS') from v$logmnr_logs;

LOG_ID
----------
FILENAME
--------------------------------------------------------------------------------
TO_CHAR(LOW_TIME,'DD TO_CHAR(HIGH_TIME,'D
-------------------- --------------------
30
D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAC30DB\REDO03.LOG
17-DEC-2008 11:11:32 01-JAN-1988 00:00:00

I added one second to 17-DEC-2008 11:11:32 and used below.

SQL> exec dbms_logmnr.start_logmnr(OPTIONS =>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.COMM
ITTED_DATA_ONLY, STARTTIME => TO_DATE('17-DEC-2008 11:11:33', 'DD-MON-YYYY HH24:MI:SS'));
BEGIN dbms_logmnr.start_logmnr(OPTIONS =>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.COMMITTE

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

Other two log files do not have sqls in this time range. Please see below. I added other two log files to list.

SQL> select LOG_ID,FILENAME,TO_CHAR(LOW_TIME,'DD-MON-YYYY HH24:MI:SS'),TO_CHAR(HIGH_TIME,'DD-MON-YYY
Y HH24:MI:SS') from v$logmnr_logs;

LOG_ID
----------
FILENAME
--------------------------------------------------------------------------------
TO_CHAR(LOW_TIME,'DD TO_CHAR(HIGH_TIME,'D
-------------------- --------------------
28
D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAC30DB\REDO01.LOG
15-DEC-2008 16:17:24 15-DEC-2008 17:03:52

29
D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAC30DB\REDO02.LOG
15-DEC-2008 17:03:52 17-DEC-2008 11:11:32

LOG_ID
----------
FILENAME
--------------------------------------------------------------------------------
TO_CHAR(LOW_TIME,'DD TO_CHAR(HIGH_TIME,'D
-------------------- --------------------

30
D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAC30DB\REDO03.LOG
17-DEC-2008 11:11:32 01-JAN-1988 00:00:00

I used same method in Oracle 9i and it worked. I cant use ENDTIME, since it has LOW_TIME as 01-JAN-1988 00:00:00.

Can any one point out the issue here?
Thanks