如题,实验数据如下:Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 
Connected as SYS
 
SQL> select member from v$logfile;
 
MEMBER
--------------------------------------------------------------------------------
E:\ORACLE\ORADATA\ORA248\REDO01.LOG
E:\ORACLE\ORADATA\ORA248\REDO02.LOG
E:\ORACLE\ORADATA\ORA248\REDO03.LOG
 
SQL> exec dbms_logmnr.add_logfile('E:\ORACLE\ORADATA\ORA248\REDO01.LOG',dbms_logmnr.new);
 
PL/SQL procedure successfully completed
 
SQL> exec dbms_logmnr.add_logfile('E:\ORACLE\ORADATA\ORA248\REDO02.LOG',dbms_logmnr.addfile);
 
PL/SQL procedure successfully completed
 
SQL> commit;
 
Commit complete
 
SQL> exec dbms_logmnr.start_logmnr(options=>16);
 
PL/SQL procedure successfully completed
 
SQL> select sql_undo from v$logmnr_contents where seg_name = upper('tc');
 
SQL_UNDO
--------------------------------------------------------------------------------
 
SQL> select sql_redo from v$logmnr_contents where seg_name = upper('tc');
 
SQL_REDO
--------------------------------------------------------------------------------   最后对于sql_undo 和sql_redo 的查询结果均为空,是什么原因造成的?
   数据使用的是归档日志模式。
   
   大家帮忙分析下原因,谢谢!