--设置utl参数,并指定数据字典文件,指定数据挖掘的表空间alter system set utl_file_dir='/home/oracle/log' scope=spfile;shutdown immediate
startup mount
--查询是否开启最小补充日志SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM v$database;--数据库启用最小补充日志ALTERDATABASEADD SUPPLEMENTAL LOG DATA;--添加数据字典begin
dbms_logmnr_d.build(dictionary_filename =>'logmrn.ora',dictionary_location =>'/home/oracle/log');end;begin
DBMS_LOGMNR_D.SET_TABLESPACE('SYSTEM');end;
2. 查询归档日志路径
select a.*,'DBMS_LOGMNR.ADD_LOGFILE(LogFileName=>'''||NAME||''', Options=>dbms_logmnr.addfile);'from V$ARCHIVED_LOG a
where a.COMPLETION_TIME >= to_date('2024-4-9 18','YYYY-MM-DD HH24')AND a.COMPLETION_TIME <= to_date('2024-4-9 18','YYYY-MM-DD HH24')orderby COMPLETION_TIME;