flashback database 恢复删除的表空间

当误删除表空间，且没有备份，开启归档和闪回，可使用flashback database恢复表空间

1.数据库版本
sys@TEST> select * from v$version;

BANNER

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

2.要恢复的数据
sys@TEST> select count(*) from test.a;

COUNT(*)

 13238

3.当前的scn
sys@TEST> select current_scn,to_char(sysdate,’yyyy-mm-dd hh24:mi:ss’) from v$database;

CURRENT_SCN TO_CHAR(SYSDATE,’YY

 543532 2015-03-05 16:17:32

4.摹拟误删除表空间

sys@TEST> drop tablespace test including contents and datafiles;

Tablespace dropped.

sys@TEST> select count(*) from test.a;

生活不易，码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠