分析数据库日志变化
execute dbms_logmnr.add_logfile(logfilename=>'/oracle/opt/oracle/flash_recovery_area/ORCL/archivelog/2012_12_20/o1_mf_1_3_8f5tk1b6_.arc',options=>dbms_logmnr.new);
/
execute dbms_logmnr.add_logfile(logfilename=>'/oracle/opt/oracle/flash_recovery_area/ORCL/archivelog/2012_12_20/o1_mf_1_2_8f5tbxqf_.arc',options=>dbms_logmnr.addfile);
/
select * from v$archived_log
exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);
/
create table logminer_20121220 tablespace bankuser bank_tbs as
select * from from v$logmnr_contents;
/
exec dbms_logmnr.end_logmnr;
execute dbms_logmnr.add_logfile(logfilename=>'/oracle/opt/oracle/flash_recovery_area/ORCL/archivelog/2012_12_20/o1_mf_1_3_8f5tk1b6_.arc',options=>dbms_logmnr.new);
/
execute dbms_logmnr.add_logfile(logfilename=>'/oracle/opt/oracle/flash_recovery_area/ORCL/archivelog/2012_12_20/o1_mf_1_2_8f5tbxqf_.arc',options=>dbms_logmnr.addfile);
/
select * from v$archived_log
exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);
/
create table logminer_20121220 tablespace bankuser bank_tbs as
select * from from v$logmnr_contents;
/
exec dbms_logmnr.end_logmnr;