DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: log miner

  1. #1
    Join Date
    Nov 2000
    Posts
    205

    log miner

    If a user deletes/updates records can log miner help retrieve/reverse this. If I have never run the log miner packages etc, could I execute them after the user does this and still be able to retrieve the lost rows?

    Also what happens if these were performed via a package?

    What are the disadvantages of using log miner???

    Thanks in advance,
    Nirasha

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    If a user deletes/updates records can log miner help retrieve/reverse this ?

    -YES-

    AFIK, All Data changes logged in logfile can be reversed.

    [url]http://www.oracle.com/oramag/oracle/99-Sep/59dba2.html[/url]

    [url]http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/archredo.htm#12680[/url]

    [Edited by sreddy on 01-22-2001 at 08:29 PM]

  3. #3
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    log_miner works on Redo Logs or Archived Logs.
    It stores SQLs for all the DMLs as well as SQLs for UNDO of those SQLs.
    So yes, you should be able to run it on any log (and any time as long as you have the log) and get the SQL and then run that SQL to undo the changes.

    I do wish though that log_miner will one day be capable enough to undo DDLs (drop table etc.) but I think that is a much more complicated issue so for the time being we have to live by point-in-time recovery.

    - Rajeev

  4. #4
    Join Date
    Nov 2000
    Posts
    205
    Thanks, yeah I also wish that DDL was catered for (esp since I had to do a painful recovery in my early times and very limited experience due to this). I was just trying to figure out if I did not have these created before the user does this, can I then create it? If the session that deleted it is still open and then I decide to create the dictionary for logminer and use it then to undelete"???

    ALso if it is part of a package is it usable?

    Are there any disadvantages to using this package?
    Thanks again
    Nirasha

  5. #5
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Log_miner is independant of user session; It's just a tool to read the Binary Log file in a Text format.

    As long as your Rego log file has not been written by new data (log switch), you should be able to get the required info. If you are in Archive Log mode then you can always run it on the archive log, you suspect, contains this information (you may have to do a little digging)


    You will need DBMS_LOGMNR package to use the log_miner feature.


    - Rajeev

  6. #6
    Join Date
    Nov 2000
    Posts
    205
    Thanks for all the help..

    Nirasha

Posting Permissions

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


Click Here to Expand Forum to Full Width