SQL> select member from v$logfile where group#=1;
MEMBER
--------------------------------------------------------------------------------
/oradata/oradg/redo01.log
--------------------------------------------------------------------------------
/oradata/oradg/redo01.log
SQL> exec dbms_logmnr.add_logfile('/oradata/oradg/redo01.log');
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/arch/oradg/1_35_744305733.dbf',OPTIONS => DBMS_LOGMNR.NEW);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/arch/oradg/1_35_744305733.dbf',OPTIONS => DBMS_LOGMNR.NEW);
PL/SQL procedure successfully completed.
SQL> exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);
SQL> exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);
PL/SQL procedure successfully completed.
SQL> select count(*) from v$logmnr_contents;
COUNT(*)
----------
58252
----------
58252
转载于:https://blog.51cto.com/marvelyu/511777