1、设置Flash recovery area：

两个动态参数(db_recovery_file_dest_size和db_recovery_file_dest)

2、设置db_flashback_retention_target

3、设置flashback database为on：

Shutdown immediate;

Startup mount exclusive;

Alter database flashback on;

Alter database open;

4、闪回操作：

Shutdown immediate;

Startup mount;

flashback database to timestamp(to_date('2008-08-07 08:16:07','yyyy-mm-dd hh24:mi:ss'))

alter database open resetlogs;

5、查询：

V$flashback_database_logfile

V$flashback_database_log

V$flashback_database_stat

[@more@]

ITPub博客

Flashback Database