用Oracle中用闪回flashback技术可以恢复,但是要注意你时间,好像文档说最多只能恢复5天内删除的数据 可以通过时间点和SCN两种方式进行闪回,很简单的: select * from tab as timestamps of .. select * from tab as scn of ..这只是查询出当时的数据,恢复就好办了或者更直接点就是用flashback table 更方便注意时间哦!
你查看下alert.log 看看删除的时间 在用查询闪回 alter table tb enable row movement insert into tb select * from tb as of timestamp to_timestamp('查看的时间','yyyy-mm-dd hh:24:mi:ss')祝你好运
不仅如此,日志中记录的信息还包括:数据库的更改历史、更改类型(INSERT、UPDATE、DELETE、DDL等)、更改对应的SCN号、 以及执行这些操作的用户信息等,LogMiner在分析日志时,将重构等价的SQL语句和UNDO语句(分别记录在V$LOGMNR_CONTENTS 视图的SQL_REDO和SQL_UNDO中)。这里需要注意的是等价语句,而并非原始SQL语句,例如:我们最初执行的是“delete a where c1 <>'cyx';”,而LogMiner重构的是等价的6条DELETE语句。所以我们应该意识到V$LOGMNR_CONTENTS视图中显示的并非 是原版的现实,从数据库角度来讲这是很容易理解的,它记录的是元操作,因为同样是“delete a where c1 <>'cyx';”语句, 在不同的环境中,实际删除的记录数可能各不相同,因此记录这样的语句实际上并没有什么实际意义,LogMiner重构的是在实 际情况下转化成元操作的多个单条语句。
另外由于Oracle重做日志中记录的并非原始的对象(如表以及其中的列)名称,而只是它们在Oracle数据库中的内部编号(对 于表来说是它们在数据库中的对象ID,而对于表中的列来说,对应的则是该列在表中的排列序号:COL 1, COL 2 等),因此 为了使LogMiner重构出的SQL语句易于识别,我们需要将这些编号转化成相应的名称,这就需要用到数据字典(也就说LogMiner 本身是可以不用数据字典的,详见下面的分析过程),LogMiner利用DBMS_LOGMNR_D.BUILD()过程来提取数据字典信息。
--9i下使用logmnr恢复delete删除掉的数据 (10g和11g也可以使用此方法)SQL> select * from v$version;
BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production
SQL> create table ta as select level id, 'test'||level name from dual connect by level < = 10;
ID NAME ---------- --------------------------------------------
SQL> conn sys/sys as sysdba Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 Connected as SYS
SQL> select member from v$logfile;
MEMBER -------------------------------------------------------------------------------- E:\APPLICATION\ORACLE9I\ORADATA\ORA9I\REDO03.LOG E:\APPLICATION\ORACLE9I\ORADATA\ORA9I\REDO02.LOG E:\APPLICATION\ORACLE9I\ORADATA\ORA9I\REDO01.LOG
SQL> select sql_undo from v$logmnr_contents where seg_name = upper('ta');
SQL_UNDO -------------------------------------------------------------------------------- delete from "SCOTT"."TA" where "ID" = '1' and "NAME" = 'test1' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '2' and "NAME" = 'test2' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '3' and "NAME" = 'test3' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '4' and "NAME" = 'test4' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '5' and "NAME" = 'test5' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '6' and "NAME" = 'test6' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '7' and "NAME" = 'test7' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '8' and "NAME" = 'test8' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '9' and "NAME" = 'test9' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '10' and "NAME" = 'test10' and ROWID = 'AA insert into "SCOTT"."TA"("ID","NAME") values ('1','test1'); insert into "SCOTT"."TA"("ID","NAME") values ('2','test2'); insert into "SCOTT"."TA"("ID","NAME") values ('3','test3'); insert into "SCOTT"."TA"("ID","NAME") values ('4','test4'); insert into "SCOTT"."TA"("ID","NAME") values ('5','test5'); insert into "SCOTT"."TA"("ID","NAME") values ('6','test6'); insert into "SCOTT"."TA"("ID","NAME") values ('7','test7'); insert into "SCOTT"."TA"("ID","NAME") values ('8','test8'); insert into "SCOTT"."TA"("ID","NAME") values ('9','test9');
SQL_UNDO -------------------------------------------------------------------------------- insert into "SCOTT"."TA"("ID","NAME") values ('10','test10');
21 rows selected
SQL> select sql_redo from v$logmnr_contents where seg_name = upper('ta');
create table ta as select level id, 'test'||level name from dual connect by leve ;
insert into "SCOTT"."TA"("ID","NAME") values ('1','test1'); insert into "SCOTT"."TA"("ID","NAME") values ('2','test2'); insert into "SCOTT"."TA"("ID","NAME") values ('3','test3'); insert into "SCOTT"."TA"("ID","NAME") values ('4','test4'); insert into "SCOTT"."TA"("ID","NAME") values ('5','test5'); insert into "SCOTT"."TA"("ID","NAME") values ('6','test6'); insert into "SCOTT"."TA"("ID","NAME") values ('7','test7'); insert into "SCOTT"."TA"("ID","NAME") values ('8','test8'); insert into "SCOTT"."TA"("ID","NAME") values ('9','test9'); insert into "SCOTT"."TA"("ID","NAME") values ('10','test10'); delete from "SCOTT"."TA" where "ID" = '1' and "NAME" = 'test1' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '2' and "NAME" = 'test2' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '3' and "NAME" = 'test3' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '4' and "NAME" = 'test4' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '5' and "NAME" = 'test5' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '6' and "NAME" = 'test6' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '7' and "NAME" = 'test7' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '8' and "NAME" = 'test8' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '9' and "NAME" = 'test9' and ROWID = 'AAAH
SQL_REDO -------------------------------------------------------------------------------- delete from "SCOTT"."TA" where "ID" = '10' and "NAME" = 'test10' and ROWID = 'AA
21 rows selectedSQL> select sql_redo from v$logmnr_contents where seg_name = upper('ta');
create table ta as select level id, 'test'||level name from dual connect by leve ;
insert into "SCOTT"."TA"("ID","NAME") values ('1','test1'); insert into "SCOTT"."TA"("ID","NAME") values ('2','test2'); insert into "SCOTT"."TA"("ID","NAME") values ('3','test3'); insert into "SCOTT"."TA"("ID","NAME") values ('4','test4'); insert into "SCOTT"."TA"("ID","NAME") values ('5','test5'); insert into "SCOTT"."TA"("ID","NAME") values ('6','test6'); insert into "SCOTT"."TA"("ID","NAME") values ('7','test7'); insert into "SCOTT"."TA"("ID","NAME") values ('8','test8'); insert into "SCOTT"."TA"("ID","NAME") values ('9','test9'); insert into "SCOTT"."TA"("ID","NAME") values ('10','test10'); delete from "SCOTT"."TA" where "ID" = '1' and "NAME" = 'test1' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '2' and "NAME" = 'test2' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '3' and "NAME" = 'test3' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '4' and "NAME" = 'test4' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '5' and "NAME" = 'test5' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '6' and "NAME" = 'test6' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '7' and "NAME" = 'test7' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '8' and "NAME" = 'test8' and ROWID = 'AAAH delete from "SCOTT"."TA" where "ID" = '9' and "NAME" = 'test9' and ROWID = 'AAAH
SQL_REDO -------------------------------------------------------------------------------- delete from "SCOTT"."TA" where "ID" = '10' and "NAME" = 'test10' and ROWID = 'AA
21 rows selectedSQL> insert into SCOTT.TA(ID,NAME) values ('1','test1');
1 row inserted SQL> insert into SCOTT.TA(ID,NAME) values ('2','test2');
1 row inserted SQL> insert into SCOTT.TA(ID,NAME) values ('3','test3');
1 row inserted SQL> insert into SCOTT.TA(ID,NAME) values ('4','test4');
1 row inserted SQL> insert into SCOTT.TA(ID,NAME) values ('5','test5');
1 row inserted SQL> insert into SCOTT.TA(ID,NAME) values ('6','test6');
1 row inserted SQL> insert into SCOTT.TA(ID,NAME) values ('7','test7');
1 row inserted SQL> insert into SCOTT.TA(ID,NAME) values ('8','test8');
1 row inserted SQL> insert into SCOTT.TA(ID,NAME) values ('9','test9');
1 row inserted SQL> insert into SCOTT.TA(ID,NAME) values ('10','test10');
1 row inserted
SQL> commit;
Commit complete
SQL> conn scott/scott; Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 Connected as scott
flashback query
可以通过时间点和SCN两种方式进行闪回,很简单的:
select * from tab as timestamps of ..
select * from tab as scn of ..这只是查询出当时的数据,恢复就好办了或者更直接点就是用flashback table 更方便注意时间哦!
alter table tb enable row movement
insert into tb select * from tb as of timestamp to_timestamp('查看的时间','yyyy-mm-dd hh:24:mi:ss')祝你好运
深入分析Oracle数据库日志文件作者:程永新 发文时间:2003.09.29 13:52:18
========================================
作为Oracle DBA,我们有时候需要追踪数据误删除或用户的恶意操作情况,此时我们不仅需要查出执行这些操作的数据库账号,
还需要知道操作是由哪台客户端(IP地址等)发出的。针对这些问题,一个最有效实用而又低成本的方法就是分析Oracle数据
库的日志文件。本文将就Oracle日志分析技术做深入探讨。
一、如何分析即LogMiner解释
从目前来看,分析Oracle日志的唯一方法就是使用Oracle公司提供的LogMiner来进行, Oracle数据库的所有更改都记录在日志
中,但是原始的日志信息我们根本无法看懂,而LogMiner就是让我们看懂日志信息的工具。从这一点上看,它和tkprof差不多,
一个是用来分析日志信息,一个则是格式化跟踪文件。通过对日志的分析我们可以实现下面的目的:
1、查明数据库的逻辑更改;
2、侦察并更正用户的误操作;
3、执行事后审计;
4、执行变化分析。
不仅如此,日志中记录的信息还包括:数据库的更改历史、更改类型(INSERT、UPDATE、DELETE、DDL等)、更改对应的SCN号、
以及执行这些操作的用户信息等,LogMiner在分析日志时,将重构等价的SQL语句和UNDO语句(分别记录在V$LOGMNR_CONTENTS
视图的SQL_REDO和SQL_UNDO中)。这里需要注意的是等价语句,而并非原始SQL语句,例如:我们最初执行的是“delete a
where c1 <>'cyx';”,而LogMiner重构的是等价的6条DELETE语句。所以我们应该意识到V$LOGMNR_CONTENTS视图中显示的并非
是原版的现实,从数据库角度来讲这是很容易理解的,它记录的是元操作,因为同样是“delete a where c1 <>'cyx';”语句,
在不同的环境中,实际删除的记录数可能各不相同,因此记录这样的语句实际上并没有什么实际意义,LogMiner重构的是在实
际情况下转化成元操作的多个单条语句。
另外由于Oracle重做日志中记录的并非原始的对象(如表以及其中的列)名称,而只是它们在Oracle数据库中的内部编号(对
于表来说是它们在数据库中的对象ID,而对于表中的列来说,对应的则是该列在表中的排列序号:COL 1, COL 2 等),因此
为了使LogMiner重构出的SQL语句易于识别,我们需要将这些编号转化成相应的名称,这就需要用到数据字典(也就说LogMiner
本身是可以不用数据字典的,详见下面的分析过程),LogMiner利用DBMS_LOGMNR_D.BUILD()过程来提取数据字典信息。
LogMiner包含两个PL/SQL包和几个视图:
1、dbms_logmnr_d包,这个包只包括一个用于提取数据字典信息的过程,即dbms_logmnr_d.build()过程。
2、dbms_logmnr包,它有三个过程:
add_logfile(name varchar2, options number) - 用来添加/删除用于分析的日志文件;
start_logmnr(start_scn number, end_scn number, start_time number,end_time number,
dictfilename varchar2, options number) - 用来开启日志分析,同时确定分析的时间/SCN窗口以及确认是否使用提取出
来的数据字典信息。
end_logmnr() - 用来终止分析会话,它将回收LogMiner所占用的内存。
与LogMiner相关的数据字典。
1、v$logmnr_dictionary,LogMiner可能使用的数据字典信息,因logmnr可以有多个字典文件,该视图用于显示这方面信息。
2、v$logmnr_parameters,当前LogMiner所设定的参数信息。
3、v$logmnr_logs,当前用于分析的日志列表。
4、v$logmnr_contents,日志分析结果。
二、Oracle9i LogMiner的增强:
1、支持更多数据/存储类型:链接/迁移行、CLUSTER表操作、DIRECT PATH插入以及DDL操作。在V$LOGMNR_CONTENTS的
SQL_REDO中可以看到DDL操作的原句(CREATE USER除外,其中的密码将以加密的形式出现,而不是原始密码)。如果
TX_AUDITING初始化参数设为TRUE,则所有操作的数据库账号将被记录。
2、提取和使用数据字典的选项:现在数据字典不仅可以提取到一个外部文件中,还可以直接提取到重做日志流中,它在日志
流中提供了操作当时的数据字典快照,这样就可以实现离线分析。
3、允许对DML操作按事务进行分组:可以在START_LOGMNR()中设置COMMITTED_DATA_ONLY选项,实现对DML操作的分组,这样
将按SCN的顺序返回已经提交的事务。
4、支持SCHEMA的变化:在数据库打开的状态下,如果使用了LogMiner的DDL_DICT_TRACKING选项,Oracle9i的LogMiner将
自动对比最初的日志流和当前系统的数据字典,并返回正确的DDL语句,并且会自动侦察并标记当前数据字典和最初日志流之
间的差别,这样
1.oracle9i: 可以使用LogMiner恢复。
2.oracle10g、11g: 可以使用LogMiner、flashback query、
flashback table、flashback database等方法恢复
--9i下使用logmnr恢复delete删除掉的数据 (10g和11g也可以使用此方法)SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
SQL> create table ta as select level id, 'test'||level name from dual connect by level < = 10;
Table created
SQL> select * from ta;
ID NAME
---------- --------------------------------------------
1 test1
2 test2
3 test3
4 test4
5 test5
6 test6
7 test7
8 test8
9 test9
10 test10
10 rows selected
SQL> delete from ta;
10 rows deleted
SQL> commit;
Commit complete
SQL> select * from ta;
ID NAME
---------- --------------------------------------------
SQL> conn sys/sys as sysdba
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as SYS
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
E:\APPLICATION\ORACLE9I\ORADATA\ORA9I\REDO03.LOG
E:\APPLICATION\ORACLE9I\ORADATA\ORA9I\REDO02.LOG
E:\APPLICATION\ORACLE9I\ORADATA\ORA9I\REDO01.LOG
SQL> exec dbms_logmnr.add_logfile('E:\APPLICATION\ORACLE9I\ORADATA\ORA9I\REDO01.LOG',dbms_logmnr.new);
PL/SQL procedure successfully completed
SQL> exec dbms_logmnr.add_logfile('E:\APPLICATION\ORACLE9I\ORADATA\ORA9I\REDO02.LOG',dbms_logmnr.addfile);
PL/SQL procedure successfully completed
SQL> exec dbms_logmnr.start_logmnr(options=>16);
PL/SQL procedure successfully completed
SQL> select sql_undo from v$logmnr_contents where seg_name = upper('ta');
SQL_UNDO
--------------------------------------------------------------------------------
delete from "SCOTT"."TA" where "ID" = '1' and "NAME" = 'test1' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '2' and "NAME" = 'test2' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '3' and "NAME" = 'test3' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '4' and "NAME" = 'test4' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '5' and "NAME" = 'test5' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '6' and "NAME" = 'test6' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '7' and "NAME" = 'test7' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '8' and "NAME" = 'test8' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '9' and "NAME" = 'test9' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '10' and "NAME" = 'test10' and ROWID = 'AA
insert into "SCOTT"."TA"("ID","NAME") values ('1','test1');
insert into "SCOTT"."TA"("ID","NAME") values ('2','test2');
insert into "SCOTT"."TA"("ID","NAME") values ('3','test3');
insert into "SCOTT"."TA"("ID","NAME") values ('4','test4');
insert into "SCOTT"."TA"("ID","NAME") values ('5','test5');
insert into "SCOTT"."TA"("ID","NAME") values ('6','test6');
insert into "SCOTT"."TA"("ID","NAME") values ('7','test7');
insert into "SCOTT"."TA"("ID","NAME") values ('8','test8');
insert into "SCOTT"."TA"("ID","NAME") values ('9','test9');
SQL_UNDO
--------------------------------------------------------------------------------
insert into "SCOTT"."TA"("ID","NAME") values ('10','test10');
21 rows selected
SQL> select sql_redo from v$logmnr_contents where seg_name = upper('ta');
SQL_REDO
--------------------------------------------------------------------------------
create table ta as select level id, 'test'||level name from dual connect by leve
;
insert into "SCOTT"."TA"("ID","NAME") values ('1','test1');
insert into "SCOTT"."TA"("ID","NAME") values ('2','test2');
insert into "SCOTT"."TA"("ID","NAME") values ('3','test3');
insert into "SCOTT"."TA"("ID","NAME") values ('4','test4');
insert into "SCOTT"."TA"("ID","NAME") values ('5','test5');
insert into "SCOTT"."TA"("ID","NAME") values ('6','test6');
insert into "SCOTT"."TA"("ID","NAME") values ('7','test7');
insert into "SCOTT"."TA"("ID","NAME") values ('8','test8');
insert into "SCOTT"."TA"("ID","NAME") values ('9','test9');
insert into "SCOTT"."TA"("ID","NAME") values ('10','test10');
delete from "SCOTT"."TA" where "ID" = '1' and "NAME" = 'test1' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '2' and "NAME" = 'test2' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '3' and "NAME" = 'test3' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '4' and "NAME" = 'test4' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '5' and "NAME" = 'test5' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '6' and "NAME" = 'test6' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '7' and "NAME" = 'test7' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '8' and "NAME" = 'test8' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '9' and "NAME" = 'test9' and ROWID = 'AAAH
SQL_REDO
--------------------------------------------------------------------------------
delete from "SCOTT"."TA" where "ID" = '10' and "NAME" = 'test10' and ROWID = 'AA
21 rows selectedSQL> select sql_redo from v$logmnr_contents where seg_name = upper('ta');
SQL_REDO
--------------------------------------------------------------------------------
create table ta as select level id, 'test'||level name from dual connect by leve
;
insert into "SCOTT"."TA"("ID","NAME") values ('1','test1');
insert into "SCOTT"."TA"("ID","NAME") values ('2','test2');
insert into "SCOTT"."TA"("ID","NAME") values ('3','test3');
insert into "SCOTT"."TA"("ID","NAME") values ('4','test4');
insert into "SCOTT"."TA"("ID","NAME") values ('5','test5');
insert into "SCOTT"."TA"("ID","NAME") values ('6','test6');
insert into "SCOTT"."TA"("ID","NAME") values ('7','test7');
insert into "SCOTT"."TA"("ID","NAME") values ('8','test8');
insert into "SCOTT"."TA"("ID","NAME") values ('9','test9');
insert into "SCOTT"."TA"("ID","NAME") values ('10','test10');
delete from "SCOTT"."TA" where "ID" = '1' and "NAME" = 'test1' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '2' and "NAME" = 'test2' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '3' and "NAME" = 'test3' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '4' and "NAME" = 'test4' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '5' and "NAME" = 'test5' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '6' and "NAME" = 'test6' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '7' and "NAME" = 'test7' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '8' and "NAME" = 'test8' and ROWID = 'AAAH
delete from "SCOTT"."TA" where "ID" = '9' and "NAME" = 'test9' and ROWID = 'AAAH
SQL_REDO
--------------------------------------------------------------------------------
delete from "SCOTT"."TA" where "ID" = '10' and "NAME" = 'test10' and ROWID = 'AA
21 rows selectedSQL> insert into SCOTT.TA(ID,NAME) values ('1','test1');
1 row inserted
SQL> insert into SCOTT.TA(ID,NAME) values ('2','test2');
1 row inserted
SQL> insert into SCOTT.TA(ID,NAME) values ('3','test3');
1 row inserted
SQL> insert into SCOTT.TA(ID,NAME) values ('4','test4');
1 row inserted
SQL> insert into SCOTT.TA(ID,NAME) values ('5','test5');
1 row inserted
SQL> insert into SCOTT.TA(ID,NAME) values ('6','test6');
1 row inserted
SQL> insert into SCOTT.TA(ID,NAME) values ('7','test7');
1 row inserted
SQL> insert into SCOTT.TA(ID,NAME) values ('8','test8');
1 row inserted
SQL> insert into SCOTT.TA(ID,NAME) values ('9','test9');
1 row inserted
SQL> insert into SCOTT.TA(ID,NAME) values ('10','test10');
1 row inserted
SQL> commit;
Commit complete
SQL> conn scott/scott;
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as scott
SQL> select * from ta;
ID NAME
---------- --------------------------------------------
1 test1
2 test2
3 test3
4 test4
5 test5
6 test6
7 test7
8 test8
9 test9
10 test10
10 rows selected--sql_redo:显示的是所做的操作(SQL 语句);
--sql_undo:显示的是要恢复该操作所需要的SQL语句;
1\用LogMiner找回数据.
2\将数据库恢复到一个新实例中,指定恢复到删除前的时间点,然后把数据导回来..