flashback 汇总

flashback query

select * from t as of timestamp to_date(sysdate,'yyyy-mm-dd hh24:mi:ss')

select * from t as of scn 46210894

 

flashback table

flashback table to before drop

alter table name enable row move

flashback table to scn 542640

flashback versions query中出现的伪列，放在这里备查。

scn：

select versions_operation,versions_startscn,versions_endscn,
versions_starttime,versions_endtime,versions_xid,id,name
from t versions between scn minvalue and maxvalue

--=========================================

timestamp：

select versions_operation,versions_startscn,versions_endscn,
versions_starttime,versions_endtime,versions_xid,id,name
from t versions between timestamp minvalue and maxvalue

select * form v$flash_recovery_area_usage

select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;

show parameter recover

rman target /

crosscheck archivelog all

delete expirec archivelog all

delete archivelog unitl time 'sysdate-1'

shutdown immediate;

startup mount

ater database noarchivelog;

alter database open;

shutdwn immiediate;

startup mount

alter database archivelog

archive log list

alter database open

select group#,sequence# from v$log

alter database clear unarchived logfile group 1;