select value from v$parameter where name = 'log_archive_dest';SELECT member FROM v$logfile where rownum = 1;begin execute SYS.DBMS_LOGMNR.ADD_LOGFILE('/zh/oracle/oradata/ora9/redo03.log', sys.dbms_logmnr.New); end;begin sys.dbms_logmnr.add_logfile('/archivelog/archive/log1220127258_1_407.arc', dbms_logmnr.addfile); end;...select min(low_time), max(high_time), min(low_scn), max(next_scn) -1 from V$logmnr_logs;begin SYS.DBMS_LOGMNR.START_LOGMNR(Options => sys.dbms_logmnr.DICT_FROM_ONLINE_CATALOG); end;Select SCN, timestamp, sql_redo, session# session_num, username, session_info From V$LOGMNR_CONTENTS Order by 1; begin SYS.DBMS_LOGMNR.END_LOGMNR(); end;
不过如果你就是DBA的话,去上一下DBA的课
select value from v$parameter where name = 'log_archive_dest';SELECT member FROM v$logfile where rownum = 1;begin
execute SYS.DBMS_LOGMNR.ADD_LOGFILE('/zh/oracle/oradata/ora9/redo03.log', sys.dbms_logmnr.New);
end;begin
sys.dbms_logmnr.add_logfile('/archivelog/archive/log1220127258_1_407.arc', dbms_logmnr.addfile);
end;...select min(low_time), max(high_time),
min(low_scn), max(next_scn) -1
from V$logmnr_logs;begin
SYS.DBMS_LOGMNR.START_LOGMNR(Options => sys.dbms_logmnr.DICT_FROM_ONLINE_CATALOG);
end;Select
SCN,
timestamp,
sql_redo,
session# session_num,
username,
session_info
From V$LOGMNR_CONTENTS
Order by 1;
begin
SYS.DBMS_LOGMNR.END_LOGMNR();
end;