flashback database的例子

sqlplus/ as sysdba
archive log list;
select flashback_on from v$database;
shutdown immediate;
startup mount;
alter database flashback on;
alter database archivelog;
alter database open;
create user test identified by test;
grant resource , connect, unlimited tablespace to test;
conn test/test
create table A (id number);
insert into A values (1);
insert into A values (2);
commit;
exit

sqlplus / as sysdba
select current_scn from v$database;
conn test/test
drop table A;
commit;
exit

sqlplus / as sysdba
shutdown immediate;
startup mount;
flashback database to scn xx;
alter database open resetlogs;
conn test/test
select * from A;
exit

除了用scn之外,也可以使用time.

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

flashback database to timestamp to_timestamp('12-06-22 08:32:24','yy-mm-dd hh24:mi:ss')
alter database open read only;

与falshback database相关的视图

desc v$flashback_database_log;

desc v$flashback_database_stat;