如题,实验数据如下: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 的查询结果均为空,是什么原因造成的?
数据使用的是归档日志模式。
大家帮忙分析下原因,谢谢!
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 的查询结果均为空,是什么原因造成的?
数据使用的是归档日志模式。
大家帮忙分析下原因,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货