```sql --检查是否开启闪回 select flashback_on from v$database; show parameter db_recover --检查是否有还原点 select name, scn, time, guarantee_flashback_database,DATABASE_INCARNATION# from v$restore_point; --删除还原点 drop restore point xxx; --检查闪回目录 select * from v$flash_recovery_area_usage; --闪回查询 select * from scott.dept as of timestamp to_timestamp('2017-12-14 16:20:00','yyyy-mm-dd hh24:mi:ss'); select * from scott.dept as of scn 16801523; --闪回表(dml):利用undo历史数据 flashback table scott.dept to timestamp to_timestamp('2017-12-14 16:20:00','yyyy-mm-dd hh24:mi:ss'); select row_movement from dba_tables where table_name='DEPT' and owner='SCOTT'; alter table scott.dept enable row movement; alter table scott.dept disable row movement; --闪回删除表(回收站) show recyclebin; set lines 2000 set pages 999 col owner for a20 col object_name for a40 col type for a10 col ts_name for a15 select owner,object_name,type,ts_name,CREATETIME,DROPTIME,OPERATION from dba_recyclebin; flashback table "BINxxx" to before drop; --闪回全库 flashback database to timestamp to_timestamp('2017-12-14 14:12:46','yyyy-mm-dd HH24:MI:SS'); alter database open resetlogs; --快照闪回 create restore point point_2021 guarantee flashback database; flashback database to restore point point_2021; alter database open resetlogs; ```