使用flash闪回数据库



SQL>  create user jiangsir identified by oracle account unlock;

SQL> create table jiangsir (id number,name varchar2(20));

表已创建。

SQL> insert into jiangsir values (1,'name1');

已创建 1 行。

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'YY
-------------------
2016-08-05 16:55:06

drop user jiangsir cascade;

SQL> select * from v$flashback_database_log;

SQL> select * from v$flashback_database_log;

OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TI RETENTION_TARGET FLASHBACK_SIZE
-------------------- ------------------- ---------------- --------------
ESTIMATED_FLASHBACK_SIZE
------------------------
             7505448 2016-08-05 16:27:56             2880      104857600
               221921280

查看可以闪回到的最早时间

select to_char(oldest_flashback_time,'yyyy-mm-dd hh24:mi:ss') from v$flashback_database_log;

SQL> select to_char(oldest_flashback_time,'yyyy-mm-dd hh24:mi:ss') from v$flashback_database_log;

TO_CHAR(OLDEST_FLAS
-------------------
2016-08-05 16:27:56

startup mount;

SQL>  flashback database to timestamp to_date('2016-08-05 16:55:20','yyyy-mm-dd hh24:mi:ss');

闪回完成。

SQL>