My Oracle Support Banner

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

Last updated on MARCH 27, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.