Question is can I run logmnr without setting SUPPLEMENTAL_LOG_DATA_MIN ??
I had a situation where I had to run log miner to undo some changes. I ran the log miner on the database where SUPPLEMENTAL_LOG_DATA_MIN was not set nor the dictionary was specified. I ran the following and was able to get the undo. I am a little confused there, as Oracle doc stats that SUPPLEMENTAL_LOG_DATA_MIN should be set to YES, before you can mine the logs.
These are the commands :
-- set session
ALTER SESSION SET nls_date_format='DD-MM-RRRR hh24:mi:ss';
-- start log minor,change datetime in the below SQL for the time frame
STARTTIME => '17/07/2012 13:30:00' ,
ENDTIME => '17/07/2012 14:30:00',
OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG +
-- change table_name to find out undo statements relating to that table
SELECT sql_undo FROM v$logmnr_contents where table_name =upper('machines');