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

最新推荐文章于 2025-06-20 17:22:23 发布

转载最新推荐文章于 2025-06-20 17:22:23 发布 · 2.1k 阅读

收录于

oracle

当前文章被收录于：

oracle

16 篇文章 0 人学习

订阅专栏查看详情

当前文章被以下社区和专栏收录：

本文展示了如何使用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 ();