1 Reply Latest reply: Jul 19, 2012 1:14 PM by Sunny kichloo RSS

    Can I run logmnr without setting  SUPPLEMENTAL_LOG_DATA_MIN ??

    NirmalSArri
      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
      BEGIN
      DBMS_LOGMNR.START_LOGMNR(
      STARTTIME => '17/07/2012 13:30:00' ,
      ENDTIME => '17/07/2012 14:30:00',
      OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG +
      DBMS_LOGMNR.CONTINUOUS_MINE +
      DBMS_LOGMNR.COMMITTED_DATA_ONLY +
      DBMS_LOGMNR.PRINT_PRETTY_SQL);
      END;
      /

      -- change table_name to find out undo statements relating to that table
      SELECT sql_undo FROM v$logmnr_contents where table_name =upper('machines');

      --stop logminor
      exec dbms_logmnr.end_logmnr;




      Thanks

      Nirmal