logmnr 的简单使用:
sqlplus sys/oracle as sysdba
sql> exec dbms_logmnr.add_logile(logfilename=>'归档/联机日志文件名',options=>dbms_logmnr.new);
sql> exec dbms_logmnr.start(options=>dbms_logmnr.dict_from_online_state);
sql> select t.scn,t.timestamp,t.seg_owner,t.operition from v$logmnr_contents t where t.seg_name='TEST';
sql> select t.sql_redo from v$logmnr_contents t where t.seg_name='TEST';
sql> select t.sql_undo from v$logmnr_contents t where t.seg_name='TEST';
sql> exec dbms_logmnr.end_logmnr
sqlplus sys/oracle as sysdba
sql> exec dbms_logmnr.add_logile(logfilename=>'归档/联机日志文件名',options=>dbms_logmnr.new);
sql> exec dbms_logmnr.start(options=>dbms_logmnr.dict_from_online_state);
sql> select t.scn,t.timestamp,t.seg_owner,t.operition from v$logmnr_contents t where t.seg_name='TEST';
sql> select t.sql_redo from v$logmnr_contents t where t.seg_name='TEST';
sql> select t.sql_undo from v$logmnr_contents t where t.seg_name='TEST';
sql> exec dbms_logmnr.end_logmnr
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14359194/viewspace-622508/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14359194/viewspace-622508/