-
ORA-01291: missing logfile, but not actually
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|