Oracle 11g logminer Experiment

The directory for creating the oracle 11g logminer experiment: mkdir-p/home/oracle/logmnr www.2cto.com will be archived to open the archive analysis experiment. Install three packages: dbmslm. SQL dbmslmd. SQL dbmslms. after the SQL statement is completed, set utl_file_dir alter system set utl_file_dir = '/home/oracle/logmnr' scope = spfile; restart to create a data dictionary: begindbms_logmnr_d.build. dat ', dictionary_location =>'/home/oracle/logmnr '); end;/now you can create a list: execute dbms_logmnr.add_logfile (options => dbms_logmnr.new, logfilename => '/home/oracle/app/oracle/oradata/bdlms/redo11.log'); add: execute dbms_logmnr.add_logfile (options => dbms_logmnr.new, logfilename => '/home/oracle/app/oracle/oradata/bdlms/redo21.log'); you can view v $ logmnr_logs to enable log analysis: begindbms_logmnr.start_logmnr (dictfilename => '/home/oracle/logmnr/logminer_dict.dat'); end;/restrictions: begindbms_logmnr.start_logmnr (dictfilename => '/home/oracle/logmnr/logminer_dict.dat', starttime => to_date ('2017-01-01 16:40:23 ', 'yyyy-MM-DD HH24: MI: SS '), endtime => to_date ('1970-01-02 16:40:00', 'yyyy-MM-DD HH24: MI: ss'); end;/observed analysis results: select SQL _redo from v $ logmnr_contents; you can also save this result: create table log_backup as select * from v $ logmnr_contents; finally stop log analysis: execute dbms_logmnr.end_logmnr ();