1. 内容概述
oracle drop table purge后无有效备份集,信息系统面临业务数据丢失的风险,本文使用bbed工具,针对该场景进行业务数据恢复。
2. 环境准备
create user hsql identified by hsql;grant connect,resource,dba to hsql;drop tablespace hsql including contents and datafiles;create tablespace hsql datafile '/data2/enmo/hsql01.dbf' size 10M autoextend off;drop table hsql.drop_1 purge;create table hsql.drop_1(c_char1 char(10),c_char2 char(10)) tablespace hsql;beginfor i in 1 .. 1000000 loopinsert into hsql.drop_1 values(i,'orastar');end loop;commit;end;/alter system flush shared_pool;alter system flush shared_pool;alter system flush buffer_cache;alter system flush buffer_cache;select count(1) from hsql.drop_1;