闪回数据库：

1、设置db_recovery_file_dest、db_recovery_file_dest_size

Show parameter db_recover;

Alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';

Alter system set db_recovery_file_dest_size=1g;

2、启动归档模式

3、启动flashback database数据库(在mount下启动）

Select flashback_on from v$database;

Alter database flashback on;

4、设置db_flashback_retention_target;

Alter system set db_flashback_retention_target=1440;

5、启动强制日志模式

Select force_logging from v$database;

alter database force logging;

6、查询当前SCN号

SQL> col current_scn for 9999999999999999

SQL> select current_scn from v$database;

CURRENT_SCN

-----------------

1217740

7、删除一个表test12

Drop table test12;

8、启动数据库到mount下面

Startup mount;

9、flashbackup数据库

Flashback database to scn 1217740

10、打开数据库

Alter database open read only;

11、恢复数据库到当前状态

Recover database;

ITPub博客

测试flashback database