【实践记录】Oracle关于数据闪回的实践记录

–创建测试表

create table flash_test as
select * from dba_objects where object_type=‘TABLE’ and OWNER like ‘%SYS%’;

–查询表的数据的存储时间

select sysdate from dual; --2020-12-02 19:17:38

–删除表的数据

delete from flash_test;

–确认删除有效

select * from flash_test;

–提交确认

commit

–执行查询，查看指定时间的时候的对应记录

select count(*) from flash_test as of timestamp to_timestamp(‘2020-12-02 19:18:48’,‘yyyy-mm-dd hh24:mi:ss’);

–执行闪回，初步会出现报错

flashback table flash_test to timestamp to_timestamp(‘2020-12-02 19:18:48’,‘yyyy-mm-dd hh24:mi:ss’);

–修改表允许行移动

alter table flash_test1 enable row movement;

–执行闪回

flashback table flash_test1 to timestamp to_timestamp(‘2020-12-02 19:14:37’,‘yyyy-mm-dd hh24:mi:ss’);

–查询结果

select * from flash_test;