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

来源：互联网发布：美国大使馆pm2.5 知乎编辑：程序博客网时间：2024/04/28 08:20

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 ();