17,090
社区成员
发帖
与我相关
我的任务
分享
SQL> exec dbms_logmnr.add_logfile('/export/home/oracle/oradata/orcl/redo03.log', dbms_logmnr.new);
PL/SQL procedure successfully completed.
SQL> exec dbms_logmnr.start_logmnr(DictFileName=>'/export/home/oracle/oradata/orcl/logs/testlogmnr.ora');
PL/SQL procedure successfully completed.
SQL> select count(*) from V$LOGMNR_CONTENTS;
COUNT(*)
----------
5443
SQL> select count(*) from v$logmnr_logs;
COUNT(*)
----------
1
SQL> exec dbms_logmnr.end_logmnr;
PL/SQL procedure successfully completed.
SQL> select count(*) from v$logmnr_logs;
COUNT(*)
----------
0