简单列下命令
sqlplus 操作
设置会话时间格式,便于精确定位:
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
exec sys.dbms_logmnr.add_logfile(logfilename=>''F:\rmanbackup\ORCL\ARCHIVELOG\2013_05_13\O1_MF_1_658_8S0MHZ8S_.ARC');
exec sys.dbms_logmnr.start_logmnr(options=>sys.dbms_logmnr.dict_from_online_catalog);
select * from v$logmnr_contents;
exec sys.dbms_logmnr.end_logmnr;
..... 后续补充