How to Resolve ORA-01291 Errors with Log miner continuous_mine after Incomplete Recovery (Doc ID 1906694.1)

Last updated on JULY 11, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

This note helps you in resolving the ORA-01291 errors with log miner continuous_mine after an incomplete recovery 

After a point in time recovery,  invoking Log Miner fails with ORA-01291 error.  It will not work even with any SCN, including SCNs very close to the  current point in time. All archivelogs and redo logs from the time since the chosen SCN are online and available, and can be individually added with logminer, but the continuous_mine option will not work.

BEGIN SYS.DBMS_LOGMNR.START_LOGMNR( STARTSCN =>
dbms_flashback.get_system_change_number, OPTIONS =>
SYS.DBMS_LOGMNR.DICT_FROM_REDO_LOGS + SYS.DBMS_LOGMNR.DDL_DICT_TRACKING +
SYS.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 1

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms