用Flashback database功能恢复用户错误

核心提示： （2）闪回日志注释：Oracle会在闪回区来记录日志。$ pwd/data5/flash_recovery_area/EYGLE/flashback$ ls -ltotal 32064-rw-r- 1 oracle dba8200192 Mar 29 16:49 o1_mf_14l5bcl

（2）闪回日志

注释：Oracle会在闪回区来记录日志。

$ pwd
/data5/flash_recovery_area/EYGLE/flashback
$ ls -l
total 32064
-rw-r-----　 1 oracle　 dba　　　8200192 Mar 29 16:49 o1_mf_14l5bclp_.flb
-rw-r-----　 1 oracle　 dba　　　8200192 Mar 29 17:31 o1_mf_14l6w5h4_.flb

（3）然后模拟用户错误

SYS AS SYSDBA on 2005-03-29 17:01:44 >archive log list;
Database log mode　　　　　　　Archive Mode
Automatic archival　　　　　　 Enabled
Archive destination　　　　　　USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence　　 0
Next log sequence to archive　 1
Current log sequence　　　　　 1
SYS AS SYSDBA on 2005-03-29 17:01:55 >select sysdate from dual;
SYSDATE
-------------------
2005-03-29 17:02:09
SYS AS SYSDBA on 2005-03-29 17:02:16 >drop table t3;
Table dropped.
SYS AS SYSDBA on 2005-03-29 17:02:22 >select sysdate from dual;
SYSDATE
-------------------
2005-03-29 17:02:28
SYS AS SYSDBA on 2005-03-29 17:02:28 >create table t1 as select *
from dba_users;
Table created.
SYS AS SYSDBA on 2005-03-29 17:02:42 >select sysdate from dual;
SYSDATE
-------------------
2005-03-29 17:02:48
SYS AS SYSDBA on 2005-03-29 17:02:48 >create table t2 as select *
from dba_tablespaces;
Table created.
SYS AS SYSDBA on 2005-03-29 17:03:01 >select sysdate from dual;
SYSDATE
-------------------
2005-03-29 17:03:06
SYS AS SYSDBA on 2005-03-29 17:03:06 >select sysdate from dual;
SYSDATE
-------------------
2005-03-29 17:03:17