Results 1 to 3 of 3

Thread: log minor

  1. #1
    Join Date
    Feb 2008
    Posts
    38

    Unanswered: log minor

    Hi
    I cannot see any data by using logminor if I dont enable supplemental log.
    I dont understand why.
    Oracle XE on windows
    Here is my work:

    delete from branch.pricelist where rownum<2
    1 row deleted.
    commit;


    BEGIN
    DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\XE\REDO1.LOG');
    DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\XE\REDO2.LOG');
    DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\XE\REDO3.LOG');
    END;
    /


    BEGIN DBMS_LOGMNR.START_LOGMNR (options => dbms_logmnr.dict_from_online_catalog);
    END;
    /


    select SQL_UNDO from
    v$logmnr_contents
    where table_name='PRICELIST'
    AND OPERATION='DELETE'
    ORDER BY TİMESTAMP DESC


    no rows selected.



    BEGIN
    DBMS_LOGMNR.END_LOGMNR;
    END;
    /

    -----------------------------------------------------------------------------------------------------------

    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

    delete from branch.pricelist where rownum<2
    1 row deleted
    commit;

    BEGIN
    DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\XE\REDO1.LOG');
    DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\XE\REDO2.LOG');
    DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\XE\REDO3.LOG');
    END;
    /

    BEGIN DBMS_LOGMNR.START_LOGMNR (options => dbms_logmnr.dict_from_online_catalog);
    END;
    /

    select SQL_UNDO from
    v$logmnr_contents
    where table_name='PRICELIST'
    AND OPERATION='DELETE'
    ORDER BY TİMESTAMP DESC

    SQL_UNDO
    insert into "BRANCH"."PRICELIST"(........);

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I cannot see any data by using logminor if I dont enable supplemental log.
    >I dont understand why.

    Perhaps if you actually would RTFM
    http://download.oracle.com/docs/cd/B...r.htm#i1014404

    you'd see where it clearly states;
    "Note:
    You must enable supplemental logging prior to generating log files that will be analyzed by LogMiner."
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2008
    Posts
    38
    is it also necessary to add suplemantal logging for mining archivelogs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •