Logminer not showing recent actions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Logminer not showing recent actions

  1. #1
    Join Date
    Sep 2007
    Posts
    15

    Logminer not showing recent actions

    I basically follow this procedure:
    The logminer-package is already compiled.
    I add the logfiles (adding all with dbms_logmnr.add_logfile())
    Then I start the logminer - typically dbms_logmnr.start_logmnr(options => dbms_logmnr.dict_from_online_catalog + dbms_logmnr.print_pretty_sql)

    I do a search through v$logmnr_contents and find the expected.

    Now I do some inserts, updates and deletes. Should I expect them to show up when searching v$logmnr_contents or do I have to "start" the logminer again?

    Here's my problem:
    Even if I do restart the logminer (stop it, then start it again), the new inserts, updates and deletes mentioned above do not show in v$logmnr_contents. It still just contains the old ones. Some statements from the 18th, for instance.

    Will they only show after a while? Or what is going on here?

    The code I am using (run one by one, not as a script):
    Code:
    @D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\dbmslm.sql
    grant execute_catalog_role to system
    create public synonym dbms_logmnr for sys.dbms_logmnr
    select distinct member logfilename from v$logfile
    begin
      sys.dbms_logmnr.add_logfile('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG');
      sys.dbms_logmnr.add_logfile('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG');
      sys.dbms_logmnr.add_logfile('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG');
    end;
     
    execute sys.dbms_logmnr.START_LOGMNR(options => sys.dbms_logmnr.dict_from_online_catalog + sys.dbms_logmnr.print_pretty_sql);
     
    select username, to_char(timestamp,'dd/mm/yyyy hh24:mi:ss') timestamp, seg_type_name, table_name, table_space, session# SID, serial#, sql_undo, sql_redo
    from v$logmnr_contents where table_name='RAB_TEST';
    Thank you for any help.

  2. #2
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131

  3. #3
    Join Date
    Sep 2007
    Posts
    15
    Thanks, but this isn't really helping. If you mean "try continuous mine", I have, but I do not get results from it.

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