logminer来恢复在表DDL之前被删除的数据(4)

继续向logminer增加需要分析的归档重做日志文件
SQL> execute dbms_logmnr.add_logfile(logfilename=>'/u01/app/oracle/flash_recovery_area/JYTEST/archivelog/2016_05_13/o1_mf_1_43_cmbkro1j_.arc',options=>dbms_logmnr.addfile);

PL/SQL procedure successfully completed.

执行分析
SQL> execute dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);

PL/SQL procedure successfully completed.

将分析的内容存储在临时表logmnr_contents中
SQL> create table logmnr_contents as select * from v$logmnr_contents ;

Table created.

终止分析操作
SQL> execute dbms_logmnr.end_logmnr;

PL/SQL procedure successfully completed.

查询T1所产生的日志记录
SQL> select username,scn,timestamp,sql_redo,sql_undo from logmnr_contents where seg_name='T1';