SQL> alter database add supplemental log data;
 
Database altered

SQL> BEGIN
      dbms_logmnr.add_logfile('/oracle/winmdb2/redo01.log');
      dbms_logmnr.add_logfile('/oracle/winmdb2/redo02.log');
      dbms_logmnr.add_logfile('/oracle/winmdb2/redo03.log');
     END;
    /
 
PL/SQL procedure successfully completed

SQL> BEGIN
      DBMS_LOGMNR.START_LOGMNR (
options =>dbms_logmnr.dict_from_online_catalog+dbms_logmnr.print_pretty_sql+dbms_logmnr.no_sql_delimiter);
    END;
   /
 
PL/SQL procedure successfully completed

SQL> select sql_undo, sql_redo
  2    from v$logmnr_contents
  3    where seg_owner = 'WMGABI'
  4  ORDER BY timestamp
  5  /
 
select sql_undo, sql_redo
  from v$logmnr_contents
  where seg_owner = 'WMGABI'
ORDER BY timestamp
 
ORA-03113: end-of-file on communication channel