Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    4

    Unanswered: Redo data changes

    Where can i find program like that????

    Log Analyzer for Oracle analyzes log files in Oracle databases and enables DBAs to audit data changes and undo or redo data changes.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Oracle's LogMiner utility ... Works nicely ... you have to have the parameter
    utl_file_dir set before using this

    HTH
    Gregg

  3. #3
    Join Date
    Sep 2004
    Posts
    4
    Quote Originally Posted by gbrabham
    Oracle's LogMiner utility ... Works nicely ... you have to have the parameter
    utl_file_dir set before using this

    HTH
    Gregg
    Thank u but can u say me from where can i download this tool?

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    If you have an Oracle installation , you should have it ...

    ----- Build the LogMiner dictionary -----
    EXECUTE sys.DBMS_LOGMNR_D.BUILD( -
    DICTIONARY_FILENAME =>'1LogMiner_Dictionary.ora', -
    DICTIONARY_LOCATION => 'D:\oracle\admin\....\udump');

    ----- Specify logs you want to analyze ----

    EXECUTE sys.DBMS_LOGMNR.ADD_LOGFILE( -
    LOGFILENAME => 'D:\Oradata\....\Archives\CRE1T001S01098.ARC', -
    OPTIONS => sys.dbms_logmnr.NEW);

    -- Add other logs if you need to --

    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
    LOGFILENAME => 'D:\Oradata\...\Archives\CRE1T001S01099.ARC', -
    OPTIONS => dbms_logmnr.ADDFILE);

    -- Remove logs ---

    EXECUTE SYS.DBMS_LOGMNR.ADD_LOGFILE( -
    LOGFILENAME => 'D:\Oradata\...\Archives\CRE1T001S01099.ARC', -
    OPTIONS => SYS.dbms_logmnr.REMOVEFILE);

    --------- Start LogMiner ------------

    EXECUTE SYS.DBMS_LOGMNR.START_LOGMNR( -
    DICTFILENAME => 'D:\oracle\admin\...\udump\1LogMiner_Dictionary.or a', -
    STARTTIME => to_date('25-MAY-2004 10:00:00', 'DD-MON-YYYY HH24:MIS'), -
    ENDTIME => to_date('25-MAY-2004 11:15:00', 'DD-MON-YYYY HH24:MIS'));

    -- All info --
    SELECT operation, sql_redo FROM v$logmnr_contents;

    -- For a user --
    SELECT sql_redo, sql_undo FROM v$logmnr_contents
    WHERE USERNAME = 'username_to_see';

    --- Occurances for a table ---
    SELECT to_char(timestamp,'HH24:MIS'),USERNAME,OPERATION,STATUS, sql_redo
    FROM v$logmnr_contents
    WHERE SEG_NAME = 'table_name_you_are_looking_for';

    Desc v$logmnr_contents to see your available options ...
    You can also build the UNDO statements to reverse what has been done ...

    Read up on logminer ...

    Gregg

Posting Permissions

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