```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;
```

【FLASHBACK】Oracle閃回及回收站相關語句參考

相關文章