1、创建演示数据
SQL> update emp set sal=sal+100 where deptno=10;
SQL> update emp set sal=sal+200 where deptno=20;
SQL> update emp set sal=sal+300 where deptno=30;
SQL> update emp set sal=sal+400 where deptno=40;
SQL> update emp set sal=sal-400 where deptno=10;
2、手动切换归档日志
SQL> alter system switch logfile;
System altered
3、查询归档日志相关信息
SQL> select name,sequence# from v$archived_log;
NAME SEQUENCE#
-------------------------------------------------------------------------------- ----------
/u01/oracle/archive/1_34_895068568.dbf 34
/u01/oracle/archive/1_35_895068568.dbf 35
/u01/oracle/archive/1_36_895068568.dbf 36
3 rows selected
4、添加需要进行解析的日志文件
SQL> exec dbms_logmnr.add_logfile('/u01/oracle/archive/1_34_895068568.dbf',dbms_logmnr.new);
PL/SQL procedure successfully completed
SQL> exec dbms_logmnr.add_logfile('/u01/oracle/archive/1_35_895068568.dbf',dbms_logmnr.addfile);
PL/SQL procedure successfully completed
SQL> exec dbms_logmnr.add_logfile('/u01/oracle/archive/1_36_895068568.dbf',dbms_logmnr.addfile);
PL/SQL procedure successfully completed