利用redolog日志查看删除的表结构

最新推荐文章于 2024-10-18 22:04:05 发布

转载最新推荐文章于 2024-10-18 22:04:05 发布 · 2k 阅读

oracle 专栏收录该内容

16 篇文章

订阅专栏

本文展示了如何使用Oracle的DBMS_LOGMNR过程来添加并分析重做日志文件，通过查询V$LOGMNR_CONTENTS视图获取特定表的SQL重做和撤销日志。

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/home/ora10g/oradata/orcl/redo03.log
/home/ora10g/oradata/orcl/redo02.log
/home/ora10g/oradata/orcl/redo01.log

SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE('/home/ora10g/oradata/orcl/redo01.log',DBMS_LOGMNR.NEW);
PL/SQL procedure successfully completed.
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE('/home/ora10g/oradata/orcl/redo02.log',DBMS_LOGMNR.ADDFILE);
PL/SQL procedure successfully completed.
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE('/home/ora10g/oradata/orcl/redo03.log',DBMS_LOGMNR.ADDFILE);
PL/SQL procedure successfully completed.
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(options=>16);
PL/SQL procedure successfully completed.
SQL> select sql_redo from v$logmnr_contents where seg_name='TEST';
SQL_REDO
--------------------------------------------------------------------------------
drop table test;
create table test(id integer,name varchar(20));

SQL>select sql_undo from v$logmnr_contents where SEG_NAME='TEST';

SQL>EXECUTE DBMS_LOGMNR.END_LOGMNR ();