HOW TO RECOVER A DELETED TABLESPACE ?
1,ORACLE 10.2 + WINDOWS 2003
2,ARCHIVELOG ON , FLASHBACK DATABASE ON
3, HAVE USED RMAN BACKUP THE TABLESPACE TST BEFORE DELETE IT. BUT THERE IS
NO FULL DATABASE BACKUP HEREIN.
4, DELETE TABLESPACE TST INCLUDING DATAFILES.
QUESTION:
WHAT SHOULD I DO FOR RECOVERING THE DELETED TABLESPACE TST ?
Drop tablespace 如果没有写including contents and datafiles的话,那么对应数据文件应该还在。如果写了的话。那么首先推荐使用磁盘扫描工具或prm-scan将数据文件找回来。
由于drop tablespace已经清除了数据字典中的相关信息,因此之后推荐使用prm-dul对数据文件进行非字典模式扫描,然后将数据抽取出来。