SELECT *
FROM (
         SELECT DISTINCT(first_value(lf.MEMBER) OVER (PARTITION BY lf.GROUP# ORDER BY lf.MEMBER)) AS FILENAME,
                        FIRST_CHANGE# AS FIRST,
                        NEXT_CHANGE# - 1 AS LAST
         FROM V$LOGFILE lf, V$LOG l
         WHERE lf.GROUP# = l.GROUP# AND l.ARCHIVED = 'NO'
         UNION
         SELECT NAME AS FILENAME,
                FIRST_CHANGE# AS FIRST,
                NEXT_CHANGE# - 1 AS LAST
         FROM V$ARCHIVED_LOG al
                  JOIN V$DATABASE_INCARNATION di ON(di.RESETLOGS_CHANGE# = al.RESETLOGS_CHANGE#)
         WHERE di.STATUS = 'CURRENT' AND al.DELETED = 'NO' AND al.STANDBY_DEST = 'NO'
     )
WHERE 7590034236000 <= LAST

-- +---------------------------------------------------------------------------+
-- |FILENAME                                                                   |
-- +---------------------------------------------------------------------------+
-- |/ora/orareco/PECBOFF3AZ1/archivelog/2023_10_05/o1_mf_1_591377_lky0ky09_.arc|
-- |/ora/orareco/PECBOFF3AZ1/archivelog/2023_10_05/o1_mf_1_591378_lky0l8pg_.arc|
-- |/ora/orareco/PECBOFF3AZ1/archivelog/2023_10_05/o1_mf_1_591379_lky0lctr_.arc|
-- |/ora/orareco/PECBOFF3AZ1/archivelog/2023_10_05/o1_mf_1_591380_lky1gcqy_.arc|
-- +---------------------------------------------------------------------------+
BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME => '/ora/orareco/PECBOFF3AZ1/archivelog/2023_10_05/o1_mf_1_591377_lky0ky09_.arc', OPTIONS => DBMS_LOGMNR.NEW); END;

BEGIN dbms_logmnr.start_logmnr(
        startscn => 7590034236000,
        endscn => 0, -- Just always read till the end of the log
        options => dbms_logmnr.SKIP_CORRUPTION + dbms_logmnr.NO_SQL_DELIMITER + dbms_logmnr.NO_ROWID_IN_STMT
            + dbms_logmnr.DICT_FROM_ONLINE_CATALOG + dbms_logmnr.STRING_LITERALS_IN_STMT);
END;

SELECT status, username, csf, seg_owner, table_name, scn, commit_scn, timestamp, operation, rollback, sql_redo, xid, session#
FROM v$logmnr_contents WHERE (operation_code IN (7, 36) OR (operation_code IN (1,2,3) AND ((seg_owner='P1BOFF' AND table_name='BOFF_ORDER'))))
                         AND username NOT IN ('SYS')
                       fetch first 50 rows only