误删表和误删数据的简单恢复

--用户错误

--用户删除了表。

EODA@PROD1> drop table emp;

Table dropped.

EODA@PROD1> show recyclebin;
ORIGINAL NAME	 RECYCLEBIN NAME		OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
EMP		 BIN$Qr5e5x07FiPgU0edqMAAkA==$0 TABLE	     2016-12-03:17:06:32
EODA@PROD1> flashback table emp to before drop; 

Flashback complete.

EODA@PROD1> select count(*) from emp;

  COUNT(*)
----------
	14
	
	
--用户无意中删除或修改了数据。
SCOTT@PROD1> update emp set sal = sal + 1;

14 rows updated.

SCOTT@PROD1> commit;

Commit complete.

SCOTT@PROD1> col VERSIONS_STARTTIME for a40
SCOTT@PROD1> select sal,versions_starttime from emp versions between scn minvalue and maxvalue where empno=7934;

       SAL VERSIONS_STARTTIME
---------- ----------------------------------------
      1301 05-DEC-16 09.55.25 PM
      1300

SCOTT@PROD1> alter table emp enable row movement;

Table altered.

SCOTT@PROD1> flashback table emp to timestamp to_timestamp('05-DEC-16 09.55.25','dd-mon-yy hh24.mi.ss');  

Flashback complete.

SCOTT@PROD1> alter table emp disable row movement;

Table altered.

SCOTT@PROD1> select sal from emp where empno=7934;

       SAL
----------
      1300