Oracle Log Miner相关
create directory log_dir as 'd:\oraclelogs';
BEGIN
dbms_logmnr_d.build('ora11g.ora', dictionary_location => 'LOG_DIR');
END;
begin
dbms_logmnr.add_logfile('C:\ORACLE\FAST_RECOVERY_AREA\ORCL\ONLINELOG\O1_MF_3_97OZM5HJ_.LOG',dbms_logmnr.NEW);
end;
--利用在线数据字典 exec DBMS_LOGMNR.START_LOGMNR(OPTIONS => SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
跳过build数据字典
begin
dbms_logmnr.start_logmnr(DictFileName => 'd:/oraclelogs/ora11g.ora');
end;
DECLARE
v_index PLS_INTEGER;
BEGIN
v_index := 0;
FOR rec IN (SELECT * FROM v$archived_log g WHERE g.name IS NOT NULL) LOOP
IF v_index = 0 THEN
dbms_logmnr.add_logfile(rec.name, dbms_logmnr.new);
ELSE
dbms_logmnr.add_logfile(rec.name, dbms_logmnr.addfile);
END IF;
v_index := v_index + 1;
END LOOP;
END;
select * from v$logmnr_contents
BEGIN
dbms_logmnr_d.build('ora11g.ora', dictionary_location => 'LOG_DIR');
END;
begin
dbms_logmnr.add_logfile('C:\ORACLE\FAST_RECOVERY_AREA\ORCL\ONLINELOG\O1_MF_3_97OZM5HJ_.LOG',dbms_logmnr.NEW);
end;
--利用在线数据字典 exec DBMS_LOGMNR.START_LOGMNR(OPTIONS => SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
跳过build数据字典
begin
dbms_logmnr.start_logmnr(DictFileName => 'd:/oraclelogs/ora11g.ora');
end;
DECLARE
v_index PLS_INTEGER;
BEGIN
v_index := 0;
FOR rec IN (SELECT * FROM v$archived_log g WHERE g.name IS NOT NULL) LOOP
IF v_index = 0 THEN
dbms_logmnr.add_logfile(rec.name, dbms_logmnr.new);
ELSE
dbms_logmnr.add_logfile(rec.name, dbms_logmnr.addfile);
END IF;
v_index := v_index + 1;
END LOOP;
END;
select * from v$logmnr_contents
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-777006/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
