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 220.127.116.11 and later
Information in this document applies to any platform.
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 +
ERROR at line 1:
ORA-01291: missing logfile
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 1
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