How to use logminer:
1. make sure that sys.dbms_logmnr_d exist(if not , create it with dbmslogmnrd.sql in /rdbms/admin)
2. check utl_file_dir is valid (for example /ora05/logminer)
3. create logminer dictionary file: execute dbms_logmnr_d.build(‘log_dict.txt’,’/ora05/logminer’);
4. identify which archived logs need to be analyzed, these need to be copied to utl_file_dir first
execute dbms_logmnr.add_logfile('/ora05/logminer/arch_POOLDB_0000000015.arc',dbms_logmnr.new);
execute dbms_logmnr.add_logfile('/ora05/logminer/arch_POOLDB_0000000016.arc',dbms_logmnr.addfile);
5start logminer
execute dbms_logmnr.start_logmnr(DICTFILENAME => '/ora05/logminer/log_dict.txt');
6analyze data: select timestamp, username, sql_redo,sql_undo from v$logmnr_contents;
7. end logminer : execute dbms_logmnr.end_logmnr;
|